发新话题
打印

MamboV4.6.1.cn.zip安装出现错误

MamboV4.6.1.cn.zip安装出现错误

mysql5.0 apache2.2 php-5.2.0-Win32
安装后出现的错误
复制内容到剪贴板
代码:
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)
= = = = = = = = = =

TOP

`comments` text NOT NULL default '', 改成  `comments` text NOT NULL,
  `text` text NOT NULL default '',改成`text` text NOT NULL

这个问题是 mysql的问题

TOP

发新话题