mysqli configuration

Install and configure FormaLMS and DoceboCE
Post Reply
magos
Newbie
Posts: 2
Joined: Thu Jul 07, 2016 2:15 pm
Version: forma.lms 1.4.2

mysqli configuration

Post by magos »

I installed FormaLMS 1.4.2 on my localhost in a development environment using Xampp which is running PHP7.0.6 and MariaDB 10.1.13 and I get error due to a mysql_connect call which tells me the functions are deprecated. I then headed over to the config.php file and told FormaLMS to use the mysqli driver instead scene as though PDO was not an option and I got errors stating that calls are being made to mysql_escape_string. I thought I might as well start a little debug process and see what happens so I converted mysql_escape_string to mysqli_real_escape_string and just get a blank screen with no errors even after checking the Apache Error Log. I have undone all my changes but I am thinking there must surely be an easier way to install FormaLMS and configure it to use mysqli? Any ideas or suggestions would be really helpful. Thank you in advance.
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: mysqli configuration

Post by max »

Hi,
welcome to the community.

Have you checked Forma Lms requirements, before installing? Forma still does not support php 7.
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
canelli
FormaLms Guru
Posts: 496
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 2.0
Contact:

Re: mysqli configuration

Post by canelli »

In PHP 7.xx standard sql driver has been deprecated . the suggestion coming from PHP team is use mysqli or PDO driver
unfortunally forma.lms is not ready to use mysqli nor PDO driver, due to the fact that not always it use a centralized driver to call DB

So the best way is to disable DEPRECATED warning in PHP configuration file ( php.ini ).

we are working to enable forma.lms use mysqli or PDO driver. This will be available in the forma.lms 2.0 release

Please note also that PHP 7.x is not supported by forma.lms . IF you can switch to a 5.x version
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

http://www.joint-tech.com
---------------
magos
Newbie
Posts: 2
Joined: Thu Jul 07, 2016 2:15 pm
Version: forma.lms 1.4.2

Re: mysqli configuration

Post by magos »

Thank you so much for the advice I will downgrade my PHP version to start with so hopefully that will help. I am very eager to get into Forma LMS.
Post Reply