| Bug #20976 | Silent release? Error is gone away.... | ||
|---|---|---|---|
| Submitted: | 11 Jul 2006 19:59 | Modified: | 23 Aug 2006 2:29 |
| Reporter: | Harald Reindl | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Compiling | Severity: | S1 (Critical) |
| Version: | 5.0.24 | OS: | Windows (Win32/Linux) |
| Assigned to: | CPU Architecture: | Any | |
[11 Jul 2006 20:15]
Harald Reindl
Using the old "libmysql.dll" (5.0.22) makes working all well phpMyAdmin: MySQL - 5.0.23-community-nt-log / PHP 5.2.0-dev MySQL Client-Version: 5.0.22 Verwendete php Erweiterungen: mysqli
[14 Jul 2006 9:40]
Valeriy Kravchuk
Thank you for a problem report. 5.0.23 was not released officially. As 5.0.22 works, please, wait for the next official release and check, if this problem is still repeatable.
[5 Aug 2006 9:06]
Harald Reindl
Damned the error is also in the "libmysql.dll" bundeled with MySQL 50.24 Server works OK, but i dont understand how it can be that the client is broken again - you got a really small sample to check it. I use now PHP 5.2.0dev with mySQL-Server 5.0.24 and "libmysql.dll" 5.0.22, so it works but why do you not throw the changes away and bundle a working client-library?
[20 Aug 2006 21:16]
Harald Reindl
If you compile php against client-librarys builded from the last 5.0.24 source mysqli-Extension auf php also comes with "command out of synch"
--
cd /mnt/data/development/src/mysql/
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \
-fno-exceptions -fno-rtti" ./configure \
--prefix=/usr/local/mysql \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--enable-local-infile \
--with-charset=latin1 \
--with-collation=latin1_german1_ci \
--without-server
make
make install
--
cd /mnt/data/development/src/php/
./configure --silent \
--with-mysql=/usr/local/mysql \
--with-mysqli \
--with-apxs2=/usr/sbin/apxs \
--with-pear=/mnt/data/www/phpincludes/pear \
--build=i686-redhat-linux-gnu \
--host=i686-redhat-linux-gnu \
--target=i686-redhat-linux-gnu \
--program-prefix= \
--prefix=/usr \
--exec-prefix=/usr \
--bindir=/usr/bin \
--sbindir=/usr/sbin \
--sysconfdir=/etc \
--datadir=/usr/share \
--includedir=/usr/include \
--libdir=/usr/lib \
--libexecdir=/usr/libexec \
--localstatedir=/var \
--sharedstatedir=/usr/com \
--mandir=/usr/share/man \
--infodir=/usr/share/info \
--with-libdir=lib \
--with-config-file-path=/etc \
--disable-debug \
--with-pic \
--disable-rpath \
--with-bz2 \
--with-curl \
--with-exec-dir=/usr/bin \
--with-freetype-dir=/usr \
--with-png-dir=/usr \
--enable-gd-native-ttf \
--without-gdbm \
--with-gettext \
--with-gmp \
--with-iconv \
--with-jpeg-dir=/usr \
--with-openssl \
--with-png \
--with-pspell \
--with-expat-dir=/usr \
--with-pcre-regex=/usr \
--with-zlib \
--with-layout=GNU \
--enable-exif \
--enable-ftp \
--enable-magic-quotes \
--enable-sockets \
--enable-sysvsem \
--enable-sysvshm \
--enable-sysvmsg \
--enable-track-vars \
--enable-trans-sid \
--enable-yp \
--enable-wddx \
--with-kerberos \
--enable-ucd-snmp-hack \
--with-unixODBC=shared,/usr \
--enable-memory-limit \
--enable-calendar \
--with-mime-magic=/etc/httpd/conf/magic \
--with-libxml-dir=/usr \
--with-xml \
--without-odbc \
--disable-dba \
--without-unixODBC \
--with-pgsql \
--with-pdo-mysql \
--with-pdo-pgsql \
--with-pdo-sqlite \
--with-tidy \
--with-imap \
--with-imap-ssl \
--enable-soap \
--with-xmlrpc \
--enable-bcmath \
--with-mcrypt \
--with-mhash \
--enable-mbstring \
--with-gd \
--with-ttf \
--with-mssql
make
[23 Aug 2006 2:29]
Harald Reindl
Have you made a "silent" new release of MySQL? Ive seen the newsletter and the connector for php 5.1.5/mysql 5.0.24 for windows, tried and wonder, now it works. Same for the own compilation on linux with "--with-mysql=usr/local/mysql" after rebuild of the client-librarys with the last download from tonight. please give me some feedback :-)
Description: PHP-mysqli-Extension broken with MySQL 5.0.23 Here runs the Win32-no-install-Build Dont know other platforms and like not to test it on production server :-) Every Query results in a "Commands out of sync; you can't run this command now" Classic mysql-Extension works well This short script and that phpMyAdmin also is broken shows me that it is not my own abstraction-layer, the error is in the server himself How to repeat: Example: <?php $conn = mysqli_init(); $rw = mysqli_real_connect($conn, '127.0.0.1', 'test', '***', 'test', 3306, ''); if($rw) mysqli_real_query($conn, 'select version();') or die(mysqli_error(($conn))); else exit('NO CONNECT'); ?> Suggested fix: Stop delivering 5.0.23 and bring out a correct version :-)