Description:
Features or patches that were placed in MySQL DB Server 4.1.3 are not available in MySQL DB Server 5.0 . This is a problem since the mysqli module of PHP 5 is expecting those features. Upon compiling PHP 5 (with mysqli) after installing MySQL 5, this error will result during the PHP configure stage:
checking for mysql_stmt_field_count in -lmysqlclient... no
configure: error: MySQLI doesn't support versions < 4.1.3 anymore.
Please update your libraries.
For more information, see:
http://us3.php.net/manual/en/ref.mysqli.php
http://www.mail-archive.com/php-bugs@lists.php.net/msg49212.html
How to repeat:
Install MySQL 5.0 like this:
gzip -cd mysql-5.0.0-alpha.tar.gz | tar -xvf -
cd mysql-5.0.0-alpha
CXXFLAGS="-O3 -felide-constructors \
-fno-exceptions -fno-rtti" CC=gcc CXX=gcc ./configure --prefix=/usr --localstatedir=/var/lib/mysql --with-extra-charsets=none --without-bench --without-readline --with-mysqld-user=mysql --with-client-ldflags=-all-static --enable-assembler --enable-thread-safe-client
make
make install
cd ..
Download and configure PHP 5.0 as such:
gzip -cd php-5.0.0.tar.gz | tar -xvf -
cd php-5.0.0
./configure --prefix=/usr --datadir=/usr/share/php --mandir=/usr/share/man --bindir=/usr/bin --libdir=/usr/share --includedir=/usr/include --sysconfdir=/etc --with-_lib=lib --with-config-file-path=/etc --with-exec-dir=/usr/lib/php/bin --enable-inline-optimization --enable-memory-limit --enable-magic-quotes --enable-safe-mode --enable-sigchild --without-pear --with-openssl --with-apxs2=/usr/local/apache2/bin/apxs i586-suse-linux --with-mysqli=/usr/bin/mysql_config
Suggested fix:
Apply same features or patches from MySQL DB Server 4.1.3 into MySQL 5.0 .
