Help Desk Help Desk   Live Chat Live Chat   Phone +1 (720) 336-8323 M-F 9am-5pm MST
Free Trial
Client Login
Help Desk
Help Desk » 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? send comment
55 people found this helpful