Post by onelouder » Sat Nov 14, 2009 12:34 am

Hey,

I upgraded through the versions fine. Everything seems to be working so far from what i've tested. But when i go to add something to the cart and follow the checkout procedure i encounter a error:

Error: Unknown column 'shipping_country_id' in 'field list'
Error No: 1054
INSERT INTO `order` SET customer_id = '6', firstname = 'first', lastname = 'one', email = 'zzzz@hotmail.com', telephone = '012239393', fax = '', total = '7.99', language_id = '1', currency = 'GBP', currency_id = '1', value = '1', coupon_id = '0', ip = '217.42.229.190', shipping_firstname = 'first', shipping_lastname = 'one', shipping_company = '', shipping_address_1 = '123 ant road', shipping_address_2 = '', shipping_city = 'zzzz', shipping_postcode = '', shipping_zone = 'West Yorkshire', shipping_zone_id = '3608', shipping_country = 'United Kingdom', shipping_country_id = '222', shipping_address_format = '', shipping_method = 'UK Mainland Shipping (0.03kg)', payment_firstname = 'first', payment_lastname = 'one', payment_company = '', payment_address_1 = '123 ant road', payment_address_2 = '', payment_city = 'zzzz', payment_postcode = '', payment_zone = 'West Yorkshire', payment_zone_id = '3608', payment_country = 'United Kingdom', payment_country_id = '222', payment_address_format = '', payment_method = 'Credit Card / Debit Card (WorldPay)', comment = '', date_modified = NOW(), date_added = NOW()

I get this on the 2nd page, "Payment Information" after clicking continue.

Have i missed something?

I've tried retracing my steps and doing a couple of installations but no luck.

Also on another note my Logo in the top left seems to be randomly dissapearing. Its there one day and gone the next....It randomly started happening one day on 1.3.2

http://www.sixdecibels.co.uk

New member

Posts

Joined
Tue May 26, 2009 10:15 pm

Post by onelouder » Wed Dec 02, 2009 10:29 pm

Just so you know, I believe the problem was due to there was two versions of 1.3.2 one had some errors in the backing up of the database. Which i fixed by changing a quote in one of the files. Then a new version of 1.3.2 was released which i didn't bother getting because everything was working fine. Which was probably a bad move on my end. I think the backup system was slightly corrupted in some way as none of my back ups from that version 1.3.2 would restore (and i had quite a few) in any of the newers versions and including 1.3.2. But some older back ups i had in 1.2.8 or so worked fine in all versions (restoring wise)...of course i could be wrong.

I spent a couple of days trying to fix the problem and the amount of time i wasted on it was rediculous so i started fresh. I did have 300 or so products. But with the new options i can do alot more so i didn't mind starting fresh too much.

As for the logo disappearing it only happens when i edit the configuration settings i.e the text displayed on the main page or turning an option on and after i click save..poof its gone tho image is still on the server.

New member

Posts

Joined
Tue May 26, 2009 10:15 pm

Post by Qphoria » Wed Dec 02, 2009 10:36 pm

You should really use these steps instead:
http://forum.opencart.com/viewtopic.php?f=19&t=8301

10 mins and you're done

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 29 guests