mysql5.0 apache2.2 php-5.2.0-Win32
安装后出现的错误

复制内容到剪贴板

代码:

[Copy to clipboard]SQL=BLOB/TEXT column 'comments' can't have a default value:
- - - - - - - - - -
# Table structure for table `mos_comment`

CREATE TABLE `mos_comment` (
  `id` int(11) NOT NULL auto_increment,
  `articleid` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `name` varchar(30) NOT NULL default '',
  `comments` text NOT NULL default '',
  `startdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM
= = = = = = = = = =

SQL=BLOB/TEXT column 'text' can't have a default value:
- - - - - - - - - -
# Table structure for table `mos_poll_data`

CREATE TABLE `mos_poll_data` (
  `id` int(11) NOT NULL auto_increment,
  `pollid` int(4) NOT NULL default '0',
  `text` text NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
# Dumping data for table `mos_poll_data`

INSERT INTO `mos_poll_data` VALUES (20, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (19, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (18, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (17, 15, 'Scott Adams', 1)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (16, 15, 'Tim Berners-Lee', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (15, 15, 'Linus Torvalds', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (14, 15, 'Bill Gates', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (13, 15, 'Steve Jobs', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (21, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (22, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (23, 15, '', 0)
= = = = = = = = = =

SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (24, 15, '', 0)
= = = = = = = = = =

应该跟Mysql的版本有关系，我在3.23上执行了一下，没有问题。

我跟楼主出现了同样的问题，看来也得mysql了

SQL=BLOB/TEXT column 'comments' can't have a default value:
- - - - - - - - - -
# Table structure for table `mos_comment`

CREATE TABLE `mos_comment` (
  `id` int(11) NOT NULL auto_increment,
  `articleid` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `name` varchar(30) NOT NULL default '',
  `comments` text NOT NULL default '',
  `startdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM
= = = = = = = = = =
column 'comments' can't have a default value: 说的很明显，comments这个字段没有默认值

用文本编辑软件 打开 \installation\sql\mambo.sql文件
找到这一段
CREATE TABLE `mos_comment` (
  `id` int(11) NOT NULL auto_increment,
  `articleid` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `name` varchar(30) NOT NULL default '',
  `comments` text NOT NULL default '',
  `startdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM

把其中这一行
`comments` text NOT NULL default ''
修改成
`comments` text NOT NULL default '0'
一般就可以了，其他的类似