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