Post by ideep13 » Fri Oct 22, 2021 10:28 pm

Hi,
I am trying to upgrade 3.0.3.6. to 3.0.3.7

and I have received this error

Code: Select all

Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM` in /home/djecjeku/public_html/system/library/db/mysqli.php on line 41
I would really appreciate if someone can help me,
Thank you
Last edited by ideep13 on Sun Oct 24, 2021 4:38 pm, edited 3 times in total.

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by straightlight » Fri Oct 22, 2021 10:30 pm

Simply upgrade to the v3.0.3.8. This fixes the issue already.

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

Post by ideep13 » Fri Oct 22, 2021 10:35 pm

aha, I just removed NO_ZERO_DATE.. I found the solution..

but now I am getting this errors:

SyntaxError: Unexpected token < in JSON at position 0 parsererror Warning: file(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 97Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 99Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 110Warning: fopen(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 119Warning: fwrite() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 121Warning: fclose() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 123{"success":"Patch 1009 has been applied (10 of 10)","next":"index.php?route=upgrade\/upgrade\/next&step=11"}


when I click continue it installs it all over again with same errors.. it wont pass me through..


Should I just upgrade files to 3.0.3.8.. is it ok just to overwrite all files over this?

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by straightlight » Fri Oct 22, 2021 11:29 pm

ideep13 wrote:
Fri Oct 22, 2021 10:35 pm
aha, I just removed NO_ZERO_DATE.. I found the solution..

but now I am getting this errors:

SyntaxError: Unexpected token < in JSON at position 0 parsererror Warning: file(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 97Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 99Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 110Warning: fopen(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 119Warning: fwrite() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 121Warning: fclose() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 123{"success":"Patch 1009 has been applied (10 of 10)","next":"index.php?route=upgrade\/upgrade\/next&step=11"}


when I click continue it installs it all over again with same errors.. it wont pass me through..


Should I just upgrade files to 3.0.3.8.. is it ok just to overwrite all files over this?
Simply install a fresh version of OC v3.0.3.8 on a development / test server and run the upgrade from there with your current database prior to use it on your live server. Once ready to use on your live server, don't override the files. Simply upload on a new folder and remove, or backup, the old one. Then, to rename the new folder back to the old one. Also ensure to move your system/storage folder outside of your public_html folder and to edit each paths accordingly in both config.php files. Lastly, to rename your install folder (or remove it) and to clear your storage/cache files and sub-folders (except your index.html file) and to set CHMOD 0755 recursively on all folders inside your storage folder from FTP (storage included). Not on files!

Take note that no errors must be shown during the CHMOD process.

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

Post by ADD Creative » Sat Oct 23, 2021 12:20 am

The error is telling you it can find the file admin/config.php.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by ideep13 » Sat Oct 23, 2021 1:05 am

I have override the installation files with 3.0.3.8..
When it comes to Patch 9or 10 ..the same error persist

SyntaxError: Unexpected token < in JSON at position 0 parsererror Warning: file(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 97Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 99Warning: Invalid argument supplied for foreach() in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 110Warning: fopen(/home/djecjeku/public_html/admin/config.php): failed to open stream: No such file or directory in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 119Warning: fwrite() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 121Warning: fclose() expects parameter 1 to be resource, bool given in /home/djecjeku/public_html/install/model/upgrade/1009.php on line 123{"success":"Patch 1009 has been applied (10 of 10)","next":"index.php?route=upgrade\/upgrade\/next&step=11"}

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by ideep13 » Sat Oct 23, 2021 1:09 am

ADD Creative wrote:
Sat Oct 23, 2021 12:20 am
The error is telling you it can find the file admin/config.php.
my admin folder is changed .. is this the case and where do I need to rename the admin folder in the code?

permissions on the folders are all 0775, the files 0644

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by ideep13 » Sat Oct 23, 2021 1:17 am

nevermind I managed.. had to rename the admin folder thank you!!

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by ideep13 » Sun Oct 24, 2021 3:51 pm

moved the issue to another topic

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am
Who is online

Users browsing this forum: No registered users and 102 guests