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

Hi, brothers!

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

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/thebestmegashop.world/system/library/db/mysqli.php 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,
Maza

Newbie

Posts

Joined
Thu Feb 02, 2017 3:00 pm

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

Same happens from 2.2.0.0 to Latest 2.3.0.2

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

Newbie

Posts

Joined
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

Ernie's OpenCart LIGHT with responsive Bootstrap Themes:
http://www.bigmax.ch - http://www.ipc.li - http://www.openshop.li
Image


User avatar
Guru Member

Posts

Joined
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 2.1.0.1 to 2.3.0.2

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.

Newbie

Posts

Joined
Sat Dec 29, 2012 8:32 pm

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

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

New member

Posts

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

Users browsing this forum: No registered users and 13 guests