Zen Cart Logo

1146

Locked

Views: 1,858

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
21 Jul 2006, 5:41 AM
#1
harry2cool avatar

harry2cool

Zen Follower

Join Date:
Oct 2005
Posts:
280
Plugin Contributions:
0

1146

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

21 Jul 2006, 5:50 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: 1146

xyz.xxx.project_versionThe 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.

21 Jul 2006, 6:20 AM
#3
harry2cool avatar

harry2cool

Zen Follower

Join Date:
Oct 2005
Posts:
280
Plugin Contributions:
0

Re: 1146

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

22 Jul 2006, 10:49 AM
#4
harry2cool avatar

harry2cool

Zen Follower

Join Date:
Oct 2005
Posts:
280
Plugin Contributions:
0

Re: 1146

problem solved,

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

thx,

rgds

harry