Post by mazadvedko » Thu Feb 02, 2017 3:03 pm

Hi, brothers!

I want to upgrade my opencart based web-site from to

In the proccess of upgrading I'm get the following error:

Error Code(0): Error: Invalid use of NULL value
Error No: 1138
ALTER TABLE `cart` CHANGE `date_added` `date_added` DATETIME NOT NULL AFTER `quantity` in /var/www/ on line 40

I've tried to find this query in sql file and in patches, but have not found that.

Help me please, I really don't know what I must to do.

With the best wishes,



Thu Feb 02, 2017 3:00 pm

Post by petsoukos » Fri Apr 21, 2017 3:07 am

Same happens from to Latest

No solution? No replies ? Typical OC team :crazy:



Fri Nov 08, 2013 5:14 am

Post by IP_CAM » Fri Apr 21, 2017 4:18 am

well, there are uncounted masses of Forum Topics on such, but it makes
little sense, to repeat everything again, for those, seemengly unwilling to
search for Solutions first.
Typically OC Users, I assume, for them, time is money, I guess, just to add a little Salt to this :D
Use Google, find find it all, much easier than checking the OC Search Machine.
Just to add a little Salt to this :D

Please don't send me OC Forum Personal Messages, just contact:
OC LIGHT Test Site:
OC V-PRO Test Site:
My Github OC Site:
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.

User avatar
Legendary Member


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

Post by futureproject » Fri Jun 02, 2017 5:46 am

just had the same issue updating from to

fortunately there's nothing too important in that table, so if you drop the table in mysql the update process should be able to create it from scratch and hopefully the rest of the update will carry on smoothly.



Sat Dec 29, 2012 8:32 pm

Post by mohittyagi82 » Fri Jun 09, 2017 1:14 pm

I also got this error but when i repeat the upgrade process then i got success in opencart upgradation.

New member


Wed Apr 20, 2016 7:02 pm
Who is online

Users browsing this forum: No registered users and 10 guests