Addon Domain - 1146 Table 'database .configuration' doesn't exist

[starmands]

The DB_Prefix is zen_ the same as the other site. When I look at the config file in file manager on my site the zen_ prefix is there. When I changed it I had write authority.

[starmands]

The actual errot is as follows:

1146 Table 'mydatabasename_zc_2.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

[DrByte]

If Zen Cart is seeing the correct configure.php files then the error message would have included the prefix.
Since it doesn't, then that means your configure.php files have the wrong information.

[starmands]

What would be the reason that I can access the site via Admin but not from the web using the url and /index.php? I can make modifications in admin so that must be using the database! Could it be a problem with the PHP file? I used the generic one from the install and also tried the one from the other site.

[DrByte]

There are 2 configure.php files. If your admin works fine then that suggests your admin file is fine. But if your storefront does not, then that tells me that your non-admin file is not correct.

[starmands]

This is what the config file in /includes looks like:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'myusername');
define('DB_SERVER_PASSWORD', 'mypassword');
define('DB_DATABASE', 'database_zc2');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

[DrByte]

And how does that differ from those same settings in your admin file?

[starmands]

Where do I find the config file for admin? Is it the configuration.php in /admin/configuration.php? If so that file looks completly different than the one I pasted from /admin/includes/configuration.php. There doesn't appear to be any settings to change in the /admin/coniguration.php all seem to be variables!

[DrByte]

/admin/includes/configure.php
/includes/configure.php

The files are NEVER COMPLETELY IDENTICAL, but do have many similarities.
But the DB_XXXXXX settings DO NEED TO BE IDENTICAL in both files.

[starmands]

OK, I was looking at the wrong config file!! I was looking at the root directory config file instead of the /includes/configuration.php file. The configuration file had the DB_Prefix as ''.

Problem solved. Thank you so much.