Post by nay27uk » Tue Jun 29, 2021 8:16 pm

Trying to upgrade 3.0.2.0 to latest version 3.0.3.7 but the update page is giving the following error.
Anyone help please?
Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM` in /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/library/db/mysqli.php on line 41
Posted in the wrong forum first

New member

Posts

Joined
Mon May 04, 2015 10:56 pm

Post by rjcalifornia » Tue Jun 29, 2021 10:10 pm

nay27uk wrote:
Tue Jun 29, 2021 8:16 pm
Trying to upgrade 3.0.2.0 to latest version 3.0.3.7 but the update page is giving the following error.
Anyone help please?
Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM` in /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/library/db/mysqli.php on line 41
Posted in the wrong forum first
Check this solution:
viewtopic.php?t=222431#p813603

Image
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by nay27uk » Wed Jun 30, 2021 5:15 pm

Thanks that worked but now got blank pages.
This page isn’t working mydomain is currently unable to handle this request.
HTTP ERROR 500

New member

Posts

Joined
Mon May 04, 2015 10:56 pm

Post by nay27uk » Wed Jun 30, 2021 5:29 pm

Fatal error: Uncaught Error: Class 'Twig\Loader\ArrayLoader' not found in /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/library/template/twig.php:31 Stack trace: #0 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/library/template.php(51): Template\Twig->render('default/templat...', '<div class="lis...') #1 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/engine/loader.php(125): Template->render('default/templat...', '') #2 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/catalog/controller/extension/module/category.php(62): Loader->view('extension/modul...', Array) #3 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/engine/action.php(79): ControllerExtensionModuleCategory->index(Array) #4 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/engine/loader.php(48): Action->execute(Object(Registry), Array) #5 /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/catalog/controller/common/column_left.php(52): Loader->controller('extension/mo in /home/sites/5b/b/b22694882a/public_html/MYDOMAIN/system/library/template/twig.php on line 31

New member

Posts

Joined
Mon May 04, 2015 10:56 pm

Post by nay27uk » Wed Jun 30, 2021 5:34 pm

Fatal error: Uncaught Error: Class "Twig\Loader\ArrayLoader" not found in /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/library/template/twig.php:31 Stack trace: #0 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/library/template.php(51): Template\Twig->render('default/templat...', '<div class="lis...') #1 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/loader.php(125): Template->render('default/templat...', '') #2 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/catalog/controller/extension/module/category.php(62): Loader->view('extension/modul...', Array) #3 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/action.php(79): ControllerExtensionModuleCategory->index(Array) #4 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/loader.php(48): Action->execute(Object(Registry), Array) #5 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/catalog/controller/common/column_left.php(52): Loader->controller('extension/modul...') #6 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/action.php(79): ControllerCommonColumnLeft->index(Array) #7 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/loader.php(48): Action->execute(Object(Registry), Array) #8 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/catalog/controller/common/home.php(12): Loader->controller('common/column_l...') #9 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/action.php(79): ControllerCommonHome->index() #10 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/catalog/controller/startup/router.php(25): Action->execute(Object(Registry)) #11 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/action.php(79): ControllerStartupRouter->index() #12 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/router.php(67): Action->execute(Object(Registry)) #13 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/engine/router.php(56): Router->execute(Object(Action)) #14 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/framework.php(169): Router->dispatch(Object(Action), Object(Action)) #15 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/startup.php(104): require_once('/home/sites/5b/...') #16 /home/sites/5b/b/b22694882a/public_html/MYDOMIN/index.php(19): start('catalog') #17 {main} thrown in /home/sites/5b/b/b22694882a/public_html/MYDOMIN/system/library/template/twig.php on line 31

New member

Posts

Joined
Mon May 04, 2015 10:56 pm

Post by nay27uk » Sun Jul 04, 2021 6:48 pm

had to start from scratch. Realy wish there was an easy way to upgrade opencart

New member

Posts

Joined
Mon May 04, 2015 10:56 pm

Post by straightlight » Sun Jul 04, 2021 7:28 pm

nay27uk wrote:
Sun Jul 04, 2021 6:48 pm
had to start from scratch. Realy wish there was an easy way to upgrade opencart
There is, when uploading fresh files on a different folder, prior to upload to your live store, and ensure the storage folder is temporarily back inside the system folder and re-edit both config.php files prior to run the upgrade once the NO ZERO DATE solution has been followed. However, now that the issue has been resolved, please add: [SOLVED] at the beginning of the subject line on your first post.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 119 guests