Bug #4895 Patches from MySQL DB Server 4.1.3 not available in MySQL 5.0

Submitted: 4 Aug 2004 15:04 Modified: 4 Aug 2004 16:59
Reporter: Robert Seaborn Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.0 OS:Linux (Linux x86)
Assigned to: CPU Architecture:Any

[4 Aug 2004 15:04] Robert Seaborn
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 .
[4 Aug 2004 16:59] Georg Richter
PHP5's mysqli extension only works with MySQL 5.0.1 - not with 5.0.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.