查看完整版本: 安装曼波5.3.0..第三步MYSQL出错

安装曼波5.3.0..第三步MYSQL出错

SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 23:
- - - - - - - - - -
# $Id: mambo_english.sql,v 2.0 2007/07/30 02:42:00 lang3 Exp $
# Table structure for table `mb_banner`

CREATE TABLE `mb_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `type` varchar(10) NOT NULL default 'banner',
  `name` varchar(50) NOT NULL default '',
  `imptotal` int(11) NOT NULL default '0',
  `impmade` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(100) NOT NULL default '',
  `clickurl` varchar(200) NOT NULL default '',
  `date` datetime default NULL,
  `showBanner` tinyint(1) NOT NULL default '0',
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `custombannercode` text,
  PRIMARY KEY  (`bid`),
  KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM DEFAULT CHARACTER SET gbk
= = = = = = = = = =

SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 13:
- - - - - - - - - -
# Table structure for table `mb_bannerclient`

CREATE TABLE `mb_bannerclient` (
  `cid` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `contact` varchar(60) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` time default NULL,
  `editor` varchar(50) default NULL,
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM DEFAULT CHARACTER SET gbk
= = = = = = = = = =

SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 14:
- - - - - - - - - -
# Table structure for table `mb_bannerfinish`

CREATE TABLE `mb_bannerfinish` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `impressions` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(50) NOT NULL default '',
  `datestart` datetime default NULL,
  `dateend` datetime default NULL,
  PRIMARY KEY  (`bid`)
) TYPE=MyISAM DEFAULT CHARACTER SET gbk
= = = = = = = = = =

SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 22:
- - - - - - - - - -
# Table structure for table `mb_categories`

CREATE TABLE `mb_categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `image` varchar(100) NOT NULL default '',
  `section` varchar(50) NOT NULL default '',
  `image_position` varchar(10) NOT NULL default '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `ordering` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_section_pid` (`section`,`parent_id`)
) TYPE=MyISAM DEFAULT CHARACTER SET gbk
= = = = = = = = = =

SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 18:
- - - - - - - - - -








看不懂.............新手刚学习...在线等....

你的php和mysql版本多少？

数据库地址的问题！好解决的！

到底怎么解决的？我现在也出现这样的问题？

我现在也出现这样的问题？怎么解决？
安装曼波5.5.0..第三步MYSQL出错
SQL=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 'TYPE=MyISAM DEFAULT CHARACTER SET gbk' at line 23:
- - - - - - - - - -
# $Id: mambo_english.sql,v 2.0 2007/07/30 02:42:00 lang3 Exp $
# Table structure for table `mb_banner`

这是这种情况！