[Solved]: Notice: Error: Unknown column 'date_last_action'

Code: Select all

Notice: Error: Unknown column 'date_last_action' in 'field list'
Error No: 1054
UPDATE oc_customer SET cart = 'a:4:{i:9686;i:1;i:9341;i:1;i:1087;i:1;i:968;i:1;}', wishlist = '', date_last_action = NOW(), number_reminder_sent = 0, ip = '124.43.200.193' WHERE customer_id = '16' in /home/sanjana/public_html/system/database/mysql.php on line 50

Code: Select all

ALTER TABLE `oc_customer` ADD `date_last_action` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'

Code: Select all

Notice: Error: Unknown column 'number_reminder_sent' in 'field list'
Error No: 1054
UPDATE customer SET cart = 'a:0:{}', wishlist = '', date_last_action = NOW(), number_reminder_sent = 0, ip = '146.200.134.168' WHERE customer_id = '953' in /home2/vidalca1/public_html/system/database/mysql.php on line 50