FormaLms Installation : step 4

Install and configure FormaLMS and DoceboCE
Post Reply
anohjp
Newbie
Posts: 5
Joined: Tue Dec 17, 2019 12:22 am
Version: forma.lms 2.0

FormaLms Installation : step 4

Post by 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
Senior Boarder
Posts: 1985
Joined: Fri Nov 24, 2017 8:45 am

Re: FormaLms Installation : step 4

Post by alfa24 »

Per supporto GRATUITO contattatemi in privato qui
anohjp
Newbie
Posts: 5
Joined: Tue Dec 17, 2019 12:22 am
Version: forma.lms 2.0

Re: FormaLms Installation : step 4

Post by 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
Attachments
Untitled-1.jpg
alfa24
Senior Boarder
Posts: 1985
Joined: Fri Nov 24, 2017 8:45 am

Re: FormaLms Installation : step 4

Post by alfa24 »

Try to create database before launching the installer.
Per supporto GRATUITO contattatemi in privato qui
anohjp
Newbie
Posts: 5
Joined: Tue Dec 17, 2019 12:22 am
Version: forma.lms 2.0

Re: FormaLms Installation : step 4

Post by anohjp »

Hi Alfa24

The database has be created before installing.
alfa24
Senior Boarder
Posts: 1985
Joined: Fri Nov 24, 2017 8:45 am

Re: FormaLms Installation : step 4

Post by 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?
Per supporto GRATUITO contattatemi in privato qui
anohjp
Newbie
Posts: 5
Joined: Tue Dec 17, 2019 12:22 am
Version: forma.lms 2.0

Re: FormaLms Installation : step 4

Post by 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 !
Attachments
Untitled-1.jpg
Untitled-1.jpg (92.27 KiB) Viewed 5816 times
Untitled-2.jpg
alfa24
Senior Boarder
Posts: 1985
Joined: Fri Nov 24, 2017 8:45 am

Re: FormaLms Installation : step 4

Post by 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.
Per supporto GRATUITO contattatemi in privato qui
anohjp
Newbie
Posts: 5
Joined: Tue Dec 17, 2019 12:22 am
Version: forma.lms 2.0

Re: FormaLms Installation : step 4

Post by anohjp »

Hi Alfa24,

I work in local
hakangur
FormaLms User
Posts: 27
Joined: Sat Jul 21, 2018 1:27 pm
Version: forma.lms 2.0

Re: FormaLms Installation : step 4

Post by 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
Post Reply