安装joomla1.0.11简体中文版小记
joomla是一个开源的据说很NB的cms管理系统。。。
官方英文网站
繁体中文台湾网站
简体中文网站
又一个简体中文网站
joomla之门，简体中文网站
joomla简单来说就是从mambo小组成员中分离出来的另外的一个cms系统，也可以说mambo是joomla的前身吧。。。
简单介绍一下就好，更多的去网上搜吧。。。
我选择试用joomla的时候1.0.12的英文已经出了稳定版本，但是中文的稳定版本只到1.0.11，1.5目前还是beta版本，所以我选用了1.0.11的简繁体中文utf-8的稳定版本。。。
安装过程很简单，但是在数据库的那一步出现了类似于这样的错误：
- 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)
- = = = = = = = = = =
按照提示，修改了程序中installation/sql/sql_simplified_chinese/joomla.sql 的这个文件，共修改了两个地方，一个是：
找到
- 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;
将其中的
- `text` text NOT NULL default '',
修改为：
- `text` text NOT NULL,
然后找到：
- CREATE TABLE `#__contact_details` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(100) NOT NULL default '',
- `con_position` varchar(50) default NULL,
- `address` text,
- `suburb` varchar(50) default NULL,
- `state` varchar(20) default NULL,
- `country` varchar(50) default NULL,
- `postcode` varchar(10) default NULL,
- `telephone` varchar(25) default NULL,
- `fax` varchar(25) default NULL,
- `misc` mediumtext,
- `image` varchar(100) default NULL,
- `imagepos` varchar(20) default NULL,
- `email_to` varchar(100) default NULL,
- `default_con` tinyint(1) unsigned NOT NULL default '0',
- `published` tinyint(1) unsigned NOT NULL default '0',
- `checked_out` int(11) unsigned NOT NULL default '0',
- `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
- `ordering` int(11) NOT NULL default '0',
- `params` text NOT NULL,
- `user_id` int(11) NOT NULL default '0',
- `catid` int(11) NOT NULL default '0',
- `access` tinyint(3) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM;
将其中的
- `postcode` varchar(10) default NULL,
修改为：
- `postcode` varchar(30) default NULL,
第一处修改是因为在mysql5的版本里text字段不再支持默认值，所以要将default ”去掉，
第二处修改我猜想是应为utf-8编码是占用3位的，所以默认的varchar长度10的字段并不能满足需求，需要增加长度到30来修改。
这两处改好后，上传覆盖掉原来的joomla.sql文件，重新安装，成功！！！
需要注意的是，由于sql文件是utf-8编码，所以修改的时候请注意你选择的编辑器。。。
