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()
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]
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.
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!
Who is online
Users browsing this forum: No registered users and 9 guests