Name: Anders
Email: Grey_43@spray.se
Can you help me to install phpopenchat 3.0.2?
When I open localhost it says like this:
Sorry, an error occurred.
at c:\wamp\www\phpopenchat-3.0.2\include\adodb\drivers\adodb-mysql.inc.php:22
[2048] var: Deprecated. Please use the public/private/protected modifiers
Could not connect to database! Please check your database setup in config.inc.php by using the POC Installer!
PHP 5.0.4 (WINNT)
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; sv-SE; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
Webserver: Apache/1.3.33 (Win32) PHP/5.0.4
URI: http://localhost/phpopenchat-3.0.2/
2. After that I press POC installer
3.The only thing that dosen´t work is :checking write permissions for: TMPDIR
c:\wamp\www\phpopenchat-3.0.2\tmp error
4.Then I press next....
and take DATABASE_TABLESPACE Phpadmin....and press submit..
5.It says: checking database access at: localhost okay
DATABASE_HOST: localhost
DATABASE_USER: root
DATABASE_PASSWORD:
DATABASE_TABLE_PREFIX:
DATABASE_TABLESPACE: phpmyadmin
and I press next...
6. Now come the big problem (I think)
It says:
DROP TABLE IF EXISTS user_account;
CREATE TABLE user_account ( USER varchar(255) NOT NULL, PASSWORD varchar(255), PASSWORD_NEW varchar(255), CONFIRM_CODE char(32), DISABLED int NOT NULL DEFAULT '0', KICKED int NOT NULL DEFAULT '0', PRIMARY KEY (USER) ) TYPE=MyISAM;
INSERT INTO user_account (USER,PASSWORD,PASSWORD_NEW,DISABLED) VALUES ('mirko','giese','30ebe4d47a2a1661f9d04f84d80466c1',0);
INSERT INTO user_account (USER,PASSWORD,PASSWORD_NEW,DISABLED) VALUES ('frerk','meyer','b6273c0ba3ae37a4d3d1c6b084797f2e',0);
INSERT INTO user_account (USER,PASSWORD,PASSWORD_NEW,DISABLED) VALUES ('michael','oertel','fe0d21a59c0f5ba4e4860d83641c84e8',0);
INSERT INTO user_account (USER,PASSWORD,PASSWORD_NEW,DISABLED) VALUES ('Horseman','pferde','c101da59ac915620dffad079af886fef',0);
INSERT INTO user_account (USER,PASSWORD,DISABLED) VALUES ('operator','',0);
DROP TABLE IF EXISTS user_groups;
CREATE TABLE user_groups ( NAME varchar(255) NOT NULL, MEMBER text, PRIMARY KEY (NAME) ) TYPE=MyISAM;
INSERT INTO user_groups VALUES ('chatter',NULL);
INSERT INTO user_groups VALUES ('operator','a:2:{i:0;s:8:"operator";i:1;s:5:"Admin";}');
INSERT INTO user_groups VALUES ('moderator',NULL);
INSERT INTO user_groups VALUES ('vip',NULL);
DROP TABLE IF EXISTS user_data;
CREATE TABLE user_data ( NICK char(32) NOT NULL, USER char(255) NOT NULL, NAME char(255) NOT NULL, THEME char(25) NOT NULL DEFAULT '', BIRTHDAY date NOT NULL, GENDER char(1) NOT NULL DEFAULT '', EMAIL char(255), PRIVATE_INVITED char(32) NOT NULL DEFAULT '', HIDE_EMAIL char(1) NOT NULL DEFAULT '1', PICTURE_URL varchar(255), HOMEPAGE_URL varchar(255), INTERESTS text, MOTTO text, ICQ_NUMBER int NOT NULL DEFAULT '0', AIM_NICKNAME char(30) NOT NULL DEFAULT '', YIM_NICKNAME char(30) NOT NULL DEFAULT '', COLOR char(6) DEFAULT '000000', ONLINE char(1), LAST_CHANNEL char(32), ADVICE char(5) default 'quiet', SCROLLSPEED int, FRIENDS text, GRADE char(20) NOT NULL DEFAULT 'GRADE_ROOKIE', REGTIME datetime, LAST_ACTIVE_TIME datetime, ONLINE_TIME int NOT NULL DEFAULT '0', LINES_PER_DAY double, LOGINS_PER_DAY double, DAYS_REGISTERED integer, LAST_HOST char(50), LAST_IP char(15), LAST_USER_AGENT char(100), LAST_SESSIONID char(35), LAST_REFERER char(100), MISC text, TMP_INSTANCE text NOT NULL DEFAULT '', PRIMARY KEY (NICK), KEY (USER) ) TYPE=MyISAM;
INSERT INTO user_data (NICK,USER,NAME,BIRTHDAY,EMAIL,COLOR,REGTIME) VALUES ('operator','operator','The Operator','1969-03-24','me@here.net','003300','1999-12-31 23:59:59');
INSERT INTO user_data (NICK,USER,NAME,BIRTHDAY,EMAIL,COLOR,REGTIME) VALUES ('superman','mirko','Mirko Giese','1971-02-29','mirko@giese.de','66AACC','2000-12-31 23:59:59');
INSERT INTO user_data (NICK,USER,NAME,BIRTHDAY,EMAIL,COLOR,REGTIME) VALUES ('tux','frerk','Frerk Meyer','1967-06-24','frerk@meyer.de','AACC66','1998-12-31 23:59:59');
INSERT INTO user_data (NICK,USER,NAME,BIRTHDAY,EMAIL,COLOR,REGTIME) VALUES ('micha','michael','Michael Oertel','1969-03-24','michael@oertel.de','CCAA66','1999-12-31 23:59:59');
INSERT INTO user_data (NICK,USER,NAME,BIRTHDAY,EMAIL,COLOR,REGTIME,ICQ_NUMBER) VALUES ('Horseman','Horseman','Hartmut Götze','1963-01-01','info@h-h-c.de','CCAACC','1999-12-31 23:59:59',44729151);
DROP TABLE IF EXISTS user_notes;
CREATE TABLE user_notes ( NICKNAME varchar(32) NOT NULL, ABOUT varchar(32) NOT NULL, NOTE text, PRIMARY KEY (NICKNAME,ABOUT), KEY (NICKNAME,ABOUT) ) TYPE=MyISAM;
DROP TABLE IF EXISTS channels;
CREATE TABLE channels ( NAME char(32) NOT NULL, PASSWORD char(12), MESSAGE char(255), MAX_LINE_NUMBER int NOT NULL, CUR_LINE_NUMBER int NOT NULL, START datetime, STOP datetime, TYPE int NOT NULL DEFAULT '0', INVITED text, ORDER_IDX int, PRIMARY KEY (NAME), KEY (NAME) ) TYPE=MyISAM;
INSERT INTO channels(NAME,MAX_LINE_NUMBER,CUR_LINE_NUMBER,TYPE,ORDER_IDX) VALUES ('default',50,0,0,0);
INSERT INTO channels(NAME,MAX_LINE_NUMBER,CUR_LINE_NUMBER,TYPE,ORDER_IDX) VALUES ('moderation',50,0,1,1);
DROP TABLE IF EXISTS line_buffer;
CREATE TABLE line_buffer ( NAME char(32) NOT NULL, LINE_0 text, LINE_1 text, LINE_2 text, LINE_3 text, LINE_4 text, LINE_5 text, LINE_6 text, LINE_7 text, LINE_8 text, LINE_9 text, LINE_10 text, LINE_11 text, LINE_12 text, LINE_13 text, LINE_14 text, LINE_15 text, LINE_16 text, LINE_17 text, LINE_18 text, LINE_19 text, LINE_20 text, LINE_21 text, LINE_22 text, LINE_23 text, LINE_24 text, LINE_25 text, LINE_26 text, LINE_27 text, LINE_28 text, LINE_29 text, LINE_30 text, LINE_31 text, LINE_32 text, LINE_33 text, LINE_34 text, LINE_35 text, LINE_36 text, LINE_37 text, LINE_38 text, LINE_39 text, LINE_40 text, LINE_41 text, LINE_42 text, LINE_43 text, LINE_44 text, LINE_45 text, LINE_46 text, LINE_47 text, LINE_48 text, LINE_49 text, PRIMARY KEY (NAME), KEY (NAME) ) TYPE=MyISAM;
INSERT INTO line_buffer (NAME) VALUES ('default');
INSERT INTO line_buffer (NAME) VALUES ('moderation');
DROP TABLE IF EXISTS mails;
CREATE TABLE mails ( SENDER char(25) NOT NULL, TIME char(19) NOT NULL, RECIPIENT char(25) NOT NULL, MAIL text, TRASHED_BY_SENDER int NOT NULL DEFAULT '0', TRASHED_BY_RECIPIENT int NOT NULL DEFAULT '0', PRIMARY KEY (SENDER,RECIPIENT,TIME), KEY (SENDER), KEY (RECIPIENT) ) TYPE=MyISAM;
DROP TABLE IF EXISTS hits;
CREATE TABLE hits ( USER char(25) NOT NULL, USERPAGE int NOT NULL DEFAULT '0', LINE int NOT NULL DEFAULT '0', BANN int NOT NULL DEFAULT '0', LOGIN int NOT NULL DEFAULT '0', PRIMARY KEY (USER), KEY (USER) ) TYPE=MyISAM;
DROP TABLE IF EXISTS banned_users;
CREATE TABLE banned_users ( USER varchar(25) NOT NULL, TIME_BANNED datetime NOT NULL DEFAULT '2000-12-31 23:59:59', BANNED_FOR char(32) NOT NULL DEFAULT '', PRIMARY KEY (USER,BANNED_FOR), KEY (USER), KEY (BANNED_FOR) ) TYPE=MyISAM;
DROP TABLE IF EXISTS cache;
CREATE TABLE cache ( ID char(255) NOT NULL, MAX_AGE datetime, CONTENT text, PRIMARY KEY (ID), KEY (ID) ) TYPE=MyISAM;
DROP TABLE IF EXISTS guestbook;
CREATE TABLE guestbook ( USER varchar(25) NOT NULL, SENDER varchar(25) NOT NULL, TIME int NOT NULL, POST text, PRIMARY KEY (SENDER,TIME), KEY (USER,TIME) ) TYPE=MyISAM;
and I press initialize database...
7. I come to:
PHPOpenChat database schema import. okay
I press next....
8.Then it says like this:
Congratulations! The installation of PHPOpenChat is accomplished. Now login to your new high performance chat server.
And then I press: Now login to your new high performance chat server.
After that I come to the startpage again....so can you help me to get it working?
Please....
Logged In: YES
user_id=1350999
Found the real issue. Having a custom error handler even
gets E_STRICT errors, which is what is happening here. By
modifying the display_error function in class.Chat.inc, we
can avoid the problem:
-----snip-----
function display_error( $errno, $errstr, $errfile,
$errline, $vars = null, $poc_error_msg = null )
{
// We don't know how to properly handle E_STRICT
errors.
// Returning false causes the default error handling to
take over.
if ($errno == E_STRICT) return false;
-----snip-----