Page 1 of 1
[Solved]: Notice: Error: Unknown column 'date_last_action'
Posted: Sat Sep 14, 2013 2:08 pm
by sanjananb
i am receiving below error in my site
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
screenshot
help me to fix it please
Re: Paid Job : Notice: Error: Unknown column 'date_last_acti
Posted: Sat Sep 14, 2013 5:56 pm
by grgr
Because 'date_last_action' does not exist in the database and is not part of opencart default. You have installed an extension of some sort and not installed it properly.
You can add the field with the following code (phpMyAdmin > SQL tab) but not knowing what it is intended for this is just a guess and may not be completely correct.
Code: Select all
ALTER TABLE `oc_customer` ADD `date_last_action` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
Re: Paid Job : Notice: Error: Unknown column 'date_last_acti
Posted: Sat Sep 14, 2013 6:41 pm
by sanjananb
Its worked man. Thanks a lot.. you are such a genius
Re: [Solved]: Notice: Error: Unknown column 'date_last_actio
Posted: Thu Mar 19, 2015 4:11 am
by jontycasson
Hi All,
I am trying to add a customer account based in Austria to test my shipping methods in v1.5.6.4
when creating the customer account i get this error and when I also log in... i get the successfully registered email ok so i know the customer is registered.
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
please help ( i have tried the above to no avail)
Re: [Solved]: Notice: Error: Unknown column 'date_last_actio
Posted: Tue May 12, 2015 8:50 pm
by ravidevt
Install Abandoned Cart Reminder Pro again. It will solve thsi issue
Re: [Solved]: Notice: Error: Unknown column 'date_last_actio
Posted: Fri May 22, 2015 1:36 pm
by agheinz
I'm having a similar problem:
Notice: Error: Unknown column 'h2g_product_discount_id' in 'h2g_product_discount_special'
Error No: 1054
ALTER TABLE h2g_product_discount_special ADD product_special_id int(11) NOT NULL AFTER h2g_product_discount_id in /home/hijab2go/public_html/system/database/mysql.php on line 50
I have created the table h2g_product_discount_special database with the column h2g_product_special_id, but it did not help the problem.
Any suggestions?