Post by magazinesubhub » Thu Sep 30, 2010 4:43 am

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.

New member

Posts

Joined
Thu Apr 23, 2009 4:32 am

Post by i2Paq » Thu Sep 30, 2010 5:19 am

So you say it is a new site, but updated last year by Q?

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.


User avatar
Global Moderator

Posts

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

Post by magazinesubhub » Thu Sep 30, 2010 10:38 am

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?

New member

Posts

Joined
Thu Apr 23, 2009 4:32 am

Post by magazinesubhub » Thu Sep 30, 2010 10:39 am

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.

New member

Posts

Joined
Thu Apr 23, 2009 4:32 am
Who is online

Users browsing this forum: Baidu [Spider] and 15 guests