i'm allso getting this error
Invalid SQL: CREATE TABLE `teams` (
`teamid` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`posts` tinyint(10) NOT NULL default '0',
`reputation` tinyint(10) NOT NULL default '0',
`avatarurl` varchar(100) NOT NULL default 'images/teamavatars/no-avatar.gif',
`words` text NOT NULL,
`adminmsg` text NOT NULL,
`ircserver` varchar(50) NOT NULL default '',
`ircport` int(4) NOT NULL default '6667',
`chan` varchar(50) NOT NULL default '',
`chanpass` varchar(50) NOT NULL default '',
`notes` text NOT NULL,
`email` varchar(100) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`teamid`)
) TYPE=MyISAM;
mysql error: You have an error in your SQL syntax near ';
' at line 17
does anyone know a way to fix this ?
EDIT: well i got it installed by using phpmyadmin
but i get errors when i want to join a team and i can only make teams via admin cp (if thats normal or not, i'm not realy sure)
|