Error after MySQL Import

[paults]

a) I am doing a freash install of 1.3.7, and importing older 1.2.6 database.

When I try to access the cart homepage located here:

www.synthtech.com/testcart

I get this message:


1054 Unknown column 'startdate' in 'field list'
in:
[select startdate, counter, session_counter from counter_history where startdate='20070526']

and I get a similar version right after I log into the Admin.

b) It is also complaining about a need to update the Patch Level on the database. I appears that there is a script to me cut/pasted into a dialog box. Where/which file on the server is this?

The Server Info states the Database Patch Level as 1.2.6

Rather than doing an "update" on the older Zencart, I did a freash install into the /testcart directory.

Paul S.

[Ajeh]

Did you run the Upgrade on the database for the:
/zc_install

And go through each of the updates for the various versions?

[paults]

OK, I see that the Database Version should match the ZenCart Version :)

I did successfully uploaded/ran the 1.2.6 to 1.2.7 script (found them in the zc_install directory)

But when I try the second script (1.2.7 to 1.3.0) I get this message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0', '1'), ', now())' at line 1

This is the fist non-comment SQL command, something about BreadCrumbs?

Paul S.

[paults]

For some reason, the SQL patch from 1.2.7 to 1.3.0 would always give me this error running the SQL Patch from the Admin panel. But running the zc_intstall and selecting DB Upgrade, and then checking down all of the boxes to 1.3.7 and running did work.

[Ajeh]

Glad you have things up and running ... thanks for the update