Common Problems with MySQL and PHP

July 13, 2006 § Leave a comment

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

    Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    What’s this?

    You are currently reading Common Problems with MySQL and PHP at Rupom Here.

    meta

    %d bloggers like this: