Try it FREE
Knowledge Base Frequently Asked Questions   Phone Phone: +1 (720) 336-8323 M-F 9am-5pm MST   Download Free
Free Trial
Knowledge Base
Knowledge Base » 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
57 people found this helpful
back to top