#44502 [Opn]: Compiling ok with MySQL 5.0

ID: 44502 Updated by: felipe@php.net Reported By: nickg78 at gmail dot com Status: Open Bug Type: Compile Failure Operating System: Linux PHP Version: 6CVS-2008-03-22 (snap) New Comment: Looks that it was added in 5.0.3 version, here's a patch: http://felipe.ath.cx/diff/mysql.diff (non tested) Changing mysql/php_mysql.c, mysqli/mysqli.c and mysqli/mysqli_api.c Previous Comments: ------------------------------------------------------------------------ [2008-03-22 05:05:54] nickg78 at gmail dot com Finally after some further testing, it appears that the problem does not occur with MySQL 5.0, but only with 4.1 I upgraded my MySQL version to 5.0 and now PHP is compiled without errors. Please ignore this bug report if PHP 6.0 is officially announced to be incompatible with MySQL 4.1 but I have not found anything mentioning this. ------------------------------------------------------------------------ [2008-03-22 03:34:06] nickg78 at gmail dot com Description: ------------ While trying to compile PHP 6 with mysql or mysqli, compile fails with error /ext/mysql/php_mysql.c:2086: error: 'MYSQL_TYPE_VARCHAR' undeclared (first use in this function) Reproduce code: --------------- These are the configure options for MySQL that were working with no problems while compiling PHP 5.0-5.2: ./configure --with-mysqli --with-mysql=/usr Expected result: ---------------- Successful PHP compile Actual result: -------------- ext/mysql/php_mysql.c: In function 'php_mysql_fetch_hash': ext/mysql/php_mysql.c:2086: error: 'MYSQL_TYPE_VARCHAR' undeclared (first use in this function) ext/mysql/php_mysql.c:2086: error: (Each undeclared identifier is reported only once ext/mysql/php_mysql.c:2086: error: for each function it appears in.) make: *** [ext/mysql/php_mysql.lo] Error 1 MySQL version is 4.1.22 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=44502&edit=1