2006-1-31 15:40 Zoom 全屏 About Mambo SQL 1071 Error install and solution

The error:
SQL=Specified key was too long; max key length is 1000 bytes:
.....

The solution:
Open installation/sql/mabo.sql and add the following line to the create table statement :
DEFAULT CHARACTER SET latin1

The result:
# Table structure for table `#__core_acl_aro`
#

CREATE TABLE `#__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 `#__gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `#__gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM,
DEFAULT CHARACTER SET latin1;
作者: Poster: 把上帝弄哭 分类: Category: 笔迹 回复 Comments : 引用 Trackback : 阅读 Read :

回复 Comments

{commenttime} {commentauthor}

{CommentUrl}
{commentcontent}