Post by mikej » Sun Feb 07, 2010 10:57 am

Hello,

I upgraded to 1.4.0 from 1.3.2, not thinking that would be a problem and because I couldn't find any newer versions from 1.3.2 or newer except for 1.4.0. I keep getting the same error (below) whenever I try to checkout on the shop, no matter what method I am trying to use. Any help would greatly be appreciated.

Error: Unknown column 'shipping_zone_id' in 'field list'
Error No: 1054
INSERT INTO `order` SET customer_id = '17', firstname = 'Jon', lastname = 'Doe', email = 'test@test.com', telephone = '61855555555', fax = '', total = '10', language_id = '1', currency = 'USD', currency_id = '2', value = '1', coupon_id = '0', ip = '1.1.1.1', shipping_firstname = 'Jon', shipping_lastname = 'Doe', shipping_company = '', shipping_address_1 = '123 Elm', shipping_address_2 = '', shipping_city = 'Make Believe', shipping_postcode = '12345', shipping_zone = 'unknown', shipping_zone_id = '3635', shipping_country = 'United States', shipping_country_id = '223', shipping_address_format = '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}', shipping_method = 'Free Shipping', payment_firstname = 'Jon', payment_lastname = 'Doe', payment_company = '', payment_address_1 = '123 Elm', payment_address_2 = '', payment_city = 'Make Believe', payment_postcode = '12345', payment_zone = 'Unknown', payment_zone_id = '3635', payment_country = 'United States', payment_country_id = '223', payment_address_format = '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}', payment_method = 'Cash On Delivery', comment = '', date_modified = NOW(), date_added = NOW()

New member

Posts

Joined
Sun Feb 07, 2010 9:05 am

Post by i2Paq » Sun Feb 07, 2010 7:21 pm

There is 1.3.4.

It looks like the 1.3.2 is missing some database tables that is needed in 1.4.0.
I'm not sure what else is changed.

There are a few topics on migrating from 1.3.2 in the Installation & Upgrade Support forum, I will move this topic there.

[topic moved]

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by mikej » Mon Feb 08, 2010 4:16 am

Where can I download 1.3.4 at? I have Qphoria's oc_upgrade_132_to_134.sql file, but I can't find the download package for 1.3.4 to upgrade the files from 1.3.2 to 1.3.4. Or do I even need to do that? I would think I would need to run the sql file from Qphoria, upload all the new files for 1.3.4, and then just replace the 1.3.4 files with 1.4.0, because there isn't a database change from 1.3.4 to 1.4.0 correct? Thanks for all your help!

New member

Posts

Joined
Sun Feb 07, 2010 9:05 am

Post by mikej » Mon Feb 08, 2010 4:23 pm

I was able to find the older versions and was able to get this issue fixed. Everything seems to be working WONDERFULLY...Thank you all for your help and thank you Qphoria and everyone else!

New member

Posts

Joined
Sun Feb 07, 2010 9:05 am
Who is online

Users browsing this forum: No registered users and 9 guests