Good morning,
I don't know what I have changed, but since yesterday I get an error when I try to login my OC3 and open the Dashboard.
Can someone tell me what the cause may be ?
Fatal error: Uncaught Exception: Error: Unknown column 'os.color_code' in 'field list'<br />Error No: 1054<br /> SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.color_code FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status_color_code, o.shipping_method, o.payment_method, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5
This is your answer.SVN wrote: ↑Thu Sep 20, 2018 4:52 pmGood morning,
I don't know what I have changed, but since yesterday I get an error when I try to login my OC3 and open the Dashboard.
Can someone tell me what the cause may be ?
Fatal error: Uncaught Exception: Error: Unknown column 'os.color_code' in 'field list'<br />Error No: 1054<br /> SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.color_code FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status_color_code, o.shipping_method, o.payment_method, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5
Unknown column 'os.color_code' in 'field list'
Missing color_code column in oc_order_status table.
Cheers
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Very strange, I did not install a new extension or something.kestas wrote: ↑Thu Sep 20, 2018 5:05 pmThis is your answer.SVN wrote: ↑Thu Sep 20, 2018 4:52 pmGood morning,
I don't know what I have changed, but since yesterday I get an error when I try to login my OC3 and open the Dashboard.
Can someone tell me what the cause may be ?
Fatal error: Uncaught Exception: Error: Unknown column 'os.color_code' in 'field list'<br />Error No: 1054<br /> SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.color_code FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status_color_code, o.shipping_method, o.payment_method, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5Unknown column 'os.color_code' in 'field list'
Missing color_code column in oc_order_status table.
Cheers
I presume there is no way to figure out from wich extention it may be ?
Just added new column "color_code" in "oc-oder-status" and everything works fine.kestas wrote: ↑Thu Sep 20, 2018 5:05 pmThis is your answer.SVN wrote: ↑Thu Sep 20, 2018 4:52 pmGood morning,
I don't know what I have changed, but since yesterday I get an error when I try to login my OC3 and open the Dashboard.
Can someone tell me what the cause may be ?
Fatal error: Uncaught Exception: Error: Unknown column 'os.color_code' in 'field list'<br />Error No: 1054<br /> SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.color_code FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status_color_code, o.shipping_method, o.payment_method, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5Unknown column 'os.color_code' in 'field list'
Missing color_code column in oc_order_status table.
Cheers
Thx for the help Kestas !
Who is online
Users browsing this forum: lockiedownunder, Majestic-12 [Bot] and 57 guests
