vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   User.php Problem :( Please Help. (https://vborg.vbsupport.ru/showthread.php?t=43206)

wolfe 09-05-2002 09:01 PM
User.php Problem :( Please Help.
 
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 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 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 09-06-2002 12:04 AM
heres the info :D

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 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


All times are GMT. The time now is 07:05 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01201 seconds
  • Memory Usage 1,805KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete