PHP 4.0 Bug #4922: MySQL: Result

From: dan@stratabase.com Operating system: RedHat Linux 6.2 PHP version: 4.0 Release Candidate 1 PHP Bug Type: MySQL related Bug description: MySQL: Result If you goto the following URL and hit "edit" without entering a bugid you get the exact same error this fella is talking about. I experienced this starting at about 2:00pm PST on one of my own sites. It also started doing it on our phpMyAdmin interface. http://bugs.php.net/version4/?id=4759 Warning: Supplied argument is not a valid MySQL result resource in /local/Web/sites/phpweb/version4/bugs.php on line 440 Sorry bug id # does not exist Warning: Supplied argument is not a valid MySQL result resource in /local/Web/sites/phpweb/version4/bugs.php on line 532 Something is very wrong here, I'm getting the same type of error. My setup: Apache 1.3.12 Php 4.0RC1 MySQL 3.22.30 I'm going to try upgrading to php 4.0.0 tomorrow and see if it helps. FYI: I always tell php where mysql is installed while compiling. MAINDIR=/usr/src/web SRCDIR=$MAINDIR/src BUILDDIR=$MAINDIR/build APACHEVER=1.3.12 APACHEDIR=$BUILDDIR/apache_$APACHEVER APACHEMOD=$APACHEDIR/src/modules MODPHPVER=4.0RC1 PHPVER=4 MODPHP=$SRCDIR/php-$MODPHPVER.tar.gz APACHEPREFIX=/www/apache PHPPREFIX=/www/php PHPCONFIGFILEDIR=$APACHEPREFIX/conf MYSQL_SUPPORT=yes PGSQL_SUPPORT=no PHP_IMAP_SUPPORT=yes if [ $MOD_PHP != no ]; then echo "MOD_PHP" mkdir -p $PHPCONFIGFILEDIR DATE=date +%m-%d-%Y-%s if [ -f $PHPCONFIGFILEDIR/php.ini ]; then cp -p $PHPCONFIGFILEDIR/php.ini $PHPCONFIGFILEDIR/php.ini.$DATE fi cd $BUILDDIR tar zxf $MODPHP cd php-$MODPHPVER ./configure \ --prefix=$PHPPREFIX \ --with-config-file-path=$PHPCONFIGFILEDIR \ --with-apache=$APACHEDIR \ if [ $PHP_IMAP_SUPPORT != no ]; then echo --with-imap; fi \ if [ $MYSQL_SUPPORT != no ]; then echo --with-mysql=$MYSQLDIR; fi \ if [ $PGSQL_SUPPORT != no ]; then echo --with-pgsql=$PGSQLDIR; fi \ --with-ftp \ --disable-debug \ --enable-track-vars make make install cp -f php.ini-dist $PHPCONFIGFILEDIR/php.ini fi That's just a chunk of the script I use to install apache+mods, I figured it might give you a better understanding of how I've done things, and maybe something will stick out to you that I'm doing wrong (I am quite confident in it though). Here's at least part of the apache configure line (It's way to long to post here) ./configure \ --prefix=$APACHEPREFIX \ --with-perl=/usr/bin/perl \ --enable-suexec \ --suexec-docroot=/www/apache/htdocs \ --suexec-caller=nobody \ `if [ $MOD_CGISOCK != no ]; then echo --add-module=src/modules/extra/mod_cgi sock.c; fi` \ `if [ $MOD_FASTCGI != no ]; then echo --activate-module=src/modules/fastcgi/ libfastcgi.a; fi` \ `if [ $MOD_DAV != no ]; then echo --activate-module=src/modules/dav/libdav.a ; fi` \ `if [ $MOD_PHP != no ]; then echo --activate-module=src/modules/php$PHPVER/l ibphp$PHPVER.a; fi` \ `if [ $MOD_PERL != no ]; then echo --activate-module=src/modules/perl/libper l.a; fi` \ if [ $MOD_SSL != no ]; then echo --enable-module=ssl; fi \ --enable-rule=SHARED_CORE \ --enable-module=access \ --enable-shared=access \ --enable-module=actions \ --enable-shared=actions \ --enable-module=alias \ --enable-shared=alias \ yada yada yada yada