I just downloaded the phpMyChat1.4.5. At first I installed it successfully on a debian linux machine with php4 and mysql. All worked fine, so I uploaded the whole source to my webspace by kontent.de (URL: php.jaeger-enterprises.de/chat).
Done this, I tried to setup the chat using setup.php3. But after step one the server reports following errors/warnings:
"
Warning: Variable passed to reset() is not an array or object in /raid/domains/de/j/jaeger-enterprises/htdocs/php/chat/setup.php3 on line 96
Warning: Variable passed to current() is not an array or object in /raid/domains/de/j/jaeger-enterprises/htdocs/php/chat/setup.php3 on line 96
Step 1 completed: tables have been created/updated.
"
After clicking "next" for the second time this appears:
"
Step 2 completed: settings for fine tunning have been registered.
Database error: Invalid SQL: SELECT username,password,firstname,lastname,country,website,email,showemail,gender FROM c_reg_users WHERE perms='admin' LIMIT 1
MySQL error: 1146 (Table 'de61959.c_reg_users' doesn't exist)
Session halted.
"
Fact is, that on my LOCAL system (I'm behind a firewall and can't directly connect to an external mysql-server) all works fine.
Now it's the question if this is a known bug or an bug which only appears when using the chat on "kontent.de"-Servers.
Please help me quick.
Here the phpinfo();-output from the server the error appeared:
"
[PHP Logo]
PHP Version 4.0.6
System KONTENT OS V1.0.1 Server Edition @ Kunden.KONTENT.De
Build Date Sep 5 2001
Configure Command './configure' '--prefix=/usr/local/httpd' '--sysconfdir=/usr/local/httpd/conf' '--with-apxs=/usr/local/httpd/bin/apxs' '--with-config-file-path=/usr/local/httpd/conf' '--with-exec-dir=/usr/local/httpd/bin' '--with-jpeg-dir' '--with-tiff-dir' '--with-gd' '--with-png-dir=/usr' '--with-zlib-dir=/usr' '--with-mysql=/usr/local' '--with-regex=php' '--enable-memory-limit' '--disable-gd-imgstrttf' '--without-ttf' '--enable-versioning' '--enable-safe-mode'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/httpd/conf/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
[Zend logo] This program makes use of the Zend scripting language engine:
Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies
PHP 4.0 Credits
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
On On
allow_url_fopen
1 1
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
link, linkinfo, readlink, lstat, symlink link, linkinfo, readlink, lstat, symlink
display_errors
On On
display_startup_errors
Off Off
doc_root
. .
enable_dl
Off Off
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
#FF8000 #FF8000
highlight.default
#0000BB #0000BB
highlight.html
#000000 #000000
highlight.keyword
#007700 #007700
highlight.string
#DD0000 #DD0000
html_errors
On On
ignore_user_abort
Off Off
implicit_flush
Off Off
include_path
.:/usr/local/httpd/lib/php .:/usr/local/httpd/lib/php
log_errors
Off Off
magic_quotes_gpc
On On
magic_quotes_runtime
Off Off
magic_quotes_sybase
Off Off
max_execution_time
5 5
memory_limit
4194304 8M
open_basedir
. .
output_buffering
Off Off
output_handler
no value no value
post_max_size
4M 4M
precision
14 14
register_argc_argv
On On
register_globals
On On
safe_mode
On On
safe_mode_exec_dir
. .
sendmail_from
kunden@kontent.de kunden@kontent.de
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
1048576 2M
upload_tmp_dir
. .
user_dir
no value no value
variables_order
EGPCS EGPCS
y2k_compliance
Off Off
xml
XML Support active
standard
Regex Library Bundled 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
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
KONTENTSID KONTENTSID
session.referer_check
no value no value
session.save_handler
files files
session.save_path
/tmp/httpd /tmp/httpd
session.serialize_handler
php php
session.use_cookies
On On
posix
Revision $Revision: 1.28.2.1 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient -L/usr -z
Directive Local Value Master Value
mysql.allow_persistent
Off Off
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
gd
GD Support enabled
GD Version 1.6.2 or higher
PNG Support enabled
WBMP Support enabled
zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.3
Linked Version 1.1.3
apache
APACHE_INCLUDE
APACHE_TARGET
Apache Version Apache/1.3.20
Apache Release 10320100
Apache API Version 19990320
Hostname:Port kunden.kontent.de:80
User/Group kunden(10000)/10000
Max Requests Per Child: 150<br>Keep Alive: on<br>Max Per Connection: 50
Timeouts Connection: 30<br>Keep-Alive: 15
Server Root /usr/local/httpd
Loaded Modules mod_php4, mod_php3, mod_setenvif, mod_so, mod_expires, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, mod_log_config, mod_env, mod_vhost_alias, http_core
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 license@php.net.
"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello!
I just downloaded the phpMyChat1.4.5. At first I installed it successfully on a debian linux machine with php4 and mysql. All worked fine, so I uploaded the whole source to my webspace by kontent.de (URL: php.jaeger-enterprises.de/chat).
Done this, I tried to setup the chat using setup.php3. But after step one the server reports following errors/warnings:
"
Warning: Variable passed to reset() is not an array or object in /raid/domains/de/j/jaeger-enterprises/htdocs/php/chat/setup.php3 on line 96
Warning: Variable passed to current() is not an array or object in /raid/domains/de/j/jaeger-enterprises/htdocs/php/chat/setup.php3 on line 96
Step 1 completed: tables have been created/updated.
"
After clicking "next" for the second time this appears:
"
Step 2 completed: settings for fine tunning have been registered.
Database error: Invalid SQL: SELECT username,password,firstname,lastname,country,website,email,showemail,gender FROM c_reg_users WHERE perms='admin' LIMIT 1
MySQL error: 1146 (Table 'de61959.c_reg_users' doesn't exist)
Session halted.
"
Fact is, that on my LOCAL system (I'm behind a firewall and can't directly connect to an external mysql-server) all works fine.
Now it's the question if this is a known bug or an bug which only appears when using the chat on "kontent.de"-Servers.
Please help me quick.
Here the phpinfo();-output from the server the error appeared:
"
[PHP Logo]
PHP Version 4.0.6
System KONTENT OS V1.0.1 Server Edition @ Kunden.KONTENT.De
Build Date Sep 5 2001
Configure Command './configure' '--prefix=/usr/local/httpd' '--sysconfdir=/usr/local/httpd/conf' '--with-apxs=/usr/local/httpd/bin/apxs' '--with-config-file-path=/usr/local/httpd/conf' '--with-exec-dir=/usr/local/httpd/bin' '--with-jpeg-dir' '--with-tiff-dir' '--with-gd' '--with-png-dir=/usr' '--with-zlib-dir=/usr' '--with-mysql=/usr/local' '--with-regex=php' '--enable-memory-limit' '--disable-gd-imgstrttf' '--without-ttf' '--enable-versioning' '--enable-safe-mode'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/httpd/conf/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
[Zend logo] This program makes use of the Zend scripting language engine:
Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies
PHP 4.0 Credits
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
On On
allow_url_fopen
1 1
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
link, linkinfo, readlink, lstat, symlink link, linkinfo, readlink, lstat, symlink
display_errors
On On
display_startup_errors
Off Off
doc_root
. .
enable_dl
Off Off
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
#FF8000 #FF8000
highlight.default
#0000BB #0000BB
highlight.html
#000000 #000000
highlight.keyword
#007700 #007700
highlight.string
#DD0000 #DD0000
html_errors
On On
ignore_user_abort
Off Off
implicit_flush
Off Off
include_path
.:/usr/local/httpd/lib/php .:/usr/local/httpd/lib/php
log_errors
Off Off
magic_quotes_gpc
On On
magic_quotes_runtime
Off Off
magic_quotes_sybase
Off Off
max_execution_time
5 5
memory_limit
4194304 8M
open_basedir
. .
output_buffering
Off Off
output_handler
no value no value
post_max_size
4M 4M
precision
14 14
register_argc_argv
On On
register_globals
On On
safe_mode
On On
safe_mode_exec_dir
. .
sendmail_from
kunden@kontent.de kunden@kontent.de
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
1048576 2M
upload_tmp_dir
. .
user_dir
no value no value
variables_order
EGPCS EGPCS
y2k_compliance
Off Off
xml
XML Support active
standard
Regex Library Bundled 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
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
KONTENTSID KONTENTSID
session.referer_check
no value no value
session.save_handler
files files
session.save_path
/tmp/httpd /tmp/httpd
session.serialize_handler
php php
session.use_cookies
On On
posix
Revision $Revision: 1.28.2.1 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient -L/usr -z
Directive Local Value Master Value
mysql.allow_persistent
Off Off
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
gd
GD Support enabled
GD Version 1.6.2 or higher
PNG Support enabled
WBMP Support enabled
zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.3
Linked Version 1.1.3
apache
APACHE_INCLUDE
APACHE_TARGET
Apache Version Apache/1.3.20
Apache Release 10320100
Apache API Version 19990320
Hostname:Port kunden.kontent.de:80
User/Group kunden(10000)/10000
Max Requests Per Child: 150<br>Keep Alive: on<br>Max Per Connection: 50
Timeouts Connection: 30<br>Keep-Alive: 15
Server Root /usr/local/httpd
Loaded Modules mod_php4, mod_php3, mod_setenvif, mod_so, mod_expires, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, mod_log_config, mod_env, mod_vhost_alias, http_core
Apache Environment
Variable Value
DOCUMENT_ROOT /usr/local/httpd/htdocs
HTTP_ACCEPT text/xml, application/xml, application/xhtml+xml, text/html;q=0.9, image/png, image/jpeg, image/gif;q=0.2, text/plain;q=0.8, text/css, */*;q=0.1
HTTP_ACCEPT_CHARSET ISO-8859-1, utf-8;q=0.66, *;q=0.66
HTTP_ACCEPT_ENCODING gzip, deflate, compress;q=0.9
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION keep-alive
HTTP_FORWARDED by http://pythia.Materna.DE:8080 (Netscape-Proxy/3.52)
HTTP_HOST php.jaeger-enterprises.de
HTTP_KEEP_ALIVE 300
HTTP_REFERER http://www.kontent.de/kunden/sitemanager.phtml
HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.6) Gecko/20011120
PATH /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
REMOTE_ADDR 193.96.115.130
REMOTE_HOST cerberus.materna.de
REMOTE_PORT 50991
SCRIPT_FILENAME /raid/domains/de/j/jaeger-enterprises/htdocs/php/info.php
SCRIPT_URI http://php.jaeger-enterprises.de/info.php
SCRIPT_URL /info.php
SERVER_ADDR 194.231.46.234
SERVER_ADMIN tech@kontent.de
SERVER_NAME php.jaeger-enterprises.de
SERVER_PORT 80
SERVER_SIGNATURE <ADDRESS>Apache/1.3.20 Server at php.jaeger-enterprises.de Port 80</ADDRESS>
SERVER_SOFTWARE Apache
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.0
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /info.php
SCRIPT_NAME /info.php
HTTP Headers Information
HTTP Request Headers
HTTP Request GET /info.php HTTP/1.0
Accept text/xml, application/xml, application/xhtml+xml, text/html;q=0.9, image/png, image/jpeg, image/gif;q=0.2, text/plain;q=0.8, text/css, */*;q=0.1
Accept-Charset ISO-8859-1, utf-8;q=0.66, *;q=0.66
Accept-Encoding gzip, deflate, compress;q=0.9
Accept-Language en-us
Connection keep-alive
Forwarded by http://pythia.Materna.DE:8080 (Netscape-Proxy/3.52)
Host php.jaeger-enterprises.de
Keep-Alive 300
Referer http://www.kontent.de/kunden/sitemanager.phtml
User-Agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.6) Gecko/20011120
HTTP Response Headers
X-Powered-By PHP/4.0.6
Connection close
Content-Type text/html
Additional Modules
Environment
Variable Value
PWD /
HOSTNAME www4.kontent.de
CONSOLE /dev/console
PREVLEVEL N
AUTOBOOT YES
MACHTYPE i386-slackware-linux-gnu
SHLVL 2
BOOT_IMAGE linux
SHELL /bin/bash
HOSTTYPE i386
OSTYPE linux-gnu
HOME /
TERM linux
PATH /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
RUNLEVEL 3
INIT_VERSION sysvinit-2.78
_ /usr/local/httpd/bin/httpd
PHP Variables
Variable Value
PHP_SELF /info.php
HTTP_SERVER_VARS["DOCUMENT_ROOT"] /usr/local/httpd/htdocs
HTTP_SERVER_VARS["HTTP_ACCEPT"] text/xml, application/xml, application/xhtml+xml, text/html;q=0.9, image/png, image/jpeg, image/gif;q=0.2, text/plain;q=0.8, text/css, */*;q=0.1
HTTP_SERVER_VARS["HTTP_ACCEPT_CHARSET"] ISO-8859-1, utf-8;q=0.66, *;q=0.66
HTTP_SERVER_VARS["HTTP_ACCEPT_ENCODING"] gzip, deflate, compress;q=0.9
HTTP_SERVER_VARS["HTTP_ACCEPT_LANGUAGE"] en-us
HTTP_SERVER_VARS["HTTP_CONNECTION"] keep-alive
HTTP_SERVER_VARS["HTTP_FORWARDED"] by http://pythia.Materna.DE:8080 (Netscape-Proxy/3.52)
HTTP_SERVER_VARS["HTTP_HOST"] php.jaeger-enterprises.de
HTTP_SERVER_VARS["HTTP_KEEP_ALIVE"] 300
HTTP_SERVER_VARS["HTTP_REFERER"] http://www.kontent.de/kunden/sitemanager.phtml
HTTP_SERVER_VARS["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.6) Gecko/20011120
HTTP_SERVER_VARS["PATH"] /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
HTTP_SERVER_VARS["REMOTE_ADDR"] 193.96.115.130
HTTP_SERVER_VARS["REMOTE_HOST"] cerberus.materna.de
HTTP_SERVER_VARS["REMOTE_PORT"] 50991
HTTP_SERVER_VARS["SCRIPT_FILENAME"] /raid/domains/de/j/jaeger-enterprises/htdocs/php/info.php
HTTP_SERVER_VARS["SCRIPT_URI"] http://php.jaeger-enterprises.de/info.php
HTTP_SERVER_VARS["SCRIPT_URL"] /info.php
HTTP_SERVER_VARS["SERVER_ADDR"] 194.231.46.234
HTTP_SERVER_VARS["SERVER_ADMIN"] tech@kontent.de
HTTP_SERVER_VARS["SERVER_NAME"] php.jaeger-enterprises.de
HTTP_SERVER_VARS["SERVER_PORT"] 80
HTTP_SERVER_VARS["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.20 Server at php.jaeger-enterprises.de Port 80</ADDRESS>
HTTP_SERVER_VARS["SERVER_SOFTWARE"] Apache
HTTP_SERVER_VARS["GATEWAY_INTERFACE"] CGI/1.1
HTTP_SERVER_VARS["SERVER_PROTOCOL"] HTTP/1.0
HTTP_SERVER_VARS["REQUEST_METHOD"] GET
HTTP_SERVER_VARS["QUERY_STRING"]
HTTP_SERVER_VARS["REQUEST_URI"] /info.php
HTTP_SERVER_VARS["SCRIPT_NAME"] /info.php
HTTP_SERVER_VARS["PATH_TRANSLATED"] /raid/domains/de/j/jaeger-enterprises/htdocs/php/info.php
HTTP_SERVER_VARS["PHP_SELF"] /info.php
HTTP_SERVER_VARS["argv"]
Array
(
)
HTTP_SERVER_VARS["argc"] 0
HTTP_ENV_VARS["PWD"] /
HTTP_ENV_VARS["HOSTNAME"] www4.kontent.de
HTTP_ENV_VARS["CONSOLE"] /dev/console
HTTP_ENV_VARS["PREVLEVEL"] N
HTTP_ENV_VARS["AUTOBOOT"] YES
HTTP_ENV_VARS["MACHTYPE"] i386-slackware-linux-gnu
HTTP_ENV_VARS["SHLVL"] 2
HTTP_ENV_VARS["BOOT_IMAGE"] linux
HTTP_ENV_VARS["SHELL"] /bin/bash
HTTP_ENV_VARS["HOSTTYPE"] i386
HTTP_ENV_VARS["OSTYPE"] linux-gnu
HTTP_ENV_VARS["HOME"] /
HTTP_ENV_VARS["TERM"] linux
HTTP_ENV_VARS["PATH"] /usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
HTTP_ENV_VARS["RUNLEVEL"] 3
HTTP_ENV_VARS["INIT_VERSION"] sysvinit-2.78
HTTP_ENV_VARS["_"] /usr/local/httpd/bin/httpd
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 license@php.net.
"