在安装生成数据库时会出错:
SQL=Invalid default value for 'rating_sum':
- – - – - – - – - -
# Table structure for table `mos_content_rating`
- – - – - – - – - -
# 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.sql有错,其中很明显的问题,rating_sum` int(11)是整数型,这里却设缺省值为空字符.找到安装目录的SQL文件:mambo_dir/installation/sql/mambo.sql,把
`rating_sum` int(11) unsigned NOT NULL default ''
改为
`rating_sum` int(11) unsigned NOT NULL default '0'
就行了.
将修改后的文件上传,覆盖到installation/sql下即可.
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.