#20016 [Opn->Bgs]: Unable to save result set

ID: 20016 Updated by: georg@php.net Reported By: balbert@jupitermedia.com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: redhat 7.2 PHP Version: 4.2.3 New Comment: Your error msg comes from an other mysql_query call, not from an INSERT call - or $link_id is not your default link. In case Insert fails, an error will be returned (e.g. db style does not exist), if Insert is ok, true will be returned. To see behind the scenes, download latest cvs_version and set te ini-option mysql.trace_mode to On. Previous Comments: ------------------------------------------------------------------------ [2002-10-21 16:35:39] balbert@jupitermedia.com I am gettign the error Unable to save result set when useing php to do querys to mysql. here is an example $link_id=mysql_connect("localhost","root"); mysql_select_db("vbulletin", $link_id); $query_id = mysql_query('INSERT INTO style VALUES (1, 1, 1, \'Default\', 1)',$link_id); if (!$query_id) { print mysql_error(); print mysql_errno(); } my configureation looks like OPTIM="-O3" \ CFLAGS=" -fno-strict-aliasing" \ LIBS="-lpthread" ./configure \ --prefix=/opt/php-4.2.3 \ --with-apxs=/opt/bin/apxs \ --with-config-file-path=/opt/php-4.2.3/lib/ \ --without-pear \ --with-mysql=/opt/mysql \ --enable-oas \ --with-oci8 \ --with-gnu-ld \ --enable-inline-optimization \ --enable-track-vars \ --with-mcrypt \ --enable-sigchild and I have also tryed builtin support and stand alone support ie --with-mysql and --with-mysql=/opt/mysql and have also tryed turning everything else off. ./configure \ --prefix=/opt/php-4.2.3 \ --with-apxs=/opt/bin/apxs \ --with-config-file-path=/opt/php-4.2.3/lib/ \ --without-pear \ --with-mysql=/opt/mysql with the same results I have atache my php.ini file to the end Please contact me if you need any more info. I was looking throught some other bug reports and it looks like it may have something to do with usein apxs but I need to compile it that way. Byron PHP Version 4.2.3 System Linux linsrv-2.iworld.com 2.4.16 #1 SMP Thu Dec 6 21:49:21 EST 2001 i686 unknown Build Date Oct 21 2002 17:22:07 Configure Command './configure' '--prefix=/opt/php-4.2.3' '--with-apxs=/opt/bin/apxs' '--with-config-file-path=/opt/php-4.2.3/lib/' '--without-pear' '--with-mysql=/opt/mysql' Server API Apache Virtual Directory Support disabled Configuration File (php.ini) Path /opt/php-4.2.3/lib/ Debug Build no Thread Safety disabled Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies PHP 4 Credits Configuration PHP Core Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen 1 1 always_populate_raw_post_data 0 0 arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value enable_dl On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting no value no value expose_php On On extension_dir /opt/php-4.2.3/lib/php/extensions/no-debug-non-zts-20020429 /opt/php-4.2.3/lib/php/extensions/no-debug-non-zts-20020429 file_uploads 1 1 gpc_order GPC GPC highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_user_abort Off Off implicit_flush Off Off include_path .: .: log_errors Off Off magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off max_execution_time 30 30 open_basedir no value no value output_buffering 0 0 output_handler no value no value post_max_size 8M 8M precision 14 14 register_argc_argv On On register_globals Off Off safe_mode Off Off safe_mode_exec_dir 1 1 safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i short_open_tag On On SMTP localhost localhost sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value variables_order no value no value xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance Off Off xml XML Support active XML Namespace Support active EXPAT Version 1.95.2 standard Regex Library Bundled library enabled Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 safe_mode_allowed_env_vars PHP_ PHP_ safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH url_rewriter.tags a=href,area=href,frame=src,form=fakeentry a=href,area=href,frame=src,form=fakeentry session Session Support enabled Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /tmp /tmp session.serialize_handler php php session.use_cookies On On session.use_trans_sid 1 1 posix Revision $Revision: 1.42.2.3 $ pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 3.4 22-Aug-2000 mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.22.32 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/opt/mysql/include/mysql MYSQL_LIBS -L/opt/mysql/lib/mysql -lmysqlclient Directive Local Value Master Value mysql.allow_persistent On On mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited ctype ctype functions enabled (experimental) apache APACHE_INCLUDE APACHE_TARGET Apache Version Apache/1.3.27 Apache Release 10327100 Apache API Version 19990320 Hostname:Port linuxnewbie.org:80 User/Group iworld(507)/507 Max Requests Per Child: 1000 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 15 Server Root /www Loaded Modules mod_setenvif, mod_ucache, mod_php4, mod_cgi, mod_include, mod_oas, mod_TargetD, mod_headers, mod_expires, mod_info, mod_status, mod_imap, mod_dir, mod_autoindex, mod_auth, mod_access, mod_rewrite, mod_alias, mod_actions, mod_so, mod_mime, mod_log_config, mod_env, http_core Directive Local Value Master Value child_terminate 0 0 engine 1 1 last_modified 0 0 xbithack 0 0 Apache Environment Variable Value DOCUMENT_ROOT /www/linewbie/linewbie HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1 HTTP_ACCEPT_CHARSET ISO-8859-1, utf-8;q=0.66, *;q=0.66 HTTP_ACCEPT_ENCODING gzip, deflate, compress;q=0.9 HTTP_ACCEPT_LANGUAGE en-us, en;q=0.50 HTTP_COOKIE bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc HTTP_HOST 10.2.10.2 HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 ORACLE_HOME /d00/app/oracle/product/8.1.7 PATH /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin REMOTE_ADDR 10.2.1.134 REMOTE_HOST icom6-fw.iword.com REMOTE_PORT 46922 SCRIPT_FILENAME /www/linewbie/linewbie/php.php SCRIPT_URI http://linuxnewbie.org/php.php SCRIPT_URL /php.php SERVER_ADDR 10.2.10.2 SERVER_ADMIN balbert@internet.com SERVER_NAME linuxnewbie.org SERVER_PORT 80 SERVER_SIGNATURE SERVER_SOFTWARE Apache GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.0 REQUEST_METHOD GET QUERY_STRING REQUEST_URI /php.php SCRIPT_NAME /php.php HTTP Headers Information HTTP Request Headers HTTP Request GET /php.php HTTP/1.0 Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1 Accept-Charset ISO-8859-1, utf-8;q=0.66, *;q=0.66 Accept-Encoding gzip, deflate, compress;q=0.9 Accept-Language en-us, en;q=0.50 Cookie bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc Host 10.2.10.2 User-Agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 HTTP Response Headers X-Powered-By PHP/4.2.3 Connection close Content-Type text/html Additional Modules Environment Variable Value PWD /opt/php-4.2.3/lib HOSTNAME linsrv-2.iworld.com LESSOPEN |/usr/bin/lesspipe.sh %s USER root LS_COLORS no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: MACHTYPE i386-redhat-linux-gnu OLDPWD /usr/src/build/php-4.2.3 MAIL /var/spool/mail/root INPUTRC /etc/inputrc BASH_ENV /root/.bashrc LANG en_US ORACLE_HOME /d00/app/oracle/product/8.1.7 DISPLAY linsrv-2.iworld.com:10.0 LOGNAME root SHLVL 1 SHELL /bin/bash USERNAME root HOSTTYPE i386 OSTYPE linux-gnu HISTSIZE 1000 TERM xterm HOME /root PATH /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin _ /opt/bin/httpd PHP Variables Variable Value _COOKIE["bblastvisit"] 1034627028 _COOKIE["bbuserid"] 1 _COOKIE["bbpassword"] 6114ea2f09eb3dd3ab3b18aa9c51b1fc _SERVER["DOCUMENT_ROOT"] /www/linewbie/linewbie _SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1 _SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1, utf-8;q=0.66, *;q=0.66 _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate, compress;q=0.9 _SERVER["HTTP_ACCEPT_LANGUAGE"] en-us, en;q=0.50 _SERVER["HTTP_COOKIE"] bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc _SERVER["HTTP_HOST"] 10.2.10.2 _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 _SERVER["ORACLE_HOME"] /d00/app/oracle/product/8.1.7 _SERVER["PATH"] /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin _SERVER["REMOTE_ADDR"] 10.2.1.134 _SERVER["REMOTE_HOST"] icom6-fw.iword.com _SERVER["REMOTE_PORT"] 46922 _SERVER["SCRIPT_FILENAME"] /www/linewbie/linewbie/php.php _SERVER["SCRIPT_URI"] http://linuxnewbie.org/php.php _SERVER["SCRIPT_URL"] /php.php _SERVER["SERVER_ADDR"] 10.2.10.2 _SERVER["SERVER_ADMIN"] balbert@internet.com _SERVER["SERVER_NAME"] linuxnewbie.org _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_SIGNATURE"] _SERVER["SERVER_SOFTWARE"] Apache _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.0 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] _SERVER["REQUEST_URI"] /php.php _SERVER["SCRIPT_NAME"] /php.php _SERVER["PATH_TRANSLATED"] /www/linewbie/linewbie/php.php _SERVER["PHP_SELF"] /php.php _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["PWD"] /opt/php-4.2.3/lib _ENV["HOSTNAME"] linsrv-2.iworld.com _ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s _ENV["USER"] root _ENV["LS_COLORS"] no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: _ENV["MACHTYPE"] i386-redhat-linux-gnu _ENV["OLDPWD"] /usr/src/build/php-4.2.3 _ENV["MAIL"] /var/spool/mail/root _ENV["INPUTRC"] /etc/inputrc _ENV["BASH_ENV"] /root/.bashrc _ENV["LANG"] en_US _ENV["ORACLE_HOME"] /d00/app/oracle/product/8.1.7 _ENV["DISPLAY"] linsrv-2.iworld.com:10.0 _ENV["LOGNAME"] root _ENV["SHLVL"] 1 _ENV["SHELL"] /bin/bash _ENV["USERNAME"] root _ENV["HOSTTYPE"] i386 _ENV["OSTYPE"] linux-gnu _ENV["HISTSIZE"] 1000 _ENV["TERM"] xterm _ENV["HOME"] /root _ENV["PATH"] /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin _ENV["_"] /opt/bin/httpd ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20016&edit=1