PeetaGTS
03-06-2003, 06:55 AM
hey guys.. step 1 of installing the hack for a shoutbox... i was not able to create a query in my dtatabase.. when i entered in:
CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;
and submitted it.. it came up and said:
Error
SQL-query : [Edit]
CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default \'0\',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default \'0\',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\'0\',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default \' at line 3
Back
anyone know whats wrong?
CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;
and submitted it.. it came up and said:
Error
SQL-query : [Edit]
CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default \'0\',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default \'0\',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\'0\',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default \' at line 3
Back
anyone know whats wrong?