Post by lankylad » Fri Nov 01, 2019 5:38 pm

I have done a new installation of Opencart 3.0.3.2 on Windows 10 and a new installation of MySQL 8.0.18.0.
All goes when until Step_3 when the web page is blank:
1. The database tables have been created
2. The IIS log file shows an HTTP Status Code of 500
3. There is nothing in the Windows Logs
4. There is a warning in the MySQL logs about 'NO-ZERO_DATE' being used in strict mode
5. The two config.php files are both empty

Any suggestions?

Newbie

Posts

Joined
Fri Nov 01, 2019 5:11 pm

Post by OSWorX » Fri Nov 01, 2019 7:30 pm

While it should work with IIS, why you are not using a (real) web server (even a local instance like XAMPP)?

Custom Development | Individuelle Entwicklung | Support & Bugfixes

Image Image Image


User avatar
Guru Member
Online

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by lankylad » Sun Nov 03, 2019 1:40 am

It is being added to an existing IIS site as a subdirectory

Newbie

Posts

Joined
Fri Nov 01, 2019 5:11 pm

Post by letxobnav » Sun Nov 03, 2019 12:36 pm

Strict mode affects whether the server permits '0000-00-00' as a valid date:
If strict mode is not enabled, '0000-00-00' is permitted and inserts produce no warning.
If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well.
For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.

disable strict mode:

SET sql_mode = '';

during run-time or permanently in my.cnf/my.ini

if that mysql error is indeed the reason your install...stalls.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by lankylad » Mon Nov 04, 2019 5:47 pm

Thanks, I'll give that a try

Newbie

Posts

Joined
Fri Nov 01, 2019 5:11 pm

Post by lankylad » Tue Nov 05, 2019 6:29 pm

I put TRACE onto the installation job and tracked down the problem.
Fixed it by editing the file install/model/install/install.php and commenting out 35 line :
$db->query(“SET @@session.sql_mode = ‘MYSQL40’”);
This line was causing an exception that made Page_3 empty

Newbie

Posts

Joined
Fri Nov 01, 2019 5:11 pm
Who is online

Users browsing this forum: OSWorX and 9 guests