PDA

View Full Version : ShoutBox Hack pproblem


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?

Dpcows
03-06-2003, 08:48 AM
i tried the query on my mysql db and had no problems