FormaLms Installation : step 4

[anohjp]

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 ...

[alfa24]

viewtopic.php?f=10&t=13146&p=19982#p19984

[anohjp]

Hi Alfa24

I followed the instructions in the topic but nothing works.
In the my.ini file, I found these lines:

Code: Select all

;sql-mode=""
sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE"

I have made all kinds of modifications at this level but it still does not work. I get stuck at step4.

modification1 : I add :

Code: Select all

sql-mode="NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"

, but nothing
modifiation2 : I able :

Code: Select all

sql-mode=""

and unable

Code: Select all

sql-mode="NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"

, but nothing
modifiation3 : i use this syntax

Code: Select all

sql_mode=

to make the 2 modifications, but nothing

I NEED HELP, please

[alfa24]

Try to create database before launching the installer.

[anohjp]

Hi Alfa24

The database has be created before installing.

[alfa24]

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?

[anohjp]

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 !

[alfa24]

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.

[anohjp]

Hi Alfa24,

I work in local

[hakangur]

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