hi guys,
i trying to dump the sql file for module but i get an error like this:
Code:
SQL-fråga:
INSERT INTO `AdminMenu` ( `ID` , `Title` , `Url` , `Desc` , `Check` , `Order` , `Categ` , `Icon` )
VALUES ( 84, 'Moderator Video Zone', '../youtubes/moderators/videos/videos.php', 'Moderator Panel', '', 4, 9, 'video.jpg' ) , ( 85, 'Youtubes Video Zone', '../youtubes/admin/videos/videos.php', 'Manage Youtubes Video Zone', '', 4, 4, 'video.jpg' ) ,
CREATE TABLE `comments` (
`id` int( 30 ) NOT NULL AUTO_INCREMENT ,
`vidid` int( 20 ) NOT NULL default '0',
`uid` int( 10 ) NOT NULL default '0',
`unick` varchar( 30 ) NOT NULL default '',
`date` varchar( 40 ) NOT NULL default '',
`text` text NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;
MySQL sa:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `comments` (
`id` int(30) NOT NULL auto_increment,
`vidid` in' at line 6
any ideas why this happening?
warm regards Anders
Bookmarks