php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #20016 Unable to save result set
Submitted: 2002-10-21 16:35 UTC Modified: 2002-11-14 02:09 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:2 (100.0%)
From: balbert at jupitermedia dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.3 OS: redhat 7.2
Private report: No CVE-ID:
 [2002-10-21 16:35 UTC] balbert at jupitermedia dot 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 




Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-11-14 02:09 UTC] georg@php.net
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.
 
PHP Copyright © 2001-2014 The PHP Group
All rights reserved.
Last updated: Sun Apr 20 05:03:19 2014 UTC