1146

[harry2cool]

I've been searching the foruns for 12 hours now, but did not get a solution to my problem.

I have just moved my zen cart 1.2 to a newer host.

I managed to FTP the contents on a fresh install as directed by the notes on Zen Cart "Question and Answers" link.

Also imported the tables as per the information.

Now when I try to access the admin I get the error:
1146 Table 'xyz.xxx.project_version' doesn't exist

And when I try to access the index.php I get the error:
1146 Table 'xyz.xxx..configuration' doesn't exist

I checked in "Myphp" and both these table do exist.
The name of the tabels are zen_project_version and same prefix for configuration

Please let me know where can I be wrong.

Thx

[DrByte]

xyz.xxx.project_version

The format of that message is:
database_name.table_name

ie: fredstore.project_version

If you have table-prefixes in use, then it would be:
database_name.tableprefix+table_name

ie: fredstore.zen_project_version

I'm guessing that xyz.xxx in your examples are identical?

It would seem that your server is looking for a database named "fredstore" when really it's now "newserverstore" or something.

DB_DATABASE needs to be set in your configure.php file to match the name of your NEW server's database into which you have imported your old Zen Cart tables.

DB_PREFIX must be the SAME as you had on your old server, since you haven't renamed your tables to remove prefixes, etc.

[harry2cool]

Thanks, I will look into this , this seems to be the problem.

[harry2cool]

problem solved,

the old database had a prefix, the new one did not,

thx,

rgds

harry