1
paulizaz
XoopsChat - unable to install
  • 2011/8/7 0:58

  • paulizaz

  • Not too shy to talk

  • Posts: 120

  • Since: 2007/1/18


Unable to install xoopschat. Error(s):


Installing Xoops Chat


#This SQL Dump was designed and coded by PieroLas.#http://www.cmq.it#redesign for xoops 2 by frankblackhttp://www.htmldeluxe.deCREATE TABLE myxoopschat_messages ( mid int(11) unsigned NOT NULL auto_increment, chatroom varchar(50) NOT NULL, message text NOT NULL, poster varchar(25) NOT NULL, post_time int(10) NOT NULL, poster_ip varchar(15) NOT NULL, PRIMARY KEY (mid)) TYPE=MyISAM;CREATE TABLE myxoopschat_pmsgs ( mid int(11) unsigned NOT NULL auto_increment, msg_from varchar(25) NOT NULL, msg_to varchar(25) NOT NULL, msg_text text NOT NULL, post_time int(10) NOT NULL, poster_ip varchar(15) NOT NULL, PRIMARY KEY (mid)) TYPE=MyISAM;CREATE TABLE myxoopschat_requests ( rid int(11) unsigned NOT NULL auto_increment, req_from varchar(25) NOT NULL, req_to varchar(25) NOT NULL, PRIMARY KEY (rid)) TYPE=MyISAM;CREATE TABLE myxoopschat_rooms ( rid int(10) unsigned NOT NULL auto_increment, room_name varchar(30) NOT NULL, room_type tinyint(1) NOT NULL default '1', PRIMARY KEY (rid)) TYPE=MyISAM;CREATE TABLE myxoopschat_whosonline ( wid int(11) unsigned NOT NULL auto_increment, uid int(5) NOT NULL, nick varchar(25) NOT NULL, user_name varchar(25) NOT NULL, user_mail varchar(60) NOT NULL, user_icq varchar(15) NOT NULL, user_aim varchar(18) NOT NULL, user_yim varchar(25) NOT NULL, user_msnm varchar(25) NOT NULL, user_ip varchar(15) NOT NULL, PRIMARY KEY (wid)) TYPE=MyISAM;CREATE TABLE myxoopschat_banned ( bid int(11) unsigned NOT NULL auto_increment, user varchar(25) NOT NULL, from_time int(10) NOT NULL, to_time int(10) NOT NULL, PRIMARY KEY (bid)) TYPE=MyISAM;CREATE TABLE myxoopschat_visibility ( visid smallint(6) NOT NULL auto_increment, rid smallint(6) NOT NULL default 0, groupid smallint(6) NOT NULL default 0, PRIMARY KEY (visid)) TYPE=MyISAM AUTO_INCREMENT=20 ;INSERT INTO myxoopschat_rooms VALUES ('','Standard',1) is not a valid SQL!

Can anyone help?

Login

Who's Online

151 user(s) are online (110 user(s) are browsing Support Forums)


Members: 0


Guests: 151


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits