Common Problems with MySQL and PHP
July 13, 2006 §
We get some common problems during our development work by PHP/MySQL. Here is a short list of common problems with MySQL and PHP along with possible solutions:
Error: Maximum Execution Time Exceeded: This is a PHP limit; go into the php.ini file and set the maximum execution time up from 30 seconds to something higher, as needed. It is also not a bad idea to double the RAM allowed per script to 16MB instead of 8MB.
Fatal error: Call to unsupported or undefined function mysql_connect() in …: This means that your PHP version isn’t compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This process is described in detail in the PHP manual.
Error: Undefined reference to ‘uncompress’: This means that the client library is compiled with support for a compressed client/server protocol. The fix is to add -lz last when linking with -lmysqlclient.
Error: Client does not support authentication protocol: This is most often encountered when trying to use the older mysql extension with MySQL 4.1.1 and later. Possible solutions are: downgrade to MySQL 4.0; switch to PHP 5 and the newer mysqli extension; or configure the MySQL server with –old-passwords. (See “Client does not support authentication protocol”, for more information.)
See more about it here:
Enjoy PHPing !