View Full Version : User.php Problem :( Please Help.
wolfe
09-05-2002, 09:01 PM
Can someone please help me i get this error when i update someones profile in the AdminCP
Database error in vBulletin Control Panel 2.2.4:
Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1970-01-01 01:00:00'),returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='2',username='testing ',email='',styleid='1',parentemail='',coppauser=0, homepage='http://www.',icq='',aim='',yahoo='',signature='',adminema il=,showemail,showemail=1,invisible=0,usertitle='T rial Member<br><img src=\"http://www.board.com/forums/images/0stars.gif\">',customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-04 22:38:54'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-09-05 01:09:35'),lastactivity=UNIX_TIMESTAMP('2002-09-05 01:09:35'),lastpost=UNIX_TIMESTAMP('2002-09-05 01:00:34'),posts='10',timezoneoffset='0',emailnoti fication=1,receivepm='1',emailonpm='0',ipaddress=' ',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=332
mysql error: You have an error in your SQL syntax near 'showemail,showemail=1,invisible=0,usertitle='Tria l Member<br><img src=\"http://w' at line 1
mysql error number: 1064
Date: Thursday 05th of September 2002 10:52:40 PM
Script: http://www.board.com/forums/forums/admin/user.php
Referer: http://www.board.com/forums/admin/user.php?action=edit&userid=332
what does it mean :(
Steve Machol
09-05-2002, 09:09 PM
This means that your host has upgraded to PHP 4.2.x. Unfortunately the only fix is for you to upgrade to vB 2.2.7.
wolfe
09-05-2002, 09:21 PM
no my current server PHP version is
Current PHP version: 4.1.0
Steve Machol
09-05-2002, 09:43 PM
Do you have a phpinfo.php file? If not create a text file with this content:
<?php
phpinfo();
?>Name it 'phpinfo.php' then upload it to your forum directory and post the URL here. This will help us troubleshoot the problem.
wolfe
09-06-2002, 12:04 AM
heres the info :D
PHP Version 4.1.0
System FreeBSD bfr41.plesk.ru 4.1-RELEASE FreeBSD 4.1-RELEASE #0: Fri Jul 28 14:30:31 GMT 2000 jkh@ref4.freebsd.org:/usr/src/sys/compile/GENERIC i386
Build Date Mar 23 2002
Configure Command './configure' '--with-apxs=apxs' '--prefix=/usr/home/kap/kap/psa/2.5-dummies/apache/../release/usr/local/psa/apache' 'i386--freebsd4.1' '--with-system-regex' '--with-config-file-path=/usr/local/psa/apache/conf' '--disable-debug' '--disable-pear' '--enable-sockets' '--enable-track-vars' '--without-gd' '--with-mysql=/usr/home/kap/kap/psa/2.5-dummies/apache/../release/dist/usr/local/psa/mysql' '--with-iodbc=/usr/home/kap/kap/psa/2.5-dummies/apache/../release/lib/libiodbc' '--with-imap=/usr/home/kap/kap/psa/2.5-dummies/apache/../release/lib/imap-cclient'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/psa/apache/conf/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.1.0a, Copyright (c) 1998-2001 Zend Technologies
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
2039 2039
expose_php
On On
extension_dir
./ ./
file_uploads
1 1
gpc_order
GPC GPC
highlight.bg
#FFFFFF #FFFFFF
highlight.comment
#FF9900 #FF9900
highlight.default
#0000CC #0000CC
highlight.html
#000000 #000000
highlight.keyword
#006600 #006600
highlight.string
#CC0000 #CC0000
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
/usr/local/psa/home/vhosts/board.com/httpdocs no value
output_buffering
no value no value
output_handler
no value no value
post_max_size
8M 8M
precision
14 14
register_argc_argv
On On
register_globals
On On
safe_mode
On On
safe_mode_exec_dir
/nonexec /nonexec
safe_mode_gid
Off Off
safe_mode_include_dir
no value no value
sendmail_from
me@localhost.com me@localhost.com
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
upload_max_filesize
2M 2M
upload_tmp_dir
/tmp /tmp
user_dir
no value no value
variables_order
EGPCS EGPCS
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 System 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
session.use_trans_sid
1 1
sockets
Sockets Support enabled
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
posix
Revision $Revision: 1.33.2.1 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library iodbc
ODBC_INCLUDE -I/usr/home/kap/kap/psa/2.5-dummies/apache/../release/lib/libiodbc/include
ODBC_LFLAGS -L/usr/home/kap/kap/psa/2.5-dummies/apache/../release/lib/libiodbc/lib
ODBC_LIBS -liodbc
Directive Local Value Master Value
odbc.allow_persistent
On On
odbc.check_persistent
On On
odbc.default_db
no value no value
odbc.default_pw
no value no value
odbc.default_user
no value no value
odbc.defaultbinmode
return as is return as is
odbc.defaultlrl
return up to 4096 bytes return up to 4096 bytes
odbc.max_links
Unlimited Unlimited
odbc.max_persistent
Unlimited Unlimited
mysql
MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 3.23.46
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/home/kap/kap/psa/2.5-dummies/apache/../release/dist/usr/local/psa/mysql/include/mysql
MYSQL_LIBS -L/usr/home/kap/kap/psa/2.5-dummies/apache/../release/dist/usr/local/psa/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
imap
IMAP Support enabled
IMAP c-Client Version 2001
apache
APACHE_INCLUDE
APACHE_TARGET
Apache Version Apache/1.3.22
Apache Release 10322100
Apache API Version 19990320
Hostname:Port www.board.com:80
User/Group apache(2525)/2523
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 1000
Timeouts Connection: 300 - Keep-Alive: 15
Server Root /usr/local/psa/apache
Loaded Modules mod_perl, mod_throttle, mod_php4, mod_frontpage, mod_ssl, mod_setenvif, mod_so, mod_unique_id, mod_usertrack, mod_headers, mod_expires, mod_cern_meta, mod_proxy, mod_digest, mod_auth_dbm, mod_auth_anon, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_speling, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_mime_magic, mod_log_config, mod_define, mod_env, mod_vhost_alias, 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 /usr/local/psa/home/vhosts/board.com/httpdocs
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-gb
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE bbshowleftcolumn=0; bblastvisit=1031088733; bbuserid=1; bbpassword=45bdbbc6954ea3cc719bb9cdc559b615; sessionhash=e3405ad65854b5781b93c0d2f99df7ac; bbadminon=1; bbthreadview[1707]=1031272959; bbthreadview[1274]=1031273022; bbthreadview[1696]=1031273094
HTTP_HOST www.board.com
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
PATH /bin:/sbin:/usr/bin:/usr/sbin
REMOTE_ADDR 217.34.84.40
REMOTE_PORT 3946
SCRIPT_FILENAME /usr/local/psa/home/vhosts/board.com/httpdocs/forums/phpinfo.php
SERVER_ADDR 312.312.317.121
SERVER_ADMIN webmaster@board.com
SERVER_NAME www.board.com
SERVER_PORT 80
SERVER_SIGNATURE <ADDRESS>Apache/1.3.22 Server at www.board.com Port 80</ADDRESS>
SERVER_SOFTWARE Apache/1.3.22 (Unix) mod_perl/1.26 mod_throttle/2.11 PHP/4.1.0 FrontPage/4.0.4.3 mod_ssl/2.8.5 OpenSSL/0.9.6b
UNIQUE_ID PXf9idS7nlcAATmEKlQ
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /forums/phpinfo.php
SCRIPT_NAME /forums/phpinfo.php
HTTP Headers Information
HTTP Request Headers
HTTP Request GET /forums/phpinfo.php HTTP/1.1
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
Accept-Encoding gzip, deflate
Accept-Language en-gb
Connection Keep-Alive
Cookie bbshowleftcolumn=0; bblastvisit=1031088733; bbuserid=1; bbpassword=45bdbbc6954ea3cc719bb9cdc559b615; sessionhash=e3405ad65854b5781b93c0d2f99df7ac; bbadminon=1; bbthreadview[1707]=1031272959; bbthreadview[1274]=1031273022; bbthreadview[1696]=1031273094
Host www.board.com.com
User-Agent Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
HTTP Response Headers
X-Powered-By PHP/4.1.0
Keep-Alive timeout=15, max=1000
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html
Additional Modules
Environment
Variable Value
USER root
SSH_CLIENT 195.149.46.141 33618 22
MAIL /var/mail/root
SHLVL 1
HOME /root
SSH_TTY /dev/ttyp0
PS1 [\u@\h \W]#
LOGNAME root
_ /usr/local/psa/rc.d/psa
BLOCKSIZE K
TERM xterm
PATH /bin:/sbin:/usr/bin:/usr/sbin
PERL5LIB /usr/local/psa/lib/perl5/site_perl/5.005
SHELL /usr/local/bin/bash
PWD /root
FTP_PASSIVE_MODE YES
PHP Variables
Variable Value
PHP_SELF /forums/phpinfo.php
_COOKIE["bbshowleftcolumn"] 0
_COOKIE["bblastvisit"] 1031088733
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] 45bdbbc6954ea3cc719bb9cdc559b615
_COOKIE["sessionhash"] e3405ad65854b5781b93c0d2f99df7ac
_COOKIE["bbadminon"] 1
_COOKIE["bbthreadview"] Array
(
[1707] => 1031272959
[1274] => 1031273022
[1696] => 1031273094
)
_SERVER["DOCUMENT_ROOT"] /usr/local/psa/home/vhosts/board.com/httpdocs
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-gb
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] bbshowleftcolumn=0; bblastvisit=1031088733; bbuserid=1; bbpassword=45bdbbc6954ea3cc719bb9cdc559b615; sessionhash=e3405ad65854b5781b93c0d2f99df7ac; bbadminon=1; bbthreadview[1707]=1031272959; bbthreadview[1274]=1031273022; bbthreadview[1696]=1031273094
_SERVER["HTTP_HOST"] www.board.com
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
_SERVER["PATH"] /bin:/sbin:/usr/bin:/usr/sbin
_SERVER["REMOTE_ADDR"] 217.34.84.40
_SERVER["REMOTE_PORT"] 3946
_SERVER["SCRIPT_FILENAME"] /usr/local/psa/home/vhosts/board.com/httpdocs/forums/phpinfo.php
_SERVER["SERVER_ADDR"] 312.312.151.121
_SERVER["SERVER_ADMIN"] webmaster@board.com
_SERVER["SERVER_NAME"] www.board.com
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.22 Server at www.board.com Port 80</ADDRESS>
_SERVER["SERVER_SOFTWARE"] Apache/1.3.22 (Unix) mod_perl/1.26 mod_throttle/2.11 PHP/4.1.0 FrontPage/4.0.4.3 mod_ssl/2.8.5 OpenSSL/0.9.6b
_SERVER["UNIQUE_ID"] PXf9idS7nlcAATmEKlQ
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"]
_SERVER["REQUEST_URI"] /forums/phpinfo.php
_SERVER["SCRIPT_NAME"] /forums/phpinfo.php
_SERVER["PATH_TRANSLATED"] /usr/local/psa/home/vhosts/board.com/httpdocs/forums/phpinfo.php
_SERVER["PHP_SELF"] /forums/phpinfo.php
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["USER"] root
_ENV["SSH_CLIENT"] 195.149.46.141 33618 22
_ENV["MAIL"] /var/mail/root
_ENV["SHLVL"] 1
_ENV["HOME"] /root
_ENV["SSH_TTY"] /dev/ttyp0
_ENV["PS1"] [\\u@\\h \\W]#
_ENV["LOGNAME"] root
_ENV["_"] /usr/local/psa/rc.d/psa
_ENV["BLOCKSIZE"] K
_ENV["TERM"] xterm
_ENV["PATH"] /bin:/sbin:/usr/bin:/usr/sbin
_ENV["PERL5LIB"] /usr/local/psa/lib/perl5/site_perl/5.005
_ENV["SHELL"] /usr/local/bin/bash
_ENV["PWD"] /root
_ENV["FTP_PASSIVE_MODE"] YES
Steve Machol
09-06-2002, 01:03 AM
I meant post the link to it. I want to see the live data, not a cut-n-paste job.
wolfe
09-06-2002, 11:30 AM
lol sorry but i sorted it now it was something to do wioth the Awa Hack :D sorted thanx for your help :D
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.