The Arcive of Official vBulletin Modifications Site.

wolfe · #1 09-05-2002, 09:01 PM

Can someone please help me i get this error when i update someones profile in the AdminCP

Code:

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='',adminemail=,showemail,showemail=1,invisible=0,usertitle='Trial 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',emailnotification=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='Trial 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/us...dit&userid=332

what does it mean

Steve Machol · #2 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 · #3 09-05-2002, 09:21 PM

no my current server PHP version is

Current PHP version: 4.1.0

Steve Machol · #4 09-05-2002, 09:43 PM

Do you have a phpinfo.php file? If not create a text file with this content:

PHP Code:


			
<?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 · #5 09-06-2002, 12:04 AM

heres the info

Code:

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

Code:

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 · #6 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 · #7 09-06-2002, 11:30 AM

lol sorry but i sorted it now it was something to do wioth the Awa Hack

sorted thanx for your help

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04603 seconds Memory Usage 2,259KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (3)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (7)post_thanks_box (7)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (7)post_thanks_postbit_info (7)postbit (7)postbit_onlinestatus (7)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!