I am getting this error when trying to run the db query:
Error
SQL-query : [Edit]
CREATE TABLE `vbs_stories` (
`storyid` int(11) NOT NULL auto_increment,
`genreid` int(11) NOT NULL default \\\'0\\\',
`title` varchar(100) NOT NULL default \\\'\\\',
`name` varchar(100) NOT NULL default \\\'\\\',
`info` text NOT NULL,
`display` tinyint(4) NOT NULL default \\\'0\\\',
PRIMARY KEY (`storyid`)
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\\\'0\\\',
`title` varchar(100) NOT NULL default \\\'\\\',
`name` varchar(' at line 3
CREATE TABLE `vbs_chapters` (
`id` bigint(20) NOT NULL auto_increment,
`chapterid` int(11) NOT NULL default \'0\',
`storyid` int(11) NOT NULL default \'0\',
`title` varchar(100) NOT NULL default \'\',
`body` text NOT NULL,
`path1` varchar(100) NOT NULL default \'\',
`path2` varchar(100) NOT NULL default \'\',
`userid` int(11) NOT NULL default \'0\',
`dateline` int(10) NOT NULL default \'0\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\'0\',
`storyid` int(11) NOT NULL default \'0\',
`title` varchar(100) NOT ' at line 3
CREATE TABLE `vbs_genres` (
`genreid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default \'\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`genreid`)
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\'\',
`display` tinyint(4) NOT NULL default \'0\',
PRIMARY KEY (`genreid`' at line 3
Im running vb 2.2.9 anyone help here??
|