Database Error

Started by Global777, September 28, 2005, 05:06:27 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Global777

September 28, 2005, 05:06:27 PM
I have successfully installed SMF and am able to perform most tasks.  The only problem I seem to be having is when I click on any category.  I get the following message:

Unknown column 'ml.ID_MEMBER' in 'on clause'
File: C:\Inetpub\wwwroot\StateLawyer\forum\Sources\MessageIndex.php
Line: 471

The error box is titled Database error

Any help would be appreciated.

xenovanis

#1
September 28, 2005, 05:09:32 PM
From what version to what version have you upgraded?
"Insanity: doing the same thing over and over again and expecting different results."

Global777

#2
September 28, 2005, 05:12:29 PM
I have setup and run SMF using versions prior to RC1.  This particular issue is happening with a fresh install of RC1.  This is not an upgrade.

Thank you...

xenovanis

#3
September 28, 2005, 05:15:23 PM
Can you post a phpinfo?

What is phpinfo.php?
"Insanity: doing the same thing over and over again and expecting different results."

Global777

#4
September 28, 2005, 06:12:47 PM Last Edit: September 28, 2005, 06:48:18 PM by Global777
First, thank you for the prompt help.

PHP Version 5.0.5

System  Windows NT WEB1 5.0 build 2195 
Build Date  Sep 5 2005 15:50:13 
Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared" 
Server API  CGI/FastCGI 
Virtual Directory Support  enabled 
Configuration File (php.ini) Path  C:\WINNT\php.ini 
PHP API  20031224 
PHP Extension  20041030 
Zend Extension  220040412 
Debug Build  no 
Thread Safety  enabled 
Zend Memory Manager  enabled 
IPv6 Support  enabled 
Registered PHP Streams  php, file, http, ftp, compress.zlib 
Registered Stream Socket Transports  tcp, udp 

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies



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

PHP Credits

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

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
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_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_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 2047 2047
expose_php On On
extension_dir ./ ./
file_uploads On On
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_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time 60 60
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from [email protected] [email protected]
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP email.globalcomputing.com [nofollow] email.globalcomputing.com [nofollow]
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:\PHP\uploadtemp C:\PHP\uploadtemp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


bcmath
BCMath support  enabled 


calendar
Calendar support  enabled 


com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value


ctype
ctype functions  enabled 


dom
DOM/XML  enabled 
DOM/XML API Version  20031129 
libxml Version  2.6.11 
HTML Support  enabled 
XPath Support  enabled 
XPointer Support  enabled 
Schema Support  enabled 
RelaxNG Support  enabled 


ftp
FTP support  enabled 


iconv
iconv support  enabled 
iconv implementation  "libiconv" 
iconv library version  1.9 

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


libxml
libXML support  active 
libXML Version  2.6.11 
libXML streams  enabled 


mysql
MySQL Support enabled
Active Persistent Links  0 
Active Links  0 
Client API version  4.1.7 

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
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
mysql.trace_mode Off Off


odbc
ODBC Support enabled
Active Persistent Links  0 
Active Links  0 
ODBC library  Win32 

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


pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled 
PCRE Library Version  6.2 01-Aug-2005 


pspell
PSpell Support  enabled 


session
Session Support  enabled 
Registered save handlers  files user sqlite 
Registered serializer handlers  php php_binary wddx 

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
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_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\PHP\sessiondata C:\PHP\sessiondata
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
Simplexml support enabled
Revision  $Revision: 1.139.2.4 $ 
Schema support  enabled 


SPL
SPL support enabled
Interfaces  RecursiveIterator, SeekableIterator 
Classes  ArrayIterator, ArrayObject, CachingIterator, CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator 


SQLite
SQLite support enabled
PECL Module version  2.0-dev $Id: sqlite.c,v 1.146.2.7 2005/06/07 15:38:37 dmitry Exp $ 
SQLite Library  2.8.14 
SQLite Encoding  iso8859 

Directive Local Value Master Value
sqlite.assoc_case 0 0


standard
Regex Library  Bundled library enabled 
Dynamic Library Support  enabled 
Internal Sendmail Support for Windows  enabled 

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
auto_detect_line_endings 0 0
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.83 90.83
date.sunset_zenith 90.83 90.83
default_socket_timeout 60 60
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,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value


