5
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 frankblack
http://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?