OpenCart Community

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

Same happens from 2.2.0.0 to Latest 2.3.0.2

No solution? No replies ? Typical OC team

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
Use Google, find find it all, much easier than checking the OC Search Machine.
Just to add a little Salt to this

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.

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