tokenizer
Tokenizer Support  enabled 


wddx
WDDX Support enabled
WDDX Session Serializer  enabled 


xml
XML Support  active 
XML Namespace Support  active 
libxml2 Version  2.6.11 


zlib
ZLib Support  enabled 
Compiled Version  1.2.3 
Linked Version  1.2.3 

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name


Environment
Variable Value
ALLUSERSPROFILE  C:\Documents and Settings\All Users 
CommonProgramFiles  C:\Program Files\Common Files 
COMPUTERNAME  WEB1 
ComSpec  C:\WINNT\system32\cmd.exe 
CONTENT_LENGTH  0 
GATEWAY_INTERFACE  CGI/1.1 
HTTPS  off 
HTTP_ACCEPT  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* 
HTTP_ACCEPT_LANGUAGE  en-us 
HTTP_CONNECTION  Keep-Alive 
HTTP_HOST  www.statelawyersforum.com 
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) 
HTTP_COOKIE  SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1317143476%3Bi%3A3%3Bi%3A0%3B%7D; PHPSESSID=2c73766f05b4266d92d2059d0d95b1d1 
HTTP_ACCEPT_ENCODING  gzip, deflate 
INSTANCE_ID  7 
LOCAL_ADDR  192.168.1.101 
NUMBER_OF_PROCESSORS  2 
Os2LibPath  C:\WINNT\system32\os2\dll; 
OS  Windows_NT 
Path  C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP 
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH 
PROCESSOR_ARCHITECTURE  x86 
PROCESSOR_IDENTIFIER  x86 Family 15 Model 2 Stepping 7, GenuineIntel 
PROCESSOR_LEVEL  15 
PROCESSOR_REVISION  0207 
ProgramFiles  C:\Program Files 
REMOTE_ADDR  192.168.1.1 
REMOTE_HOST  192.168.1.1 
REQUEST_METHOD  GET 
SCRIPT_NAME  /phpinfo.php 
SERVER_NAME  www.statelawyersforum.com 
SERVER_PORT  80 
SERVER_PORT_SECURE  0 
SERVER_PROTOCOL  HTTP/1.1 
SERVER_SOFTWARE  Microsoft-IIS/5.0 
SystemDrive  C: 
SystemRoot  C:\WINNT 
TEMP  C:\WINNT\TEMP 
TMP  C:\WINNT\TEMP 
USERPROFILE  C:\Documents and Settings\Default User 
windir  C:\WINNT 
ORIG_PATH_TRANSLATED  C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php 
ORIG_PATH_INFO  /phpinfo.php 
ORIG_SCRIPT_NAME  /phpinfo.php 
SCRIPT_FILENAME  C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php 


