Post by jbskaggs42 » Sun Sep 06, 2020 2:27 am

what does this error mean exactly and how can I fix it?

it happens when I go to dashboard.

Code: Select all

Fatal error: Uncaught Exception: Error: Unknown column 'o.order_posuser_id' in 'field list'<br />Error No: 1054<br />SELECT o.order_id, o.order_posuser_id, o.order_posuser_name, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM qqwn_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `qqwn_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5 in /homepages/39/d837176729/htdocs/clickandbuilds/OpenCart/scoopsic/system/library/db/mysqli.php:40 Stack trace: #0 /homepages/39/d837176729/htdocs/clickandbuilds/OpenCart/scoopsic/system/library/db.php(45): DB\MySQLi->query('SELECT o.order_...') #1 /homepages/39/d837176729/htdocs/clickandbuilds/OpenCart/scoopsic/system/storagexnvih8gc5skw/modification/admin/model/sale/order.php(232): DB->query('SELECT o.order_...') #2 /homepages/39/d837176729/htdocs/clickandbuilds/OpenCart/scoopsic/system/storag in /homepages/39/d837176729/htdocs/clickandbuilds/OpenCart/scoopsic/system/library/db/mysqli.php on line 40

Newbie

Posts

Joined
Mon Jul 27, 2020 1:47 pm

Post by IP_CAM » Sun Sep 06, 2020 2:31 am

order_posuser_id means, that you have a POINT OF SALES Extension
installed, but not correctly, as it looks ... ::) :D

I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'100 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by thekrotek » Sun Sep 06, 2020 2:38 am

Contact extension's developer on the matter.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by jbskaggs42 » Sun Sep 06, 2020 2:41 am

IP_CAM wrote:
Sun Sep 06, 2020 2:31 am
order_posuser_id means, that you have a POINT OF SALES Extension
installed, but not correctly, as it looks ... ::) :D
Thanks fixed it

Newbie

Posts

Joined
Mon Jul 27, 2020 1:47 pm

Post by chongshengdz » Sun Sep 06, 2020 8:16 pm

log in to your mysql(phpmyadmin) and add that column, the error should be fixed.

https://www.ectransistors.com/
https://www.transistormosfet.com/


Active Member

Posts

Joined
Sat Apr 12, 2014 10:18 pm

Who is online

Users browsing this forum: No registered users and 27 guests