Author Topic: Error: Unknown column 'sku' in 'field list'  (Read 3606 times)

Offline kasynhk

  • Newbie
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Error: Unknown column 'sku' in 'field list'
« on: November 20, 2019, 08:31:35 PM »
The version is upgraded from 1.2.6 to 1.2.12, jumping.
Everything else is debugged. However, the following error occurred when the test order was checked out. I tried a lot of ways. But it has not been resolved. can you help me?

2019-11-20 18:16:33 - database error: AbanteCart core v.1.2.12 Error: Unknown column 'sku' in 'field list'
Error No: 1054
INSERT INTO abc_order_products
SET order_id = '1663',
product_id = '272',
name = 'Dragon HDD Bay Hard Drive Cover Shell Replacement Faceplate for PS4 Console',
model = '',
sku = '',
price = '8.9',
total = '17.8',
tax = '0',
quantity = '2',
subtract = '1' in <b>/www/users/H10046687/core/database/mysql.php</b> on line <b>118</b>

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5819
  • Karma: +274/-2
    • View Profile
Re: Error: Unknown column 'sku' in 'field list'
« Reply #1 on: November 21, 2019, 05:29:18 AM »
In some of the upgrades was sql issue. Your database missing some columns

 

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.