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: 568
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: FormaLms Installation : step 4

Post by alfa24 »

I'm Jasmines, the One. If you need, you can contact me.

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: 568
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: FormaLms Installation : step 4

Post by alfa24 »

Try to create database before launching the installer.
I'm Jasmines, the One. If you need, you can contact me.

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: 568
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

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?
I'm Jasmines, the One. If you need, you can contact me.

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 868 times
Untitled-2.jpg

alfa24
Senior Boarder
Posts: 568
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

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.
I'm Jasmines, the One. If you need, you can contact me.

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

User avatar
hakangur
Newbie
Posts: 19
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