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

Was this documentation helpful?