MySQL error
Im trying to execute an sql command on my doohicky. ( http://wormrage.pcplayground.com/mysql) but it keeps giving me errors. here is what i want to execute...
Quote:
DROP TABLE IF EXISTS `im_categories`;
CREATE TABLE `im_categories` (
`id` tinyint(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`type` varchar(100) NOT NULL default '',
`template` varchar(200) NOT NULL default 'default',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_comments`;
CREATE TABLE `im_comments` (
`id` int(11) NOT NULL auto_increment,
`articleid` int(11) NOT NULL default '0',
`author` varchar(20) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`comments` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_features`;
CREATE TABLE `im_features` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`link` varchar(200) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`img` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_games`;
CREATE TABLE `im_games` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`platform` varchar(200) NOT NULL default '',
`genre` varchar(100) NOT NULL default '',
`publisher` varchar(200) NOT NULL default '',
`developer` varchar(200) NOT NULL default '',
`rating` varchar(100) NOT NULL default '',
`release` varchar(30) NOT NULL default '',
`description` text NOT NULL,
`boxshot` varchar(200) NOT NULL default '',
`site` varchar(150) NOT NULL default '',
`players` int(6) NOT NULL default '0',
`multiplayer` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_helpcenter`;
CREATE TABLE `im_helpcenter` (
`id` int(11) NOT NULL auto_increment,
`module` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_modules`;
CREATE TABLE `im_modules` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`destination` varchar(255) NOT NULL default '',
`leftmenu` char(1) NOT NULL default '',
`rightmenu` char(1) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_news`;
CREATE TABLE `im_news` (
`id` tinyint(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`text` text NOT NULL,
`alltext` text NOT NULL,
`category` varchar(25) NOT NULL default '',
`game` varchar(25) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`article_cat` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_reviews`;
CREATE TABLE `im_reviews` (
`id` tinyint(11) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`game_id` varchar(20) NOT NULL default '',
`author` varchar(100) NOT NULL default '',
`review` text NOT NULL,
`category` varchar(10) NOT NULL default '',
`gameplay` int(3) NOT NULL default '0',
`graphics` int(3) NOT NULL default '0',
`sound` int(3) NOT NULL default '0',
`value` int(3) NOT NULL default '0',
`tilt` int(3) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_templates`;
CREATE TABLE `im_templates` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_templates_data`;
CREATE TABLE `im_templates_data` (
`templateid` smallint(5) NOT NULL auto_increment,
`templatesetid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext NOT NULL,
`templateset` varchar(25) NOT NULL default '',
PRIMARY KEY (`templateid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `im_users`;
CREATE TABLE `im_users` (
`primary_key` mediumint(8) unsigned NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
`PASSWORD` varchar(32) NOT NULL default '',
`userlevel` tinyint(3) default NULL,
PRIMARY KEY (`primary_key`),
KEY `user` (`user`)
) TYPE=MyISAM;
INSERT INTO `im_modules` ( `id` , `title` , `destination` , `leftmenu` , `rightmenu` ) VALUES ('', 'Applications', 'applications', '', '');
INSERT INTO `im_templates_data` VALUES ('', -1, 'Global Templates', '', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'header', '<html>\r\n<head>\r\n<title>Vortex Gaming Network</title>\r\n<link rel="Stylesheet" href="style.css" type="text/css">\r\n</head>\r\n\r\n<body bgcolor="#404040" topmargin="0" leftmargin="0" rightmargin="0">\r\n\r\n<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center">\r\n<tr><td bgcolor="#000000">\r\n\r\n<table border="0" cellspacing="1" cellpadding="3" width="100%" align="center">\r\n<tr><td colspan="3" bgcolor="#404040" valign="top">\r\n<table border="0" cellspacing="0" cellpadding="2" width="100%" align="center">\r\n<tr><td bgcolor="#404040">\r\n[img]images/logo.jpg[/img]\r\n</td><td width="100%" bgcolor="#404040">\r\n\r\n<font class="genmed">Search: <input type="text" name="search" size="20">\r\n</td></tr>\r\n</table>\r\n</td></tr>\r\n<tr><td colspan="3" align="left" bgcolor="#202020" class="gensmall">\r\n\r\nHome | \r\nForum | \r\nContact Us |\r\nCategories » \r\n {CATEGORIES}</td></tr>\r\n<tr>', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'left_menu', '<td width="150" valign="top" bgcolor="#202020">\r\n\r\n<table border="0" cellspacing="2" cellpadding="0" width="150">\r\n<tr><td align="right">VG Network</td></tr>\r\n<tr><td height="1" bgcolor="#000000"></td></tr>\r\n<tr><td class="gensmall">\r\n» Home
\r\n» Forum
\r\n</td></tr>\r\n\r\n<tr><td align="right">GameCube</td></tr>\r\n<tr><td height="1" bgcolor="#000000"></td></tr>\r\n<tr><td class="gensmall">\r\n» Games
\r\n» Guides
\r\n» News
\r\n» Previews
\r\n» Reviews
</td></tr>\r\n\r\n<tr><td align="right">Xbox</td></tr>\r\n<tr><td height="1" bgcolor="#000000"></td></tr>\r\n<tr><td class="gensmall">\r\n» Games
\r\n» Guides
\r\n» News
\r\n» Previews
\r\n» Reviews
</td></tr>\r\n\r\n<tr><td align="right">PlayStation 2</td></tr>\r\n<tr><td height="1" bgcolor="#000000"></td></tr>\r\n<tr><td class="gensmall">\r\n» Games
\r\n» Guides
\r\n» News
\r\n» Previews
\r\n» Reviews
</td></tr>\r\n\r\n</table>\r\n\r\n</td>', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'begin_content', '<td width="100%" valign="top" bgcolor="#404040">', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'end_content', '</td>', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'right_menu', '<td width="150" valign="top" bgcolor="#202020">\r\n\r\n<table border="0" cellspacing="0" cellpadding="0" width="150"><tr><td>\r\n\r\nNavigation
\r\n\r\n</td></tr>\r\n</table>\r\n\r\n</td>', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'footer', '</tr></table>\r\n\r\n</td></tr></table>\r\n\r\n<p align="center">\r\n<font class="gensmall">powered by Vortex Portal</font></p>', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'category_link', ': {TITLE} :', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'news_item', '{TITLE} <font class="gensmall">[Posted on: {DATE}]</font>
\r\n{NEWS}
', 'news');
INSERT INTO `im_templates_data` VALUES ('', -1, 'News Templates', '', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'news_article', '<font class="gen">{TITLE}</font>
\r\n<font class="gensmall">\r\n{DATE}
\r\n\r\n
{TEXT}</p>\r\n\r\n
{ARTICLE}</p>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'comments_header', '<p align="center">\r\nPost Comment\r\n</p>\r\n\r\n<table border="0" cellspacing="0" cellpadding="2" width="90%" align="center">\r\n<tr><td colspan="3"><font class="genmed">Comments:</font></td></tr>\r\n<tr><td bgcolor="#D4D4D4">Title</td><td bgcolor="#D4D4D4">Author</td><td bgcolor="#D4D4D4">Date</td></tr>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'comments_footer', '</table>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'comments_row', '<tr>\r\n<td>{TITLE}</td>\r\n<td>{AUTHOR}</td>\r\n<td>{DATE}</td>\r\n</tr>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'viewcomment', '<font class="gen">{TITLE}</font>
\r\nDate: {DATE}
\r\nAuthor: {AUTHOR}
\r\n\r\n{COMMENTS}
\r\n\r\nBack to the article', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'postcomment', '<form method="post" action="news.php">\r\n\r\nPost Comment
\r\n\r\nYour Name:
\r\n<input type="text" name="name">\r\n
\r\n\r\nYour Email:
\r\n<input type="text" name="email">\r\n
\r\n\r\nSubject:
\r\n<input type="text" name="title">\r\n
\r\n\r\nComments:
\r\n<textarea rows="5" cols="50" name="usercomments"></textarea>\r\n
\r\n<input type="hidden" name="id" value="{ID}">\r\n<input type="hidden" name="mod" value="postconfirm">\r\n<input type="submit" name="submit" value="Post Comments">\r\n</form>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'postcomment_success', 'Thank you for posting your comments! They will now appear under the comments section below the article.', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'games_footer', '</table>', 'games');
INSERT INTO `im_templates_data` VALUES ('', -1, 'Global Colors', '', 'colors');
INSERT INTO `im_templates_data` VALUES ('', 1, 'bgcolor1', '#4F4F4F', 'colors');
INSERT INTO `im_templates_data` VALUES ('', 1, 'bgcolor2', '#717171', 'colors');
INSERT INTO `im_templates_data` VALUES ('', 1, 'game_info', '\r\n<table border="0" cellspacing="2" cellpadding="0" width="100%">\r\n\r\n<tr><td colspan="2" class="genmed">{TITLE}</td></tr>\r\n<tr><td colspan="2" height="1" bgcolor="#000000"></td></tr>\r\n\r\n<tr>\r\n<td class="gensmall" width="100%" valign="top">{DESCRIPTION}</td>\r\n\r\n<td valign="top">[img]{BOXSHOT}[/img]</td>\r\n\r\n</tr>\r\n\r\n<tr><td colspan="2" class="genmed">
Game Info</td></tr>\r\n<tr><td colspan="2" height="1" bgcolor="#000000"></td></tr>\r\n\r\n<tr><td colspan="2">\r\n\r\n<table border="0" cellspacing="4" cellpadding="0">\r\n<tr><td class="gensmall">Publisher: {PUBLISHER}</td></tr>\r\n<tr><td class="gensmall">Developer: {DEVELOPER}</td></tr>\r\n<tr><td class="gensmall">Genre: {GENRE}</td></tr>\r\n<tr><td class="gensmall">Official Website: {WEBSITE}</td></tr>\r\n<tr><td class="gensmall">Release Date: {RELEASE}</td></tr>\r\n<tr><td class="gensmall">Multiplayer: {MULTIPLAYER}</td></tr>\r\n<tr><td class="gensmall"># Players: {PLAYERS}</td></tr>\r\n\r\n</table>\r\n\r\n</td>\r\n</tr>\r\n\r\n</table>', 'games');
INSERT INTO `im_templates_data` VALUES ('', -1, 'Reviews', '', 'reviews');
INSERT INTO `im_templates_data` VALUES ('', 1, 'review', '<table border="0" cellspacing="0" cellpadding="3" width="100%">\r\n<tr>\r\n<td class="genmed" width="100%" valign="top">{TITLE} Review
\r\n<font class="gensmall">by {AUTHOR}</font>\r\n
\r\n{REVIEW}\r\n</td>\r\n\r\n<td width="150" valign="top">\r\n<table border="0" cellspacing="2" cellpadding="1" width="150">\r\n\r\n<tr><td class="gensmall" colspan="2" bgcolor="#202020"> Rating</td></tr>\r\n\r\n<tr><td class="gensmall">Gameplay:</td><td class="gensmall">{GAMEPLAY}</td></tr>\r\n\r\n<tr><td class="gensmall">Graphics:</td><td class="gensmall">{GRAPHICS}</td></tr>\r\n\r\n<tr><td class="gensmall">Sound:</td><td class="gensmall">{SOUND}</td></tr>\r\n\r\n<tr><td class="gensmall">Value:</td><td class="gensmall">{VALUE}</td></tr>\r\n\r\n<tr><td class="gensmall">Tilt:</td><td class="gensmall">{TILT}</td></tr>\r\n\r\n<tr><td class="gensmall" colspan="2" align="center" bgcolor="#202020">Overall: {OVERALL}</td></tr>\r\n\r\n</table>\r\n\r\n</td></tr>\r\n</table>', 'reviews');
INSERT INTO `im_templates_data` VALUES ('', 1, 'review_header', '<table border="0" cellspacing="0" cellpadding="0" width="90%" align="center">\r\n\r\n<tr><td bgcolor="#404040" align="center">\r\nA\r\nB\r\nC\r\nD\r\nE\r\nF\r\nG\r\nH\r\nI\r\nJ\r\nK\r\nL\r\nM\r\nN\r\nO\r\nP\r\nQ\r\nR\r\nS\r\nT\r\nU\r\nV\r\nW\r\nX\r\nY\r\nZ\r\n1\r\n2\r\n3\r\n4\r\n5\r\n6\r\n7\r\n8\r\n9\r\n0
\r\n</td></tr>\r\n\r\n<tr><td bgcolor="#C0C0C0">\r\n\r\n<table border="0" cellspacing="1" cellpadding="2" width="100%">\r\n', 'reviews');
INSERT INTO `im_templates_data` VALUES ('', 1, 'review_footer', '</table>\r\n</td></tr>\r\n</table>', 'reviews');
INSERT INTO `im_templates_data` VALUES ('', 1, 'review_row', '<tr><td bgcolor="{BGCOLOR}">{TITLE}</td></tr>', 'reviews');
INSERT INTO `im_templates_data` VALUES ('', -1, 'Category Templates', '', 'category');
INSERT INTO `im_templates_data` VALUES ('', 1, 'box_header', '<table border="0" cellspacing="0" cellpadding="0" width="90%" align="center">\r\n<tr><td bgcolor="#202020">\r\n<table border="0" cellspacing="1" cellpadding="2" width="100%">\r\n<tr><td bgcolor="#202020">{TITLE}</td></tr>\r\n<tr><td bgcolor="#404040">', 'category');
INSERT INTO `im_templates_data` VALUES ('', 1, 'box_item', '& {TITLE}
', 'category');
INSERT INTO `im_templates_data` VALUES ('', 1, 'box_footer', '</td></tr>\r\n</table>\r\n</td></tr>\r\n</table>
', 'category');
INSERT INTO `im_templates_data` VALUES ('', -1, 'Games Templates', '', 'games');
INSERT INTO `im_templates_data` VALUES ('', 1, 'games_header', ' <p align="center">Choose a letter:
\r\n \r\nA\r\nB\r\nC\r\nD\r\nE\r\nF\r\nG\r\nH\r\nI\r\nJ\r\nK\r\nL\r\nM\r\nN\r\nO\r\nP\r\nQ\r\nR\r\nS\r\nT\r\nU\r\nV\r\nW\r\nX\r\nY\r\nZ\r\n1\r\n2\r\n3\r\n4\r\n5\r\n6\r\n7\r\n8\r\n9\r\n0\r\n \r\n
\r\n \r\n <table border="0" cellspacing="0" cellpadding="2" width="90%">\r\n <tr><td bgcolor="#404040">Game Title</td><td bgcolor="#404040">Genre</td><td bgcolor="#404040">Platform</td></tr>\r\n \r\n ', 'games');
INSERT INTO `im_templates_data` VALUES ('', 1, 'games_row', '<tr>\r\n<td bgcolor=\'{BGCOLOR}\' class=\'gensmall\'>{TITLE}</td>\r\n<td bgcolor=\'{BGCOLOR}\' class=\'gensmall\'>{GENRE}</td>\r\n<td bgcolor=\'{BGCOLOR}\' class=\'gensmall\'>{PLATFORM}</td>\r\n</tr>\r\n', 'games');
INSERT INTO `im_templates_data` VALUES ('', 1, 'categorybox_header', '<table border="0" cellspacing="0" cellpadding="1" width="90%" align="center">\r\n<tr><td bgcolor="#000000">\r\n\r\n<table border="0" cellspacing="0" cellpadding="3" width="100%">\r\n<tr><td bgcolor="#404040"> Sort {TITLE}:</td><td align="right" bgcolor="#404040">', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'categorybox_footer', '</td></tr>\r\n</table>\r\n</td></tr>\r\n</table>
', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'categorybox_link', '{TITLE}', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'categorybox_seperator', ' | ', 'global');
INSERT INTO `im_templates_data` VALUES ('', 1, 'featured_header', '<table border="0" cellspacing="3" cellpadding="3" width="100%">\r\n\r\n<tr>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'featured_footer', '</tr></table>', 'news');
INSERT INTO `im_templates_data` VALUES ('', 1, 'featured_item', '<td width="25%" valign="top">\r\n\r\n<table border="0" cellspacing="0" cellpadding="0" width="100%">\r\n<tr><td bgcolor="#000000">\r\n\r\n<table border="0" cellspacing="1" cellpadding="2" width="100%">\r\n<tr><td bgcolor="#202020" align="center" class="genmed">{TITLE}</td></tr>\r\n<tr><td bgcolor="#404040" class="gensmall" align="center">[img]{IMG}[/img]
{DESCRIPTION}</td></tr>\r\n</table>\r\n\r\n</td></tr>\r\n</table>\r\n\r\n</td>', 'news');
INSERT INTO `im_users` ( `primary_key` , `user` , `PASSWORD` , `userlevel` ) VALUES ('', 'demo', 'guest', '2');
UPDATE `im_templates_data` SET `templateset` = 'mainpage' WHERE `title` = 'news_item' LIMIT 1 ;
INSERT INTO `im_templates_data` ( `templateid` , `templatesetid` , `title` , `template` , `templateset` ) VALUES ('', '1', 'sort_cat.option', '<option value="{ID}">{NAME} ', 'mainpage');
INSERT INTO im_templates_data VALUES ('', 1, 'sort_news.menu', '<div align="center">\r\n<form method="post" action="index.php">\r\nSort articles by \r\n<select name="cat">\r\n<option value="all">All\r\n{CATEGORIES}\r\n</select> then by \r\n<select name="type">\r\n<option value="all">All\r\n{ARTICLES}\r\n</select>\r\n\r\n<input type="submit" value="Go">\r\n</form>\r\n</div>', 'mainpage');
INSERT INTO im_templates_data VALUES ('', -1, 'Main Page Templates', '', 'mainpage');
|
And it gives me the error,
Quote:
|
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 `im_categories` ( `id` tinyint(11) NOT NULL
|
... and i still cant access the forum with my account...
tom
|
07-01-2003, 01:32 PM
Linear Mode
