Page 1 of 1

Error on Dashboard

Posted: Thu Sep 20, 2018 4:52 pm
by SVN
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

Re: Error on Dashboard

Posted: Thu Sep 20, 2018 5:05 pm
by kestas
SVN wrote:
Thu Sep 20, 2018 4:52 pm
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.
Unknown column 'os.color_code' in 'field list'

Missing color_code column in oc_order_status table.

Cheers

Re: Error on Dashboard

Posted: Thu Sep 20, 2018 5:33 pm
by SVN
kestas wrote:
Thu Sep 20, 2018 5:05 pm
SVN wrote:
Thu Sep 20, 2018 4:52 pm
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.
Unknown column 'os.color_code' in 'field list'

Missing color_code column in oc_order_status table.

Cheers
Very strange, I did not install a new extension or something.
I presume there is no way to figure out from wich extention it may be ?

Re: Error on Dashboard

Posted: Thu Sep 20, 2018 5:38 pm
by kestas
Try to clear all cache in you admin dashboard blue gear icon and refresh modifications.

[SOLVED] Re: Error on Dashboard

Posted: Sun Oct 14, 2018 4:46 pm
by SVN
kestas wrote:
Thu Sep 20, 2018 5:05 pm
SVN wrote:
Thu Sep 20, 2018 4:52 pm
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.
Unknown column 'os.color_code' in 'field list'

Missing color_code column in oc_order_status table.

Cheers
Just added new column "color_code" in "oc-oder-status" and everything works fine.

Thx for the help Kestas !