Wikipedia，自由的百科全书

SQL=Invalid default value for 'rating_sum': - - - - - - - - - -

1. Table structure for table `mos_content_rating`

CREATE TABLE `mos_content_rating` (

 `content_id` int(11) NOT NULL default '0',
 `rating_sum` int(11) unsigned NOT NULL default ,
 `rating_count` int(11) unsigned NOT NULL default '0',
 `lastip` varchar(50) NOT NULL default ,
 PRIMARY KEY  (`content_id`)

) TYPE=MyISAM

= = = = = = = =

安装mambo时,报的错误,请达人帮助

=============

安装mambo到第二步出错： SQL=Specified key was too long; max key length is 1000 bytes: - - - - - - - - - -

1. 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

= = = = = = = =

查询google，果然有人碰到类似问题。解答是： this problem cause maybe mysql default character set utf-8. when you create database,you should set collate to latin1_swedish_ci like this: "create database mambodat default collate latin1_swedish_ci;"

还有是： Edit installation/sql/mambo.sql and add the following line to the create table statement : DEFAULT CHARACTER SET latin1 the result :

1. 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`), KEY `hidden_aro` (`hidden`), KEY `mos_gacl_hidden_aro` (`hidden`) ) TYPE=MyISAM, DEFAULT CHARACTER SET latin1;

应该是这个问题，后者我试过了OK。 http://forum.mamboserver.com/showthread.php?t=32783