PHP Variables
Variable Value
_REQUEST["SMFCookie66"] a:4:{i:0;s:1:\"1\";i:1;s:40:\"f053c3d27981401d5181f59d3f0812bf8b44b0a9\";i:2;i:1317143476;i:3;i:0;}
_REQUEST["PHPSESSID"] 2c73766f05b4266d92d2059d0d95b1d1
_COOKIE["SMFCookie66"] a:4:{i:0;s:1:\"1\";i:1;s:40:\"f053c3d27981401d5181f59d3f0812bf8b44b0a9\";i:2;i:1317143476;i:3;i:0;}
_COOKIE["PHPSESSID"] 2c73766f05b4266d92d2059d0d95b1d1
_SERVER["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_SERVER["CommonProgramFiles"] C:\Program Files\Common Files
_SERVER["COMPUTERNAME"] WEB1
_SERVER["ComSpec"] C:\WINNT\system32\cmd.exe
_SERVER["CONTENT_LENGTH"] 0
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["HTTPS"] off
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_HOST"] www.statelawyersforum.com [nofollow]
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
_SERVER["HTTP_COOKIE"] SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1317143476%3Bi%3A3%3Bi%3A0%3B%7D; PHPSESSID=2c73766f05b4266d92d2059d0d95b1d1
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["INSTANCE_ID"] 7
_SERVER["LOCAL_ADDR"] 192.168.1.101
_SERVER["NUMBER_OF_PROCESSORS"] 2
_SERVER["Os2LibPath"] C:\WINNT\system32\os2\dll;
_SERVER["OS"] Windows_NT
_SERVER["Path"] C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["PROCESSOR_IDENTIFIER"] x86 Family 15 Model 2 Stepping 7, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] 15
_SERVER["PROCESSOR_REVISION"] 0207
_SERVER["ProgramFiles"] C:\Program Files
_SERVER["REMOTE_ADDR"] 192.168.1.1
_SERVER["REMOTE_HOST"] 192.168.1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["SCRIPT_NAME"] /phpinfo.php
_SERVER["SERVER_NAME"] www.statelawyersforum.com [nofollow]
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_PORT_SECURE"] 0
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["SERVER_SOFTWARE"] Microsoft-IIS/5.0
_SERVER["SystemDrive"] C:
_SERVER["SystemRoot"] C:\WINNT
_SERVER["TEMP"] C:\WINNT\TEMP
_SERVER["TMP"] C:\WINNT\TEMP
_SERVER["USERPROFILE"] C:\Documents and Settings\Default User
_SERVER["windir"] C:\WINNT
_SERVER["ORIG_PATH_TRANSLATED"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_SERVER["ORIG_PATH_INFO"] /phpinfo.php
_SERVER["ORIG_SCRIPT_NAME"] /phpinfo.php
_SERVER["SCRIPT_FILENAME"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["argv"] Array
(
)

_SERVER["argc"] 0
_ENV["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_ENV["CommonProgramFiles"] C:\Program Files\Common Files
_ENV["COMPUTERNAME"] WEB1
_ENV["ComSpec"] C:\WINNT\system32\cmd.exe
_ENV["CONTENT_LENGTH"] 0
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["HTTPS"] off
_ENV["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_ENV["HTTP_ACCEPT_LANGUAGE"] en-us
_ENV["HTTP_CONNECTION"] Keep-Alive
_ENV["HTTP_HOST"] www.statelawyersforum.com [nofollow]
_ENV["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
_ENV["HTTP_COOKIE"] SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1317143476%3Bi%3A3%3Bi%3A0%3B%7D; PHPSESSID=2c73766f05b4266d92d2059d0d95b1d1
_ENV["HTTP_ACCEPT_ENCODING"] gzip, deflate
_ENV["INSTANCE_ID"] 7
_ENV["LOCAL_ADDR"] 192.168.1.101
_ENV["NUMBER_OF_PROCESSORS"] 2
_ENV["Os2LibPath"] C:\WINNT\system32\os2\dll;
_ENV["OS"] Windows_NT
_ENV["Path"] C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_IDENTIFIER"] x86 Family 15 Model 2 Stepping 7, GenuineIntel
_ENV["PROCESSOR_LEVEL"] 15
_ENV["PROCESSOR_REVISION"] 0207
_ENV["ProgramFiles"] C:\Program Files
_ENV["REMOTE_ADDR"] 192.168.1.1
_ENV["REMOTE_HOST"] 192.168.1.1
_ENV["REQUEST_METHOD"] GET
_ENV["SCRIPT_NAME"] /phpinfo.php
_ENV["SERVER_NAME"] www.statelawyersforum.com [nofollow]
_ENV["SERVER_PORT"] 80
_ENV["SERVER_PORT_SECURE"] 0
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["SERVER_SOFTWARE"] Microsoft-IIS/5.0
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\WINNT
_ENV["TEMP"] C:\WINNT\TEMP
_ENV["TMP"] C:\WINNT\TEMP
_ENV["USERPROFILE"] C:\Documents and Settings\Default User
_ENV["windir"] C:\WINNT
_ENV["ORIG_PATH_TRANSLATED"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_ENV["ORIG_PATH_INFO"] /phpinfo.php
_ENV["ORIG_SCRIPT_NAME"] /phpinfo.php
_ENV["SCRIPT_FILENAME"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php


PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact [email protected].



Thanks again.

Oldiesmann

#5
September 28, 2005, 09:25:49 PM
Try downloading the upgrade package and extracting upgrade.php and upgrade_1-1.sql, uploading them to your SMF directory then running upgrade.php. It appears that the messages table didn't get created properly.
Michael Eshom
Christian Metal Fans

Global777

#6
September 29, 2005, 01:53:08 AM
Thank you Michael and xenovanis.  However, I am still getting the following message when I try to view any board:

Unknown column 'ml.ID_MEMBER' in 'on clause'
File: C:\Inetpub\wwwroot\StateLawyer\forum\Sources\MessageIndex.php
Line: 471

Updated phpinfo:

PHP Version 5.0.5

System  Windows NT WEB1 5.0 build 2195 
Build Date  Sep 5 2005 15:50:13 
Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared" 
Server API  CGI/FastCGI 
Virtual Directory Support  enabled 
Configuration File (php.ini) Path  C:\WINNT\php.ini 
PHP API  20031224 
PHP Extension  20041030 
Zend Extension  220040412 
Debug Build  no 
Thread Safety  enabled 
Zend Memory Manager  enabled 
IPv6 Support  enabled 
Registered PHP Streams  php, file, http, ftp, compress.zlib 
Registered Stream Socket Transports  tcp, udp 

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies



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

PHP Credits

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

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
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_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_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 2047 2047
expose_php On On
extension_dir ./ ./
file_uploads On On
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_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time 60 60
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from [email protected] [email protected]
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP email.globalcomputing.com [nofollow] email.globalcomputing.com [nofollow]
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:\PHP\uploadtemp C:\PHP\uploadtemp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


bcmath
BCMath support  enabled 


calendar
Calendar support  enabled 


com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value


ctype
ctype functions  enabled 


dom
DOM/XML  enabled 
DOM/XML API Version  20031129 
libxml Version  2.6.11 
HTML Support  enabled 
XPath Support  enabled 
XPointer Support  enabled 
Schema Support  enabled 
RelaxNG Support  enabled 


ftp
FTP support  enabled 


iconv
iconv support  enabled 
iconv implementation  "libiconv" 
iconv library version  1.9 

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


libxml
libXML support  active 
libXML Version  2.6.11 
libXML streams  enabled 


mysql
MySQL Support enabled
Active Persistent Links  0 
Active Links  0 
Client API version  4.1.7 

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
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
mysql.trace_mode Off Off


odbc
ODBC Support enabled
Active Persistent Links  0 
Active Links  0 
ODBC library  Win32 

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


pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled 
PCRE Library Version  6.2 01-Aug-2005 


pspell
PSpell Support  enabled 


session
Session Support  enabled 
Registered save handlers  files user sqlite 
Registered serializer handlers  php php_binary wddx 

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
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_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\PHP\sessiondata C:\PHP\sessiondata
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
Simplexml support enabled
Revision  $Revision: 1.139.2.4 $ 
Schema support  enabled 


SPL
SPL support enabled
Interfaces  RecursiveIterator, SeekableIterator 
Classes  ArrayIterator, ArrayObject, CachingIterator, CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator 


SQLite
SQLite support enabled
PECL Module version  2.0-dev $Id: sqlite.c,v 1.146.2.7 2005/06/07 15:38:37 dmitry Exp $ 
SQLite Library  2.8.14 
SQLite Encoding  iso8859 

Directive Local Value Master Value
sqlite.assoc_case 0 0


standard
Regex Library  Bundled library enabled 
Dynamic Library Support  enabled 
Internal Sendmail Support for Windows  enabled 

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
auto_detect_line_endings 0 0
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.83 90.83
date.sunset_zenith 90.83 90.83
default_socket_timeout 60 60
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,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value


tokenizer
Tokenizer Support  enabled 


wddx
WDDX Support enabled
WDDX Session Serializer  enabled 


xml
XML Support  active 
XML Namespace Support  active 
libxml2 Version  2.6.11 


zlib
ZLib Support  enabled 
Compiled Version  1.2.3 
Linked Version  1.2.3 

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name


Environment
Variable Value
ALLUSERSPROFILE  C:\Documents and Settings\All Users 
CommonProgramFiles  C:\Program Files\Common Files 
COMPUTERNAME  WEB1 
ComSpec  C:\WINNT\system32\cmd.exe 
CONTENT_LENGTH  0 
GATEWAY_INTERFACE  CGI/1.1 
HTTPS  off 
HTTP_ACCEPT  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */* 
HTTP_ACCEPT_LANGUAGE  en-us 
HTTP_CONNECTION  Keep-Alive 
HTTP_HOST  www.statelawyersforum.com 
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322) 
HTTP_COOKIE  PHPSESSID=982d046f384b68ec960c30a4dea1002b; SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1128059379%3Bi%3A3%3Bi%3A0%3B%7D 
HTTP_ACCEPT_ENCODING  gzip, deflate 
INSTANCE_ID  7 
LOCAL_ADDR  192.168.1.101 
NUMBER_OF_PROCESSORS  2 
Os2LibPath  C:\WINNT\system32\os2\dll; 
OS  Windows_NT 
Path  C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP 
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH 
PROCESSOR_ARCHITECTURE  x86 
PROCESSOR_IDENTIFIER  x86 Family 15 Model 2 Stepping 7, GenuineIntel 
PROCESSOR_LEVEL  15 
PROCESSOR_REVISION  0207 
ProgramFiles  C:\Program Files 
REMOTE_ADDR  192.168.1.1 
REMOTE_HOST  192.168.1.1 
REQUEST_METHOD  GET 
SCRIPT_NAME  /phpinfo.php 
SERVER_NAME  www.statelawyersforum.com 
SERVER_PORT  80 
SERVER_PORT_SECURE  0 
SERVER_PROTOCOL  HTTP/1.1 
SERVER_SOFTWARE  Microsoft-IIS/5.0 
SystemDrive  C: 
SystemRoot  C:\WINNT 
TEMP  C:\WINNT\TEMP 
TMP  C:\WINNT\TEMP 
USERPROFILE  C:\Documents and Settings\Default User 
windir  C:\WINNT 
ORIG_PATH_TRANSLATED  C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php 
ORIG_PATH_INFO  /phpinfo.php 
ORIG_SCRIPT_NAME  /phpinfo.php 
SCRIPT_FILENAME  C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php 


PHP Variables
Variable Value
_REQUEST["PHPSESSID"] 982d046f384b68ec960c30a4dea1002b
_REQUEST["SMFCookie66"] a:4:{i:0;s:1:\"1\";i:1;s:40:\"f053c3d27981401d5181f59d3f0812bf8b44b0a9\";i:2;i:1128059379;i:3;i:0;}
_COOKIE["PHPSESSID"] 982d046f384b68ec960c30a4dea1002b
_COOKIE["SMFCookie66"] a:4:{i:0;s:1:\"1\";i:1;s:40:\"f053c3d27981401d5181f59d3f0812bf8b44b0a9\";i:2;i:1128059379;i:3;i:0;}
_SERVER["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_SERVER["CommonProgramFiles"] C:\Program Files\Common Files
_SERVER["COMPUTERNAME"] WEB1
_SERVER["ComSpec"] C:\WINNT\system32\cmd.exe
_SERVER["CONTENT_LENGTH"] 0
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["HTTPS"] off
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_HOST"] www.statelawyersforum.com [nofollow]
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
_SERVER["HTTP_COOKIE"] PHPSESSID=982d046f384b68ec960c30a4dea1002b; SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1128059379%3Bi%3A3%3Bi%3A0%3B%7D
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["INSTANCE_ID"] 7
_SERVER["LOCAL_ADDR"] 192.168.1.101
_SERVER["NUMBER_OF_PROCESSORS"] 2
_SERVER["Os2LibPath"] C:\WINNT\system32\os2\dll;
_SERVER["OS"] Windows_NT
_SERVER["Path"] C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["PROCESSOR_IDENTIFIER"] x86 Family 15 Model 2 Stepping 7, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] 15
_SERVER["PROCESSOR_REVISION"] 0207
_SERVER["ProgramFiles"] C:\Program Files
_SERVER["REMOTE_ADDR"] 192.168.1.1
_SERVER["REMOTE_HOST"] 192.168.1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["SCRIPT_NAME"] /phpinfo.php
_SERVER["SERVER_NAME"] www.statelawyersforum.com [nofollow]
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_PORT_SECURE"] 0
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["SERVER_SOFTWARE"] Microsoft-IIS/5.0
_SERVER["SystemDrive"] C:
_SERVER["SystemRoot"] C:\WINNT
_SERVER["TEMP"] C:\WINNT\TEMP
_SERVER["TMP"] C:\WINNT\TEMP
_SERVER["USERPROFILE"] C:\Documents and Settings\Default User
_SERVER["windir"] C:\WINNT
_SERVER["ORIG_PATH_TRANSLATED"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_SERVER["ORIG_PATH_INFO"] /phpinfo.php
_SERVER["ORIG_SCRIPT_NAME"] /phpinfo.php
_SERVER["SCRIPT_FILENAME"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["argv"] Array
(
)

_SERVER["argc"] 0
_ENV["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_ENV["CommonProgramFiles"] C:\Program Files\Common Files
_ENV["COMPUTERNAME"] WEB1
_ENV["ComSpec"] C:\WINNT\system32\cmd.exe
_ENV["CONTENT_LENGTH"] 0
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["HTTPS"] off
_ENV["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
_ENV["HTTP_ACCEPT_LANGUAGE"] en-us
_ENV["HTTP_CONNECTION"] Keep-Alive
_ENV["HTTP_HOST"] www.statelawyersforum.com [nofollow]
_ENV["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
_ENV["HTTP_COOKIE"] PHPSESSID=982d046f384b68ec960c30a4dea1002b; SMFCookie66=a%3A4%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A40%3A%22f053c3d27981401d5181f59d3f0812bf8b44b0a9%22%3Bi%3A2%3Bi%3A1128059379%3Bi%3A3%3Bi%3A0%3B%7D
_ENV["HTTP_ACCEPT_ENCODING"] gzip, deflate
_ENV["INSTANCE_ID"] 7
_ENV["LOCAL_ADDR"] 192.168.1.101
_ENV["NUMBER_OF_PROCESSORS"] 2
_ENV["Os2LibPath"] C:\WINNT\system32\os2\dll;
_ENV["OS"] Windows_NT
_ENV["Path"] C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\PHP
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_IDENTIFIER"] x86 Family 15 Model 2 Stepping 7, GenuineIntel
_ENV["PROCESSOR_LEVEL"] 15
_ENV["PROCESSOR_REVISION"] 0207
_ENV["ProgramFiles"] C:\Program Files
_ENV["REMOTE_ADDR"] 192.168.1.1
_ENV["REMOTE_HOST"] 192.168.1.1
_ENV["REQUEST_METHOD"] GET
_ENV["SCRIPT_NAME"] /phpinfo.php
_ENV["SERVER_NAME"] www.statelawyersforum.com [nofollow]
_ENV["SERVER_PORT"] 80
_ENV["SERVER_PORT_SECURE"] 0
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["SERVER_SOFTWARE"] Microsoft-IIS/5.0
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\WINNT
_ENV["TEMP"] C:\WINNT\TEMP
_ENV["TMP"] C:\WINNT\TEMP
_ENV["USERPROFILE"] C:\Documents and Settings\Default User
_ENV["windir"] C:\WINNT
_ENV["ORIG_PATH_TRANSLATED"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php
_ENV["ORIG_PATH_INFO"] /phpinfo.php
_ENV["ORIG_SCRIPT_NAME"] /phpinfo.php
_ENV["SCRIPT_FILENAME"] C:\Inetpub\wwwroot\StateLawyer\forum\phpinfo.php


Thanks for any additional help.

xenovanis

#7
September 29, 2005, 03:22:30 PM
I'm not sure what to tell you about this. I'm thinking it may be something in your hosts PHP or MySQL settings, unfortunately I don't have enough knowledge about that to tell you what you should do.

If you have some patience I'm sure someone else could tell you what's the problem.
"Insanity: doing the same thing over and over again and expecting different results."

Oldiesmann

#8
September 30, 2005, 10:07:37 AM
It looks like the messages table didn't get created properly, but upgrade.php should have fixed that... Don't know what to tell you now...
Michael Eshom
Christian Metal Fans
Print
Go Up Pages1
User actions
Advertisement: