Error Code(0): Error: Incorrect DATETIME value: ''
Error No: 1525
UPDATE `oc_order_recurring` SET `date_added` = `created` WHERE `date_added` IS NULL or `date_added` = ''
Reading a few topics here, I checked to see if I could remove the NO_ZERO_DATE session option in the mysqli connector. But realised in this version that has already been done. Is this because of the structure of the database doesnt allow NULL values, but the upgraded version does? Any advice is appreciated.
You should probably follow this very good advice
viewtopic.php?f=181&t=226916
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Thanks again
Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk
Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk
Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk
`created` cannot contain reversed quotes. The database structures no longer allows the DATETIME period to be defined as 0s be default while the upgraded versions of OC have a workaround for it.Nsaneone wrote: ↑Thu Jan 13, 2022 12:32 amGood Afternoon All. I am attempting to upgrade our Opencart 1.5.6 to 3.0.3.8. However during the upgrade I observe the following error
Error Code(0): Error: Incorrect DATETIME value: ''
Error No: 1525
UPDATE `oc_order_recurring` SET `date_added` = `created` WHERE `date_added` IS NULL or `date_added` = ''
Reading a few topics here, I checked to see if I could remove the NO_ZERO_DATE session option in the mysqli connector. But realised in this version that has already been done. Is this because of the structure of the database doesnt allow NULL values, but the upgraded version does? Any advice is appreciated.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
`created` with the backticks would be fine, as it's a table name. The issue is '' is not a valid date even with NO_ZERO_DATE removed from sql_mode. The query would need to be changed to.straightlight wrote: ↑Thu Jan 13, 2022 9:18 am`created` cannot contain reversed quotes. The database structures no longer allows the DATETIME period to be defined as 0s be default while the upgraded versions of OC have a workaround for it.
Code: Select all
UPDATE `oc_order_recurring` SET `date_added` = [b]`created`[/b] WHERE `date_added` IS NULL or `date_added` = '0000-00-00'
I noticed that in our 1.5.6 a few modifications were made to call custom PHP scripts in the tpl files. But on the new version it uses twig which I understand doesn't support PHP. Any guidance on how I could accomplish the same/similar for twig files? Apologies this question may not be suitable for this particular forum
Regarding tpl written in php and twig written in twig
There are other changes which will prevent many of you extensions from working.
First you go to your download page in the marketplace - If you are in luck you will find a version for OC3
Second it is unlikely anyone will convert them for free although there are some online services available it is not just about converting the tpl to twig.
It is more than likely you will be sent to the commercial section. However you are welcome to try to post in a new topic.
Help need to convert some OC1.5.6 extensions to OC3.0.3.8
maybe post in both places
Have a great day or night
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
viewtopic.php?t=212438
Also had to update /1005.php for recurring_transaction & /1009.php for DROP affiliate_activity table.
Again, none of these tables were relevant to my build, but was able to get everything done, hopefully helps someone out there.
Because is a bug...
Code: Select all
if (!$affiliate_query->num_rows) {
$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_activity`");
}
Code: Select all
if ($affiliate_query->num_rows) {
$this->db->query("DROP TABLE `" . DB_PREFIX . "affiliate_activity`");
}
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
If there isn't a commit on Github Opencart repository about this already, one may need to be created if the case.ADD Creative wrote: ↑Thu Jan 13, 2022 7:15 pm`created` with the backticks would be fine, as it's a table name. The issue is '' is not a valid date even with NO_ZERO_DATE removed from sql_mode. The query would need to be changed to.straightlight wrote: ↑Thu Jan 13, 2022 9:18 am`created` cannot contain reversed quotes. The database structures no longer allows the DATETIME period to be defined as 0s be default while the upgraded versions of OC have a workaround for it.
Code: Select all
UPDATE `oc_order_recurring` SET `date_added` = [b]`created`[/b] WHERE `date_added` IS NULL or `date_added` = '0000-00-00'
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: No registered users and 139 guests