I have installed v3.02.05 many times on my local server here at home, without any problem. However, for the past few days, I have been trying to install v3.02.05 on a new website that is being hosted somewhere else.
I've created the database, copied up the zip file & extracted all the files, then followed the CHMOD steps, renamed the _config.php file to config.php, and proceeded with the installation.
I've tried installing with PHP 7.2, 7.4, 8.0 and 8.1... the same problem with each of them.
I've tried to install it more than 10 times, but each time, after entering in all the database parameters, on the next page it always hangs forever:
Any idea where the problem might be? I purposely entered in the wrong database password at the previous step, and a popup appeared telling me that I had the wrong username/password, so I know that the problem is not with my database credentials. I've also tried both PDO and MySQLi.
Hello, Patrick, I found what the problem is during installation:
I am trying to install Chrome-Fusion 3.02.05 on my externally-hosted website that is running MySQL Version8.0.34-cll-lve. Their tech support told me that the setup file is trying to set sql_mode to NO_AUTO_CREATE_USER, which is not allowed for my hosting plan.
Any ideas of what I can modify in Chrome-Fusion to allow it to install?
Fatal error: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' in D:\Web\~Hosts\GalleryWings.com\cms\chromefusion\fusionwings-com_chromefusion_v3.03.00\includes\db_handlers\pdo_functions_include.php on line 73
It's happening with the new v3.03.00 also. It installs fine on MariaDB, but it is failing & I get that error on MySQL. I know absolutely nothing about MySQL, but after searching the Internet again, it seems that the Chrome-Fusion installation is using NO_AUTO_CREATE_USER, which was removed from MySQL 8.
No idea if any of your other Chrome-Fusion users have had the same problem.