Page 1 of 1

[SOLVED] Step_3 Page blank (MySQL setting)

Posted: Fri Nov 01, 2019 5:38 pm
by lankylad
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?

Re: Step_3 Page blank

Posted: Fri Nov 01, 2019 7:30 pm
by OSWorX
While it should work with IIS, why you are not using a (real) web server (even a local instance like XAMPP)?

Re: Step_3 Page blank

Posted: Sun Nov 03, 2019 1:40 am
by lankylad
It is being added to an existing IIS site as a subdirectory

Re: Step_3 Page blank

Posted: Sun Nov 03, 2019 12:36 pm
by letxobnav
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.

Re: Step_3 Page blank

Posted: Mon Nov 04, 2019 5:47 pm
by lankylad
Thanks, I'll give that a try

Re: Step_3 Page blank

Posted: Tue Nov 05, 2019 6:29 pm
by lankylad
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