Since I'm using PHP 4.2.3 phpMyAdmin (http://www.phpmyadmin.net) does
not work properly anymore. To me it seems as if string routines would be
broken. As an example I have two errormessages generated from
phpMyAdmin:

Creating a simple table with ID as auto_increment:

--
CREATE TABLE `atest` (

`ID` INT NULL _INCREMENT,
PRIMARY KEY ( `ID` ) 
) 

MySQL meldet: 

You have an error in your SQL syntax near '_INCREMENT, PRIMARY KEY
(`ID`))' at line 1
--

It seems as if this PHP version would kill the "auto" in front of
"_increment". Of course, then MySQL produces an error.

Second example: If I change a value (DATE), I get the following error:

--
UPDATE `termine` SET `datum` = '-09-23' WHERE `ID` = \'42\' LIMIT 1; 

MySQL meldet: 

You have an error in your SQL syntax near '\'42\' LIMIT 1' at line 1
--

There is one ' too much (changing MagicQuotes did not help anything)

I do not thing that this is a problem of phpMyAdmin because I just
recompiled PHP 4.2.2 with exactly the same configure options on the same
system (2 days difference, so no new libraries etc) and everything works
just perfect.

My confiugure Line:
--
'./configure' '--prefix=/usr/share' '--datadir=/usr/share/php'
'--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include'
'--with-config-file-path=/etc/httpd' '--with-exec-dir=/usr/lib/php/bin'
'--disable-debug' '--enable-bcmath' '--enable-calendar' '--enable-ctype'
'--enable-dbase' '--enable-discard-path' '--enable-exif'
'--enable-filepro' '--enable-force-cgi-redirect' '--enable-ftp'
'--enable-gd-imgstrttf' '--enable-gd-native-ttf'
'--enable-inline-optimization' '--enable-magic-quotes'
'--enable-mbstr-enc-trans' '--enable-mbstring' '--enable-memory-limit'
'--enable-shmop' '--enable-sigchild' '--enable-sysvsem'
'--enable-sysvshm' '--enable-track-vars' '--enable-versioning'
'--enable-wddx' '--enable-yp' '--with-bz2' '--with-ftp' '--with-gdbm'
'--with-gettext' '--with-gmp' '--with-imap=yes'
'--with-jpeg-dir=/usr/lib' '--with-ldap=yes' '--with-mcal=/usr'
'--with-mcrypt' '--with-mysql=/usr' '--with-ndbm' '--with-pgsql=/usr'
'--with-snmp' '--with-t1lib' '--with-ttf' '--with-freetype-dir=yes'
'--with-zlib=yes' '--with-openssl' '--with-curl' '--with-imap-ssl'
'--with-gd=yes' '--with-mm' '--with-apxs=/usr/sbin/apxs' '--with-ming'
'--with-mhash' '--with-pdflib' '--with-png-dir=/usr/lib'
'--with-tiffs-dir=/usr/lib' '--with-iodbc'
--
I do not include a backtrace because PHP does not crash at all. The
system continues to run, the page gets finished and I can continue to
work with PHP.

[14 Sep 10:53am] iliaa at php.net

Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem does not imply a bug in PHP itself.
For a list of more appropriate places to ask for help using PHP,
please visit http://www.php.net/support.php

Thank you for your interest in PHP.


[14 Sep 11:19am] mv02 at gmx.de

Hm, but its a strange behaviour of PHP if the same script worked from
Version 4.0.0 up to 4.2.2 and just stopped with 4.2.3. I don't believe
this is because of the script :) Even the configuration file has been
adapeted (MagicQuoting, SafeMode, RegisterGlobals etc)

[14 Sep 11:32am] wez at php.net

This was a problem with mbstring that has been fixed in CVS.
The workaround is not to use --enable-mbstr-enc-trans
when configuring PHP. (You won't miss it, because the
chances are that you don't even know what it does :-)

[14 Sep 11:33am] wez at php.net

Reclassify