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

[DrByte]

You said the error message is: "Table 'dbname.configuration' doesn't exist"

Does "dbname" match what your DB_DATABASE setting is in your configure.php file?
Does DB_PREFIX match the DB_PREFIX from your previous install? (note step 2(a) in the article I linked to earlier)

[starmands]

Yes it shows the correct database name. For example my database name from my other site is _zc1 and the new one that I created for the new site is _zc2 and that is what is in the config file. The user name is different in the new config than the old one but when I created the database (_zc2) I set up the new username.

[DrByte]

And the DB_PREFIX?

[starmands]

Yes I set the DB_Prefix the same as the site that I copied over.

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