Post by SVN » 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

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by kestas » 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

Custom OpenCart modules and solutions. Just PM me... Extensions you can find here and here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by SVN » Thu Sep 20, 2018 5:33 pm

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 ?

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by kestas » Thu Sep 20, 2018 5:38 pm

Try to clear all cache in you admin dashboard blue gear icon and refresh modifications.

Custom OpenCart modules and solutions. Just PM me... Extensions you can find here and here


Active Member

Posts

Joined
Tue Oct 12, 2010 2:23 am

Post by SVN » Sun Oct 14, 2018 4:46 pm

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 !

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm
Who is online

Users browsing this forum: No registered users and 11 guests