The Elearning Community

Hi all,
I try to install Formalms on Wampserver.
Php version : 7.0.33
MysQl Version: 5.7.28

In step 4, after having entered the name of the DB and the parameters of the user of the DB, here is the warning that appeared: _SQL_STRICT_MODE_WARN _DB_WILL_BE_CREATED.

At this level, the following button remains inactive.

Is there a solution?

Thank you ...

Hi Alfa24

I followed the instructions in the topic but nothing works.
In the my.ini file, I found these lines:
I have made all kinds of modifications at this level but it still does not work. I get stuck at step4.

modification1 : I add : , but nothing
modifiation2 : I able : and unable , but nothing
modifiation3 : i use this syntax to make the 2 modifications, but nothing

I NEED HELP, please

Try to create database before launching the installer.

Hi Alfa24

The database has be created before installing.

I'm afraid it's not true.
First of all, you're clearly in the case "create_db" of step4, that is the only place where that error occurs.
Second, the error occurs if checkStrictMode fails. This means the sql_mode variable has not be correctly set. Did you restart mysql server? What version of PHP are you using?

Hi Alfa24

I restarted Mysql sever.
I use php7.0.33, MySQL 5.7.28

What is the correct variable for sql_mode variable.? because i used :
sql_mode=""
sql_mode="NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER

Also try with
sql-mode=""
sql-mode="NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"
sql-mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER

But still nothing....


Thank you !

can't image what else you could try... Maybe the console or network tabs could offer suggestions... Could I try the installer for you? If yes, please provide the url and parameters privately.

Hi Alfa24,

I work in local

I believe the problem should have been solved by now. Still, for future reference, I would like to point readers of this topic to a previous post of mine, where a solution to the problem is suggested:
viewtopic.php?f=2&t=13330