Forums / Upgrading from 1.3.x to 1.3.9 / HELP -- In the middle of upgrading and don't understand..

HELP -- In the middle of upgrading and don't understand..

Locked

Views: 860

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
22 Aug 2010, 10:59 PM
#1
kimhuff avatar

kimhuff

Zen Follower

Join Date:
Nov 2005
Posts:
88
Plugin Contributions:
0

HELP -- In the middle of upgrading and don't understand..

HELP! I am in the middle of upgrading our zen cart site from the 1.3.8a to the 1.3.9f. I think I have everything done and I am ready to upgrade the database and I have the following questions.

When I go to Database Upgrade, I see TWO databases check marked. the Upgrade DB from 1.3.8 to 1.3.9 AND Upgrade DB from 1.1.1 to 1.1.2. The first is correct but I am sure we were never on the older version. Should I uncheck the older version or should I leave it checked?

Also, before sending this message... I unchecked the older version and clicked on update database. I received the following error...

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE counter_history_clean as SELECT * FROM counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

I found where I needed to change this which I have done... does that mean I should run the update again or did it actually do something?

Thank you for your help.

Kim

23 Aug 2010, 12:36 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: HELP -- In the middle of upgrading and don't understand..

What does the admin state if anything?

tools > server version info

Zen-Venom Get Bitten

23 Aug 2010, 12:38 AM
#3
kimhuff avatar

kimhuff

Zen Follower

Join Date:
Nov 2005
Posts:
88
Plugin Contributions:
0

Re: HELP -- In the middle of upgrading and don't understand..

I think it is done.. cause it states.

Zen Cart 1.3.9f
Database Patch Level: 1.3.9f

23 Aug 2010, 12:40 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: HELP -- In the middle of upgrading and don't understand..

You can ignore the suggestion for 1.1.1-to-1.1.2. That's a red herring.

As for the other issue, yes, if you haven't already, you'll want to simply rerun the 138-to-139 upgrade step again. You'll see several messages saying that "things were skipped because they're already done", which can be ignored.

.
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.

23 Aug 2010, 1:49 AM
#5
kimhuff avatar

kimhuff

Zen Follower

Join Date:
Nov 2005
Posts:
88
Plugin Contributions:
0

Re: HELP -- In the middle of upgrading and don't understand..

Thank you everyone. The update is complete.. I really appreciate all the quick help!!!