干海棠科技,致力于信息化生活的推广与普及的专业教学。

MediaWiki真的很烦人。

上一篇 / 下一篇  2007-06-06 22:20:35 / 天气: 舒适 / 心情: 高兴 / 个人分类:干海棠维护日志

  在冷玉的支持下,还是决定安装一个mediawiki试试,因为前几次都安装失败了,这次改用了天下维客汉化的1.6.8汉化完全版
  一开始,就是原来的错误:

Creating tables... using MySQL 4 table defs...Query "CREATE TABLE `mdwiki_job` ( job_id int(9) unsigned NOT NULL auto_increment, job_cmd varchar(255) NOT NULL default '', job_namespace int NOT NULL, job_title varchar(255) binary NOT NULL, job_params blob NOT NULL default '', PRIMARY KEY job_id (job_id), KEY (job_cmd, job_namespace, job_title) ) TYPE=InnoDB " failed with error code "Specified key was too long; max key length is 1000 bytes (localhost)".

以为还是无法安装,还好,有冷玉告诉了我job_title失败的原因,不过由于我用的是1.6.X版,要改的文件与教程中的不一样,而应该是:

Find  text: job_title varchar
Search res ults:
3 files and 0 directories found

mediawiki-1.6.10\maintenance\mysql5\tables.sql
mediawiki-1.6.10\maintenance\tables.sql
mediawiki-1.6.10\maintenance\archives\patch-job.sql

最后一个文件我先还以为是存档后才会生成,结果我错了,这也是MEDIA WIKI中本来就有的文件,而我使用DW8是不能通过这个方法找到最后一个文件的,好像DW不支持对SQL文件中的字符检索,怪不得冷玉说他有检索工具了:)

完全改过来之后,以为这下应该能成功了吧,好期待:

Creating job table...ok
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...have rc_type field in recentchanges table.
...have rc_ip field in recentchanges table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...have user_real_name field in user table.
...have user_token field in user table.
...have user_email_token field in user table.
...have user_registration field in user table.
...have log_params field in logging table.
...have ar_rev_id field in archive table.
...have ar_text_id field in archive table.
...have page_len field in page table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have img_media_type field in image table.
...have val_ip field in validate table.
...have ss_total_pages field in site_stats table.
...have iw_trans field in interwiki table.
...have ipb_range_start field in ipblocks table.
...have ss_images field in site_stats table.
...already have interwiki table
...indexes seem up to 20031107 standards
Already have pagelinks; skipping old links table updates.
...image primary key already set.
The watchlist table is already set up for email notification.
...watchlist talk page rows already present
...user table does not contain old email authentication field.
Logging table has correct title encoding.
...page table already exists.
revision timestamp indexes already up to 2005-03-13
...rev_text_id already in place.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...already have pagelinks table.
...templatelinks table already exists
No img_type field in image table; Good.
Already have unique user_name index.
...user_groups table already exists.
...user_groups is in current format.
...wl_notificationtimestamp is already nullable.
...timestamp key on logging already exists.
Setting page_random to a random value on rows where it equals 0...changed 0 rows
Initialising "MediaWiki" namespace...
A database error has occurred
Query: INSERT  INTO `mdwiki_text` (old_id,old_text,old_flags) VALUES (NULL,'以下的页面都有到\'\'\'消含糊页\'\'\'的链接, 但它们应该是链到适当的标题.
一个页面会被视为消含糊页如果它是链自$1.
由其它名字空间来的链接\'\'\'不会\'\'\'在这儿被列出来.','utf-8')
Function: Revision::insertOn
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\'不会\'\'\'在这儿被列出来.','utf-8')' at line 1 (localhost)

Backtrace:
GlobalFunctions.php line 602 calls wfBacktrace()
Database.php line 473 calls wfDebugDieBacktrace()
Database.php line 419 calls Database::reportQueryError()
Database.php line 1023 calls Database::query()
Revision.php line 624 calls Database::insert()
InitialiseMessages.inc line 213 calls Revision::insertOn()
InitialiseMessages.inc line 72 calls initialiseMessagesReal()
updaters.inc line 822 calls initialiseMessages()
index.php line 659 calls do_all_updates()

郁闷呀,实在想不透,又看不明白提示了,只有等下次有空再弄了,看上去好像是跟我的数据库中目前安装的DZ系统有些冲突,不知道是不是这个原因,如果真是这样,我就没办法解决了,老大赞助了服务器,也没时间天天帮我调MYSQL滴,,,

为什么MEDIAWIKI安装这么麻烦呀,,,


TAG: mediawiki wiki 安装 出错 失败

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar