1146

Locked

Started by harry2cool on 21 Jul 2006, 5:41 AM · Views: 1,867

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,511
Plugin Contributions:
176

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

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