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

[DrByte]

So what is DB_PREFIX set to?

And since Zen Cart uses DB_PREFIX when making its queries, and automatically inserts that prefix before the table name, why is Zen Cart looking for "configuration" instead of "yourprefix_configuration"?
That tells me that the /includes/configure.php file does NOT include your prefix.

Remember, the configure.php files are marked as read-only, and in that state any upload or edit you attempt will fail. Must make it writable before you can save changes to it.

[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.

[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]

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]

[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.