magcimeteor
2007-01-11, 15:28:39 | 未填写住址
我在安装的时候出现这样的问题,第二步出错:
SQL=BLOB/TEXT column \'text\' can\'t have a default value SQL=# Table structure for table `jos_poll_data`\n\nCREATE TABLE `jos_poll_data` (\n `id` int(11) NOT NULL auto_increment,\n `pollid` int(4) NOT NULL default \'0\',\n `text` text NOT NULL default \'\',\n `hits` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `pollid` (`pollid`,`text`(1))\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_data`
CREATE TABLE `#__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=Data too long for column \'postcode\' at row 1 SQL=# Dumping data for table `jos_contact_details`\nINSERT INTO `jos_contact_details` VALUES (1, \'姓名\', \'职称\', \'住址\', \'市/镇\', \'省/市\', \'国家/地区\', \'邮递区号\', \'电话\', \'传真\', \'其它连络资讯\', \'asterisk.png\', \'top\', \'email@email.com\', 1, 1, 0, \'0000-00-00 00:00:00\', 1, \'\', 0, 12, 0):
- - - - - - - - - -
# Dumping data for table `#__contact_details`
INSERT INTO `#__contact_details` VALUES (1, '姓名', '职称', '住址', '市/镇', '省/市', '国家/地区', '邮递区号', '电话', '传真', '其它连络资讯', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=# Dumping data for table `jos_poll_data`\n\nINSERT INTO `jos_poll_data` VALUES (1, 14, \'十分简单\', 1):
- - - - - - - - - -
# Dumping data for table `#__poll_data`
INSERT INTO `#__poll_data` VALUES (1, 14, '十分简单', 1)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (2, 14, \'合理地简单\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (2, 14, '合理地简单', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (3, 14, \'不是很直觉式的,但对我来说还可以\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (3, 14, '不是很直觉式的,但对我来说还可以', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (4, 14, \'我必须要安装另外的地方试试\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (4, 14, '我必须要安装另外的地方试试', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (5, 14, \'我没意见,是我朋友帮我的忙\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (5, 14, '我没意见,是我朋友帮我的忙', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (6, 14, \'我的狗把说明档咬走了\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (6, 14, '我的狗把说明档咬走了', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (7, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (7, 14, '', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (8, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (8, 14, '', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (9, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (9, 14, '', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (10, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (10, 14, '', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (11, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (11, 14, '', 0)
= = = = = = = = = =
SQL=Table \'myphp.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (12, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (12, 14, '', 0)
= = = = = = = = = =
请问怎么解决呢?我的环境是php5,mydql5.0的。难道还不能支持mysql5.0?
呵呵,你的网站也是用Joomla制作的吗?何不在本站的“酷站”栏目登记一下?我们一直在努力收集国内的Joomla网站,谢谢!
不用登录即可添加新酷站,快去操作吧。