hi, i have a question about the ip logging

[flyer0303]

that exist 3 options

1. not ip logging, works very well
2. Display publicly, works also

3. Display but require administrator or moderator

that dont work
if i klick at the IP: Logged link i get this:



There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



and as mail i get this:



Database error in vBulletin: Invalid SQL: SELECT forumid
FROM forum WHERE threadid=120
mysql error: Unknown column 'threadid' in 'where clause'
mysql error number: 1054
Date: Monday 19th of June 2000 03:10:00 PM
Script: /forum/postings.php?action=getip&postid=1106
Referer: http://www.mobilfunk-hilfe.de/forum/showthread.php?threadid=2


u can found the board here

http://www.mobilfunk-hilfe.de/forum/index.php3

whats wrong?

[Edited by flyer0303 on 06-19-2000 at 10:03 AM]

[flyer0303]

can noone help me??

[doron]

this should go in the bugs forum, and I think this is known

SELECT forumid FROM forum WHERE threadid=120
threadid is not in forum, but in table thread.

[John]

This has been fixed in version 1.1.3, so you should upgrade to that.

John

[Lucky]

I found this problem with version 1.1.3. When I go to view a users IP, I get the server IP. Everyuser logs the same address, I have not yet tried the other two functions, Public, and no display, but none the less I would like to find the error.

A note for the staff here, my server does not run scripts with just .php, on the end of the file name, I had to rename all my scripts to .php3. I also tested this, on another server, that I want to convince the owner to switch to this board. Hey, I want commission!, hehe :)

Anyways, this should maybe go in another thread, but, I wonder if vBulleting would consider having an optional download, with the .php3, or .php4 file name. I know the test.php script tells me the php on the servers is installed incorrectly, but..... however, am I right to think that, that more of a preferance than anything?

[John]

Lucky, could you provide some info about your server and software versions please.

Re: .php3 : Once I have got a final stable version of 1.1.3 out, I will probably create a version with .php3 extensions.

John

[Lucky]

Your the man John! ;)

Well, Im not sure what exactly you would like to know, however, this is what I found.

PHP Version 3.0.12

PHP core CFLAGS=
HSREGEX=
Basic Functions No additional information.
PHP_DL Dynamic Library support enabled.
PHP_dir No additional information.
PHP_filestat No additional information.
PHP_file No additional information.
PHP_head No additional information.
Sendmail Path to sendmail: /usr/bin/sendmail -t
Syslog No additional information.
MySQL Allow persistent links: Yes
Persistent links: 1/Unlimited
Total links: 1/Unlimited
Client API version: 3.22.32
Compilation definitions: MYSQL_INCLUDE=
MYSQL_LFLAGS=
MYSQL_LIBS=

Socket functions No additional information.
Regular Expressions Bundled regex library enabled
Apache APACHE_INCLUDE=
APACHE_TARGET=
Apache Version: Apache/1.3.6
Apache Release: 10306100
Apache API Version: 19990320
Hostname/port: 8thaf.com:30153
User/Group: nobody(65534)/99
Max Requests: per child: 30 keep alive: on max per connection: 100
Timeouts: connection: 300 keep-alive: 15
Server Root: /home/webpages/userworld/htdocs/users/Stripes/httpd
Loaded modules: mod_php3, mod_frontpage, mod_perl, mod_setenvif, mod_so, mod_auth, mod_access, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_mime, mod_log_config, mod_env, http_core

Crypt No additional information.
DBM This is GDBM version 1.8.0, as of May 19, 1999.
bcmath No additional information.
browscap No additional information.
PHP_pack No additional information.
PCRE Perl Compatible Regular ExpressionsPCRE library version: 2.05 21-Apr-1999

Posix $ Revision: $

--------------------------------------------------------------------------------

Configuration
php3.ini file path is set to: /home/webpages/userworld/htdocs/users/dsp2/httpd
Directive Master Value Local Value
arg_separator & &
asp_tags 0 0
auto_prepend_file none none
auto_append_file none none
browscap none none
cgi_ext none none
debugger.host none none
debugger.port 0 0
define_syslog_variables 0 0
display_errors 1 1
doc_root none none
enable_dl 1 1
engine 1 1
error_log none none
error_append_string none none
error_prepend_string none none
error_reporting 55 55
extension_dir none none
gpc_order GPC GPC
ignore_user_abort 0 0
include_path none none
isapi_ext none none
last_modified 0 0
log_errors 0 0
max execution time 30 30
magic_quotes_gpc 0 0
magic_quotes_runtime 0 0
magic_quotes_sybase 0 0
memory limit 8388608 8388608
nsapi_ext none none
open_basedir none none
precision 14 14
safe_mode 0 0
safe_mode_exec_dir /usr/local/php/bin /usr/local/php/bin
sendmail_from none none
sendmail_path /usr/bin/sendmail -t /usr/bin/sendmail -t
short_open_tag 1 1
smtp localhost localhost
sql_safe_mode 0 0
track_errors 0 0
track_vars 1 1
upload_max_filesize 2097152 2097152
upload_tmp_dir none none
user_dir none none
warn_plus_overloading 0 0
xbithack 0 0
browscap none none
y2k_compliance 0 0
highlight_comment #FF8000 #FF8000
highlight_default #0000BB #0000BB
highlight_html #000000 #000000
highlight_string #DD0000 #DD0000
highlight_bg #FFFFFF #FFFFFF
highlight_keyword #007700 #007700

--------------------------------------------------------------------------------

Environment
Variable Value
LOGNAME Stripes
INIT_VERSION sysvinit-2.74
TERM linux
HOSTTYPE i386
PATH /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:/usr/local/bin
CONSOLE /dev/console
HOME /home/webpages/userworld/htdocs/users/Stripes
PREVLEVEL N
RUNLEVEL 3
SHELL /usr/bin/bash
USER Stripes
AUTOBOOT YES
BOOT_IMAGE 2.2.16
OSTYPE Linux
SHLVL 5
_ /home/webpages/userworld/htdocs/users/Stripes/httpd/bin/httpd

--------------------------------------------------------------------------------

PHP Variables
Variable Value
PHP_SELF /useractivepreviewtmp.php3

--------------------------------------------------------------------------------

Apache Environment
Variable Value
DOCUMENT_ROOT /home/webpages/userworld/htdocs/users/Stripes
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_HOST 8thaf.com:30153
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.01; Windows 98)
PATH /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:/usr/local/bin
REMOTE_ADDR 209.16.196.243
REMOTE_PORT 3378
SCRIPT_FILENAME /home/webpages/userworld/htdocs/users/Stripes/useractivepreviewtmp.php3
SERVER_ADMIN webmaster@8thAF.com
SERVER_NAME 8thaf.com
SERVER_PORT 30153
SERVER_SIGNATURE Apache/1.3.6 Server at 8thaf.com Port 30153

SERVER_SOFTWARE Apache/1.3.6 (Unix) PHP/3.0.12 mod_perl/1.21
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.0
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /useractivepreviewtmp.php3
SCRIPT_NAME /useractivepreviewtmp.php3

--------------------------------------------------------------------------------

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /useractivepreviewtmp.php3 HTTP/1.0
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
Accept-Encoding gzip, deflate
Accept-Language en-us
Host 8thaf.com:30153
User-Agent Mozilla/4.0 (compatible; MSIE 5.01; Windows 98)
HTTP Response Headers
Connection close
Content-Type text/html


--------------------------------------------------------------------------------