Zen Cart Logo
Forums / General Questions / upgrading - DB issues

upgrading - DB issues

Locked

Views: 1,189

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
3 Oct 2006, 8:12 PM
#1
atsdotha avatar

atsdotha

Zen Follower

Join Date:
Jul 2005
Location:
Dothan, AL
Posts:
328
Plugin Contributions:
0

upgrading - DB issues

Ok, I finally attemtped to make the leap to 1.3.5

was working on importing my old db, and I get this error

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

anyone know what this means?

Thanks...

3 Oct 2006, 8:50 PM
#2
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: upgrading - DB issues

Did you run the installer (zc_install) over your DB? Even if you upgrade your files manually, you still need to run the install in order apply new version changes to the database.

4 Oct 2006, 12:29 PM
#3
atsdotha avatar

atsdotha

Zen Follower

Join Date:
Jul 2005
Location:
Dothan, AL
Posts:
328
Plugin Contributions:
0

Re: upgrading - DB issues

i did not... i installed on a different folder, and then tried to export, import my old database.

any way i can get the original database to import into the newer site, so I can at least get my site back up?

10 Oct 2006, 12:48 AM
#4
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: upgrading - DB issues

Sure, set up the new site files in your web directory, then go to your browser and browse to the zc_install folder (you'll have to type in "/zc_install" manually). When presented with the install screen, click "Upgrade Database" at the bottom.

I should note that this is all covered extensively in the FAQ, wiki, readme's, and forum posts. You need to do some more homework. :smile:

18 Oct 2006, 9:32 PM
#5
atsdotha avatar

atsdotha

Zen Follower

Join Date:
Jul 2005
Location:
Dothan, AL
Posts:
328
Plugin Contributions:
0

Re: upgrading - DB issues

thanks for the help...