发新话题
打印

数据库插入数据出错! 高手帮帮我啊

数据库插入数据出错! 高手帮帮我啊

高手帮我看看。谢谢啦。

安装前的检查       全部通过。

到第二步的时候提示:

数据库插入数据出错!
无法继续安装。

错误记录:
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 'mambott.mos_poll_data' doesn't exist:
- - - - - - - - - -
# Dumping data for table `mos_poll_data`

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

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

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

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

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

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

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

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

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

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

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

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

TOP

我记得一位高手说过:

要么使用 mysql4.0.2x,

要么把
`section_value` varchar(240) NOT NULL default '0',
  `value` varchar(240) NOT NULL default '',

改为
`section_value` varchar(120) NOT NULL default '0',
  `value` varchar(120) NOT NULL default '',

TOP

发新话题