Forums / Upgrading from 1.3.x to 1.3.9 / Zone Upgrade Not Happening

Zone Upgrade Not Happening

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

21 Nov 2006, 12:31 AM

blessisaacola

Totally Zenned

Join Date:: Feb 2004
Location:: Georgia, USA
Posts:: 1,875
Plugin Contributions:: 1

Zone Upgrade Not Happening

I am not sure which version the change happened in but I just finished comparing my upgraded ZC store to a brand new install and noticed that this lineINSERT INTO `zones` VALUES (50, 223, 'PW', 'Palau'); has been changed to ```
INSERT INTO zones VALUES (50, 163, 'PW', 'Palau');


My upgrade did not reflect this change.

Thanks!

21 Nov 2006, 10:19 PM

jeffd

Totally Zenned

Join Date:: Sep 2004
Posts:: 605
Plugin Contributions:: 1

Re: Zone Upgrade Not Happening

Looking back at the 1.3.5 file set sql indicates that this change took place in 1.3.6 so I would venture to say that the following sql statement was accidentally omitted from the 1.3.5 to 1.3.6 sql update script:

UPDATE zones SET zone_country_id=163 WHERE zone_name = 'Palau';

Executing this in the patch tool worked fine for us.

Jeff