From: [EMAIL PROTECTED]
Operating system: redhat 7.2
PHP version: 4.2.3
PHP Bug Type: MySQL related
Bug description: Unable to save result set
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 [EMAIL PROTECTED]
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"] [EMAIL PROTECTED]
_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 bug report at http://bugs.php.net/?id=20016&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=20016&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=20016&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=20016&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=20016&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=20016&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=20016&r=support
Expected behavior: http://bugs.php.net/fix.php?id=20016&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=20016&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=20016&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=20016&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20016&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=20016&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=20016&r=isapi
