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

[starmands]

Hi I'm using 1.3.9d. I have studied all of the threads on this but my problem is slightly different. I want to create a copy of my primary domain in an addon domain so I have created an addon domain (this is redirected to my primary domain for now) and completed a clean install of 1.3.9d and followed the installation notes. I have now copied my primary domain folders and files over checked and rechecked the modified configuration.php files. I can get into admin ok with the addon domain and everything is there from my primary domain but when I try to go into the site as a user www.mywebsite.ca/index.php I get the 1146 table error - 1146 Table 'dbname.configuration' doesn't exist in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]
Any help would be appreciated.

Thanks

[DrByte]

Instead of copying your existing site first, you should FIRST install a fresh new copy of Zen Cart in the new domain, and get THAT working FIRST.
https://www.zen-cart.com/tutorials/i...hp?article=100

[starmands]

Yes that's what I did. Everything worked before I copied my other site files and database over.

[DrByte]

When you copied the files over, did you mistakenly overwrite the new configure.php files that were built by the fresh install?

[starmands]

No, I renamed both config files before copying the other system over then put the new config files back. When I look at the new config files they seem to have all of the correct information.

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