请帮忙看看，是什么原因？谢谢！


错误记录:

SQL=Specified key was too long; max key length is 1000 bytes:
- - - - - - - - - -
# Table structure for table `mos_core_acl_aro`

CREATE TABLE `mos_core_acl_aro` (
  `aro_id` int(11) NOT NULL auto_increment,
  `section_value` varchar(240) NOT NULL default '0',
  `value` varchar(240) NOT NULL default '',
  `order_value` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `hidden` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aro_id`),
  UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
  UNIQUE KEY `mos_gacl_section_value_value_aro` (`section_value`,`value`),
  KEY `hidden_aro` (`hidden`),
  KEY `mos_gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM
= = = = = = = = = =

你用的是 mysql4.1 的 utf-8 编码吧，建议使用其它编码，或者直接用 mysql5.0，最好是用 Mysql4.0，问题最少

引用:

原帖由 test 于 2006-6-13 12:14 发表
你用的是 mysql4.1 的 utf-8 编码吧，建议使用其它编码，或者直接用 mysql5.0，最好是用 Mysql4.0，问题最少

我用的是 MySQL - 5.0.16  

在论坛内查找了一下，按照精华贴“教你如何解决453h安装在mysql 4.1 以上的UTF8数据库中造成的乱码和安装失败问题”的方法更改，仍然出现以下错误

错误记录:

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 '
  
  KEY `hidden_aro` (`hidden`),
  KEY `mos_gacl_hidden_aro` (`hidden`)
) TYPE' at line 11:
- - - - - - - - - -
# Table structure for table `mos_core_acl_aro`

CREATE TABLE `mos_core_acl_aro` (
  `aro_id` int(11) NOT NULL auto_increment,
  `section_value` varchar(240) NOT NULL default '0',
  `value` varchar(240) NOT NULL default '',
  `order_value` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `hidden` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aro_id`),
  ,
  
  KEY `hidden_aro` (`hidden`),
  KEY `mos_gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
= = = = = = = = = =

SQL=Table 'mambo.mos_core_acl_aro' doesn't exist:
- - - - - - - - - -
ALTER TABLE `mos_core_acl_aro` CHANGE `section_value` `section_value` VARCHAR( 240 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '0'
= = = = = = = = = =

SQL=Table 'mambo.mos_core_acl_aro' doesn't exist:
- - - - - - - - - -
ALTER TABLE `mos_core_acl_aro` CHANGE `value` `value` VARCHAR( 240 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default ''
= = = = = = = = = =

SQL=Table 'mambo.mos_core_acl_aro' doesn't exist:
- - - - - - - - - -
ALTER TABLE `mos_core_acl_aro` ADD UNIQUE `section_value_value_aro` ( `section_value` , `value` )
= = = = = = = = = =

SQL=Table 'mambo.mos_core_acl_aro' doesn't exist:
- - - - - - - - - -
ALTER TABLE `mos_core_acl_aro` ADD UNIQUE `mos_gacl_section_value_value_aro` (`section_value`,`value`)
= = = = = = = = = =

你可以先本地安装！再把文件发到网上再把数据库导进去！呵呵！不过应该会有报错！我也正再处理