9.4.1 Common Problems with MySQL and PHP

• Error: "Maximum Execution Time Exceeded" This is a PHP limit; go into the `php3.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 16 MB instead of 8 MB.
• Error: "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 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.

User Comments

php3.ini changed filename to php.ini with php 4

MySQL has been unbundled from PHP5, as the MySQL client library license has been changed to GPL, which is incompatible with the PHP license. MySQL client libraries were formerly LGPL, which has a more flexible linking policy. If MySQL and PHP can develop an exception for the PHP distribution, MySQL may be bundled with PHP once again.

To change execution time of a PHP script you can use the PHP function 'set_time_limit(int second)" instead of modify manually PHP.ini file. You've just to give the execution time in second.

The MySQL-shared-compat RPM package provides the libmysqlclient.so.10
library for use with other packages that rely on it (such as PHPmysql) which is good but this rpm requires libss1l.so.9.6 and libcrypto.so.0.9.6 (from openssl-0.9.6) package) and Redhat 9 and others are now shipping with openssl-0.9.7a at present so it can't be installed on RedHat 9 running MySQL 4.1

Add your own comment.