#19404 [NEW]: phpMyAdmin does not work properly anymore

From: mv02@gmx.de Operating system: SuSE Linux 8.0 PHP version: 4.2.3 PHP Bug Type: MySQL related Bug description: phpMyAdmin does not work properly anymore 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. -- Edit bug report at http://bugs.php.net/?id=19404&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19404&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19404&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19404&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19404&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19404&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19404&r=support Expected behavior: http://bugs.php.net/fix.php?id=19404&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19404&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19404&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19404&r=globals