Hi
PHP v 8.3.0, MySQL 5.7, IIS10
I am trying to upgdrade and it stops at step 3 with this error:
SyntaxError: Unexpected token '<', "<b>Error: "... is not valid JSON
parsererror
<b>Error: Invalid use of NULL value<br/>Error No: 1138<br/>ALTER TABLE `oc_api` MODIFY `date_added` datetime NOT NULL AFTER `status`</b>: in <b>C:\inetpub\wwwroot\mystore\system\library\db\mysqli.php</b> on line <b>76</b>
How can I solve it?
OpenCart 4 doesn't allow zero dates. The upgrade function will fail is most cases, especially also for your extensions.
It's better to do a fresh install of OpenCart 4, including all of your extensions. For the latter, check that they actually support OpenCart 4. You can then use the free Export/Import tool to copy your data over to your new OpenCart, see also our FAQ for this.
It's better to do a fresh install of OpenCart 4, including all of your extensions. For the latter, check that they actually support OpenCart 4. You can then use the free Export/Import tool to copy your data over to your new OpenCart, see also our FAQ for this.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks. I will try that. I did not see any zero dates in table, so I was not sure why I got that error.
I assume I will have to copy all the product images manually.
I assume I will have to copy all the product images manually.
Better don't upgrade yet to 4.x.x.x
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
I was also wondering a bit about strict DB rules with IIS even though the dates no longer requires 0 by default.vitali@avalia.no wrote: ↑Tue Dec 12, 2023 5:31 pmHi
PHP v 8.3.0, MySQL 5.7, IIS10
I am trying to upgdrade and it stops at step 3 with this error:
SyntaxError: Unexpected token '<', "<b>Error: "... is not valid JSON
parsererror
<b>Error: Invalid use of NULL value<br/>Error No: 1138<br/>ALTER TABLE `oc_api` MODIFY `date_added` datetime NOT NULL AFTER `status`</b>: in <b>C:\inetpub\wwwroot\mystore\system\library\db\mysqli.php</b> on line <b>76</b>
How can I solve it?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 3 guests
