Hi all, Im testing out my new site and when i tried to checkout that was the error message I got.
website - magazinesubhub.com
version - i believe it is some form of version 1.4 but not sure exactly. It was updated by Q last year.
the full error is
Error: Unknown column 'coupon_id' in 'field list'
Error No: 1054
INSERT INTO `order` SET customer_id = '0', firstname = 'aasdfd', lastname = 'sdagasdf', email = 'mike1111@mailinator.com', telephone = '7187777777', fax = '', total = '49.98', language_id = '1', currency = 'USD', currency_id = '2', value = '1', coupon_id = '0', ip = '24.103.230.114', shipping_firstname = '', shipping_lastname = '', shipping_company = '', shipping_address_1 = '', shipping_address_2 = '', shipping_city = '', shipping_postcode = '', shipping_zone = '', shipping_zone_id = '0', shipping_country = '', shipping_country_id = '0', shipping_address_format = '', shipping_method = '', payment_firstname = 'aasdfd', payment_lastname = 'sdagasdf', payment_company = '', payment_address_1 = '1 main', payment_address_2 = '', payment_city = 'new york', payment_postcode = '', payment_zone = 'New York', payment_zone_id = '3655', 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 = 'PayPal', comment = '', date_modified = NOW(), date_added = NOW()
I tried searching the community for the answer and I came across this response from Daniel. However, Im a novice with OC and not sure how to fix the problem. Can anyone explain it to me.
"There has been a new field added to orders in version 1.2.8 called coupon_id please check that it is in your order table."
Thanks guys.
So you say it is a new site, but updated last year by Q?
What is the story?
What is the story?
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.
Im extremely slow with building it. It took me a long time to enter all the products. Its been like a weekend hobby in "building" this, my first ecommerce site. So technically its a "new" site but its been around for a little more than a year. Ive never gone "live" yet. lol
Does that make sense?
Does that make sense?
And when i first put OC on it, i had a real old version, then by the time i was ready to make some updates to it, the version was outdated and Q updated it for me.
Who is online
Users browsing this forum: Baidu [Spider] and 15 guests