Помогите исправить ошибку в базе

Санек · 15 Окт 2011

После того как я попытался загрузить базу на денвер она показала вот такую ошибку

И не могу понять как ее исправить помогите
вот база

PHP:

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 ;
CREATE TABLE `favorite` (
  `id` int(50) NOT NULL auto_increment,
  `uid` int(20) NOT NULL default '0',
  `vidid` int(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `ratings` (
  `id` int(50) NOT NULL auto_increment,
  `vidid` int(20) NOT NULL default '0',
  `uid` int(20) NOT NULL default '0',
  `rate` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `artist_videos` (
  `id` int(11) NOT NULL auto_increment,
  `bron` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `vid_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `vid_url` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `date_added` varchar(40) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `uid` int(20) NOT NULL default '0',
  `unick` varchar(40) character set utf8 collate utf8_unicode_ci NOT NULL default 'admin',
  `categorie` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `artiest` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `views` int(20) NOT NULL default '1',
  `top` int(20) NOT NULL default '0',
  `totalviews` int(50) NOT NULL default '0',
  `totalvids` int(50) NOT NULL default '0',
  `subcategorie` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `descript` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=232 ;
INSERT INTO `artist_videos` (`id`, `bron`, `vid_name`, `vid_url`, `date_added`, `uid`, `unick`, `categorie`, `artiest`, `views`, `top`, `totalviews`, `totalvids`, `subcategorie`, `descript`) VALUES
(43, 'youtube', 'rythm is love PV', '8kKZxbgBL68', 'May 19, 2008', 2, 'maloya', 'Music and Entertainment', 'rythm is love PV', 17, 80, 0, 0, 'Others', '');
INSERT INTO `LocalizationKeys` (`ID`, `IDCategory`, `Key`) VALUES
(2865, 3, 'Youtubes');
INSERT INTO `LocalizationKeys` (`ID`, `IDCategory`, `Key`) VALUES
(3111, 3, '_Youtubes');
INSERT INTO `LocalizationStrings` (`IDKey`, `IDLanguage`, `String`) VALUES
(2865, 1, 'Youtubes ')
(3111, 1, 'Youtubes'),
(3111, 3, 'Youtubes'),
(3111, 4, 'Youtubes'),
(3111, 2, 'Youtubes'),
(3111, 8, 'Youtubes'),
(3111, 9, 'Youtubes');
INSERT INTO `PageCompose` (`ID`, `Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MemLevelsVisibility`, `MinWidth`) VALUES
(90, 'index', '966px', 'Simple HTML Block', 'Youtubes Video Zone', 1, 5, 'Echo', '<table width="100%">\n<tbody>\n<tr>\n<td align="left"><iframe id="map" src="http://yourdomain.com/community/youtubes/indexindex.php" marginwidth="0" marginheight="0" vspace="0" hspace="0" style="overflow:visible;  display:none" scrolling="no" width="345" frameborder="0"> </iframe><br type="_moz" /></td>\n</tr>\n</tbody>\n</table>', 1, 60, 'memb', 1073741823, 0),
(91, 'index', '966px', 'Simple HTML Block', 'Youtubes Player', 0, 0, 'Echo', '<table width="100%">\r\n<tbody>\r\n<tr>\r\n<td align="left"><iframe id="map" src="http://www.yourdomain.com/community/youtubes/homeplayer/videoPlayer.html" marginwidth="0" marginheight="0" vspace="0" hspace="0" style="overflow:visible;  display:none" frameborder="0" scrolling="no" width="345"> </iframe></td>\r\n</tr>\r\n</tbody>\r\n</table>', 1, 39, 'non,memb', 1073741823, 0),
(92, 'profile', '975px', 'Youtubes Index', 'Youtubes Video Zone', 1, 4, 'YoutubesIndex', '', 1, 60, 'non,memb', 1073741823, 0),
(93, 'profile', '975px', 'Youtubes Featured', 'Youtubes Video Zone', 0, 0, 'YoutubesFeatured', '', 1, 50, 'non,memb', 1073741823, 0),
(94, 'profile', '975px', 'Youtubes Featured Index', 'Youtubes Video Zone', 0, 0, 'YoutubesFeaturedIndex', '', 1, 50, 'non,memb', 1073741823, 0),
(95, 'member', '1003px', 'Simple HTML Block', 'Youtubes Video Zone', 1, 2, 'Echo', '<table width="100%">\r\n<tbody>\r\n<tr>\r\n<td align="left"><iframe id="map" src="http://www.yourdomain.com/community/youtubes/accountindex.php" marginwidth="0" marginheight="0" vspace="0" hspace="0" style="overflow:visible;  display:none" frameborder="0" scrolling="no" width="345"> </iframe></td>\r\n</tr>\r\n</tbody>\r\n</table>', 1, 39, 'non,memb', 1073741823, 0),
CREATE TABLE IF NOT EXISTS `yvz_settings` (
  `id` int(10) NOT NULL default '0',
  `autoplay` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `selecturl` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `selectembed` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `share` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `profvid` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `menu` enum('1','2','3','4','5','6','7','8','9') collate utf8_unicode_ci NOT NULL default '1',
  `wide` enum('1','2') collate utf8_unicode_ci NOT NULL default '2',
  `setwidth` varchar(10) collate utf8_unicode_ci NOT NULL default '200',
  `playerwidth` varchar(10) collate utf8_unicode_ci NOT NULL default '700',
  `playerheight` varchar(10) collate utf8_unicode_ci NOT NULL default '562',
  `description` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `setleft` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `comments` enum('1','2') collate utf8_unicode_ci NOT NULL default '2',
  `warp` enum('1','2') collate utf8_unicode_ci NOT NULL default '2',
  `langstring` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `downloadvideo` enum('1','2','3','4') collate utf8_unicode_ci NOT NULL default '1',
  `postvideo` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `tophomeplayer` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `topplayer` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `yvz_settings`
--
INSERT INTO `yvz_settings` (`id`, `autoplay`, `selecturl`, `selectembed`, `share`, `profvid`, `menu`, `wide`, `setwidth`, `playerwidth`, `playerheight`, `description`, `setleft`, `comments`, `warp`, `langstring`, `downloadvideo`, `postvideo`, `tophomeplayer`, `topplayer`) VALUES
(1, '1', '1', '1', '1', '1', '4', '1', '170', '700', '562', '1', '1', '2', '2', 'charset=utf-8', '2', '1', '2', '2');
CREATE TABLE IF NOT EXISTS `yvz_featured` (
  `id` int(50) NOT NULL auto_increment,
  `uid` int(20) NOT NULL default '0',
  `nick` varchar(255) NOT NULL default '',
  `vidid` int(20) NOT NULL default '0',
  `main` enum('1','2') character set utf8 collate utf8_unicode_ci NOT NULL default '2',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
CREATE TABLE IF NOT EXISTS `yvz_categories` (
  `id` int(10) NOT NULL auto_increment,
  `catname` varchar(60) collate utf8_unicode_ci default NULL,
  `headcat` varchar(60) collate utf8_unicode_ci default NULL,
  `subcat` varchar(60) collate utf8_unicode_ci default NULL,
  `memberrestrict` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=62 ;
--
-- Dumping data for table `yvz_categories`
--
INSERT INTO `yvz_categories` (`id`, `catname`, `headcat`, `subcat`, `memberrestrict`) VALUES
(27, 'Children and Family', '', 'head category', ''),
(22, 'General', '', 'head category', ''),
(44, 'Autos and Vehicles', '', 'head category', ''),
(24, 'Movies and Trailers', '', 'head category', ''),
(25, 'Hobby', '', 'head category', ''),
(26, 'Funny', '', 'head category', ''),
(28, 'Music and Entertainment', '', 'head category', ''),
(29, 'Webcam', '', 'head category', ''),
(30, 'News', '', 'head category', ''),
(31, 'Sport', '', 'head category', ''),
(32, 'Toons and Animations', '', 'head category', ''),
(33, 'TV and Commercials', '', 'head category', ''),
(34, 'Games', '', 'head category', ''),
(35, 'Top 40', 'Music and Entertainment', 'sub category', ''),
(36, 'R n B', 'Music and Entertainment', 'sub category', ''),
(37, 'Hip Hop en Rap', 'Music and Entertainment', 'sub category', ''),
(38, 'Country', 'Music and Entertainment', 'sub category', ''),
(39, 'Hardcore', 'Music and Entertainment', 'sub category', ''),
(40, 'Rock', 'Music and Entertainment', 'sub category', ''),
(41, 'Soul', 'Music and Entertainment', 'sub category', ''),
(42, 'Others', 'Music and Entertainment', 'sub category', ''),
(43, 'Animals', '', 'head category', ''),
(45, 'Movies', 'Movies and Trailers', 'sub category', ''),
(46, 'Trailers', 'Movies and Trailers', 'sub category', ''),
(47, 'Toons', 'Toons and Animations', 'sub category', ''),
(48, 'Animations', 'Toons and Animations', 'sub category', ''),
(53, 'TV', 'TV and Commercials', 'sub category', ''),
(54, 'Commercials', 'TV and Commercials', 'sub category', ''),
(51, 'Autos', 'Autos and Vehicles', 'sub category', ''),
(52, 'Others', 'Autos and Vehicles', 'sub category', ''),
(57, 'Featured Videos', '', 'head category', 'view only'),
(58, 'Reggae', 'Music and Entertainment', 'sub category', ''),
(59, 'House & Trance', 'Music and Entertainment', 'sub category', ''),
(60, 'Business', '', 'head category', ''),
(61, 'Computers & Internet', '', '', '');
CREATE TABLE IF NOT EXISTS `yvz_adverts` (
  `id` int(10) NOT NULL auto_increment,
  `advertname` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `adv` longtext collate utf8_unicode_ci,
  `location` varchar(60) collate utf8_unicode_ci default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `yvz_membersettings` (
  `id` int(10) NOT NULL auto_increment,
  `uid` int(10) NOT NULL default '0',
  `nick` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `autoplay` enum('1','2') collate utf8_unicode_ci NOT NULL default '1',
  `menu` enum('1','2','3','4','5','6','7','8','9') collate utf8_unicode_ci NOT NULL default '1',
  `setfeatured` varchar(10) collate utf8_unicode_ci NOT NULL default '5',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
INSERT INTO `PageAccessRules` (`ID`, `Rule`, `MemLevels`) VALUES
(7, 'youtubes\\.php', 2);

Для просмотра скрытого содержимого вы должны войти или зарегистрироваться.

AutoRun · 15 Окт 2011

Так у тебя запятая стоит перед

Код:

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 ;

нужно точку с запятой:

Код:

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')[B][COLOR="Red"];[/COLOR][/B]
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 ;

Добавлено через 1 минуту
ну конечно нужно чтоб таблица "AdminMenu" уже существовала

Помогите исправить ошибку в базе

Санек

Писатель

AutoRun

Постоялец