Common Problems with MySQL and PHP

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.)
  • [reference: http://dev.mysql.com%5D

    See more about it here:
    http://dev.mysql.com/doc/refman/5.0/en/php-problems.html

    Enjoy PHPing !

    Regards,
    Rupom