PHP Live! Help Desk
Search:
» Help Desk Home » Errors and Troubleshooting » MySQL "mysql extension is deprecated"
MySQL "mysql extension is deprecated"

The error is due to missing MySQL PHP extension that is needed to connect to the database.  You'll want to reference the PHP Live! system to utilize the MySQLi or PDO connection method.

 

IMPORTANT: Be sure that your PHP Live! system is v.4.3.6 or greater.  The $CONF['SQLTYPE'] variable was introduced in v.4.3.6 and prior versions will not be able to process the variable.  The latest version can be downloaded at the client area.

 

Here is what you'll want to do:

* if not already, upgrade your PHP Live! to the latest version before proceeding

 

  1. Edit the file phplive/web/config.php

  2. Modify the variable $CONF['SQLTYPE'] so that the PHP Live! system references the SQLi.php library (or PDO.php):
    * if the variable does not exist, add the entire line:

    $CONF['SQLTYPE'] = 'SQLi.php' ;

     

  3. Save file.
  4. Done!

 

NOTE: If the SQLi.php produces an error, try PDO MySQL connection method.  Update the above $CONF['SQLTYPE'] to PDO.php instead of SQLi.php.

$CONF['SQLTYPE'] = 'PDO.php' ;

Was this helpful?
could be more helpful? let us know
48 people found this helpful
Chat Icons Download         Profile Picture Icons Download         Integrations         Windows WinApp         Mobile App         SMTP         Help Desk