Post by MMsheeks » Sat May 12, 2012 11:57 pm

Hello,

I'm getting the following in my checkout process.

Code: Select all

Notice: Error: Unknown column 'shipping_code' in 'field list'
Error No: 1054
INSERT INTO `opn_order` SET invoice_prefix = 'INV-2011-00', store_id = '0', store_name = 'Funsteps, Inc.', store_url = 'http://www.funsteps.biz/', customer_id = '0', customer_group_id = '8', firstname = 'Martin', lastname = 'Sheeks', email = 'martin.sheeks@gmail.com', telephone = '612-735-3063', fax = '', shipping_firstname = 'Martin', shipping_lastname = 'Sheeks', shipping_company = '', shipping_address_1 = '3737 Noble Ave N', shipping_address_2 = '', shipping_city = 'Robbinsdale', shipping_postcode = '55422', shipping_country = 'United States', shipping_country_id = '223', shipping_zone = 'Minnesota', shipping_zone_id = '3646', 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 = 'Flat Shipping Rate', shipping_code = 'flat.flat', payment_firstname = 'Martin', payment_lastname = 'Sheeks', payment_company = '', payment_address_1 = '3737 Noble Ave N', payment_address_2 = '', payment_city = 'Robbinsdale', payment_postcode = '55422', payment_country = 'United States', payment_country_id = '223', payment_zone = 'Minnesota', payment_zone_id = '3646', 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', payment_code = 'pp_standard', comment = '', total = '7.99', affiliate_id = '0', commission = '0', language_id = '1', currency_id = '2', currency_code = 'USD', currency_value = '1', ip = '98.240.161.2', forwarded_ip = '', user_agent = 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.168 Safari/535.19', accept_language = 'en-US,en;q=0.8', date_added = NOW(), date_modified = NOW() in /home7/funsteps/public_html/funstepsbiz/system/database/mysql.php on line 49
The issue appears to happen no mater what process I use. Currently I have Flat rate shipping set up, and Paypal standard as the payment method. I am checking out as a guest user.. All of this should be possible as far as I can tell in my settings.

This store needs to be live by Monday! Any help would be greatly appreciated!

EDIT: Site can be found at www.funsteps.biz

A people free to choose will always choose peace
-Ronald Reagan


Newbie

Posts

Joined
Sat May 12, 2012 11:48 pm


Post by Avvici » Sun May 13, 2012 12:58 am

I am thinking that you upgraded from 1.5.1.3 to 1.5.2.1 because there is no 'shipping_code' field in 1.5.1.3. This would mean that you forgot to run the upgrade script and the field was not generated. Add the field via phpMyAdmin or if you did not run the upgrade script run that it will generated the proper SQl for you. Just a guess...

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by MMsheeks » Sun May 13, 2012 1:10 am

The install is managed via SimpleScripts, so the upgrade script may not have run when it updated the system. Could you link me to the script, or let me know what the field details should be? I can add it, but should it just be a VARCHAR(20)? Thanks!

EDIT: Also, upon reviewing the table in PhpMyAdmin, it appears that a field shipping_module_code exists. Should I simply modify this field so that the name reflects properly?

EDIT 2: I modified the field shipping_module_code to be shipping_code, but the error persists. Other thoughts?

EDIT 3: Ignore my last edit, I was editing a database from an older install. I edited the current database to include the required fields in the opn_order and opn_order_product. Problem resolved. Thanks for your help!

A people free to choose will always choose peace
-Ronald Reagan


Newbie

Posts

Joined
Sat May 12, 2012 11:48 pm


Post by Avvici » Sun May 13, 2012 1:04 pm

np

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by nagger2000 » Tue May 15, 2012 12:19 am

@MMsheeks,

I have a similar issue, any chance you could let me know what you did?

Thanks

Newbie

Posts

Joined
Mon Apr 30, 2012 3:45 am

Post by angeland » Sun May 20, 2012 6:06 pm

I have the same problem here, also upgraded with simplescripts.

Newbie

Posts

Joined
Sun May 20, 2012 6:05 pm
Who is online

Users browsing this forum: No registered users and 115 guests