SQL - import when upgrading - HELP!

**cotswold** · 12 Sep 2007, 08:42 PM

[FONT=Calibri]Ok so we have swapped servers[/FONT]

[FONT=Calibri]Our new one is php 5.2.0, so have no option but to install v1.3.7, otherwise a fatal error on admin logon develops. [/FONT]

[FONT=Calibri]So installed v1.3.7 - working fine with a brand new database. [/FONT]
[FONT=Calibri]However when I try to drop the old SQL tables into the new database I get the following error: [/FONT]

[FONT=Calibri]"1146 Table 'cotharyy_zenCS.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]"[/FONT]

This is a reference to the old database, not the new one

Can anyone help out a confused person with little knowledge (enough to be dangerous though!!!

)

**dbltoe** · 12 Sep 2007, 11:56 PM

It appears that your prefixes for the two databases do not match. If the old was zencart_configuration and was trying to load into zen_configuration, you'd get this kind of problem. Try using a text editor to change a SAVED version of the sql file to change the prefixes.

**DrByte** · 13 Sep 2007, 01:50 AM

... or just be sure to use the same DB_PREFIX setting in your new configure.php files as you were using in the old configure.php files prior to the move.

**dbltoe** · 13 Sep 2007, 03:40 AM

yep, tried that on one occasion but the host set their own prefix.

**DrByte** · 13 Sep 2007, 04:05 AM

Fair enough.

I'm just hesitant to tell anyone to do a global search/replace because unless they manually check EACH instance before replacing, they "might" be editing wrong stuff.
Some folks assume that they can fix their SQL content by renaming "zen_" is safe ... when it's actually very dangerous.
Just something that needs to be kept in mind when doing search/replaces.

**dbltoe** · 13 Sep 2007, 04:23 AM

ABSOLUTELY, should have mentioned that. At least I said use a copy.

**cotswold** · 14 Sep 2007, 12:34 AM

Thanks all, now have zencart up and running having manually renamed the files. I now have a

Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels. Here it shows Zen Cart 1.3.7.1 Database Patch level: 1.3.6

PHP Version: 5.2.0 (Zend: 2.2.0)
Database Host: localhost (127.0.0.1)
Database: MySQL 5.0.27-standard

What is the best way to fix this?

**DrByte** · 14 Sep 2007, 12:37 AM

Originally Posted by cotswold

Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels. Here it shows Zen Cart 1.3.7.1 Database Patch level: 1.3.6

You need to run zc_install/index.php, choose Database Setup on the inspection screen, and complete the upgrade steps checked.

**cotswold** · 14 Sep 2007, 08:54 AM

Great that fixed the problem, thanks for your help.

**CurrentWave** · 9 Oct 2007, 06:11 PM

Dear Dr. Byte, I followed your instructions to Cotswold, but after running for several minutes the window just went blank, white to be specific.

So I went back to the beginning of the install and went through clicking Continue and then agreeing to the terms and at the update page typing in my username and password and then clicking Update Database, but the screen went blank right away.

So I cleared my cache files and did it all again, this time it went the same as the first time, blank after a very long time of what appeared to be working. About 1:00am I went to bed. When I tried it this morning it's still the same.

So what do I do now? I'm stuck.... please help me Dr.

Thank you