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

The error is due to latest versions of the core PHP missing the MySQL functions.  You'll want to now reference the PHP Live! system to utilize the updated and improved MySQLi functions.

 

IMPORTANT: Be sure that your PHP Live! system is v.4.3.6 or greater.  The $CONF['SQLTYPE'] variable was introduced on 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.

 

If seeing this error, the method to check the version of your PHP Live! system is to access the phplive/web/VERSION.php file via FTP or SSH.  If your PHP Live! version is not v.4.3.6 or greater, an upgrade of your PHP Live! system is needed so that the system recognizes the new SQLTYPE variable.

 

This is what you'll want to do:

 

  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:
    * if the variable does not exist, add the entire line:
    $CONF['SQLTYPE'] = 'SQLi.php' ;

     

  3. Save file and done!

 

NOTE: The system supports PDO MySQL connection method as well.  Simply update the above $CONF['SQLTYPE'] value to PDO.php instead of SQLi.php.

Was this documentation helpful to you?
© OSI Codes Inc. All Rights Reserved  /  Privacy  /  License Agreement  /  Help Desk  /  Contact Us
phone: +1 917-338-7663 (M-F 10:00am-6:00pm EST)