Post by sanjananb » Sat Sep 14, 2013 2:08 pm

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
Image

help me to fix it please
Last edited by sanjananb on Sat Sep 14, 2013 6:42 pm, edited 1 time in total.

New member

Posts

Joined
Sun Sep 11, 2011 6:06 am

Post by grgr » Sat Sep 14, 2013 5:56 pm

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'

Image Image Image Image Image Image Image Image


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by sanjananb » Sat Sep 14, 2013 6:41 pm

Its worked man. Thanks a lot.. you are such a genius

New member

Posts

Joined
Sun Sep 11, 2011 6:06 am

Post by jontycasson » Thu Mar 19, 2015 4:11 am

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)

Image
Vidal Cassoon - Hair and Beauty Specialists


New member

Posts

Joined
Wed Apr 13, 2011 2:01 am
Location - Cheshire

Post by ravidevt » Tue May 12, 2015 8:50 pm

Install Abandoned Cart Reminder Pro again. It will solve thsi issue

Newbie

Posts

Joined
Sat Feb 16, 2013 2:18 am

Post by agheinz » Fri May 22, 2015 1:36 pm

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?

Newbie

Posts

Joined
Fri May 22, 2015 1:32 pm
Who is online

Users browsing this forum: No registered users and 51 guests