Just a few days ago, I could solve these two problems (with help from a MediaWiki-mailinglist ;-)

Empty categorys: Execute in folder maintenance the follwing command on your webservers commandline: php refreshLinks.php If your havent got access to the webserver by commandline, you only can try the skript "phpShell" ... for me, phpShell works :) Now all articles are assigned correctly to their categories.

0 articles (and the rest of Special:Statistics FIRST: Open Adminsettings.sample, type in the DB-Login, and save as described. Then execute the command: "php Init_stats.php"

When you get an error (and the statistics have not been repaired), try this: In the database does exist an row with key=1, so that init_stats.php cant "INSERT" the values into the table "wiki_site_stats". So I droped the first row from the table "wiki_site_stats" in phpMyAdmin. Then execute php Init_stats.php again. For me, it works :-)

btw, does your fulltext search in the wiki work? If not: "maintenance/" php rebuildall.php amd php rebuildtextindex.php

Regards, Jan

Gerrit Holl schrieb:

Hello,

My harddisc crashed and all I was able to recover was an old cur table. I installed Mediawiki 1.4, loaded the cur_table, upgraded to the newest version, and my wiki is working again. However, there are two problems:

* It says there are 0 articles
* All categories seem empty

mysql> select * from site_stats; +-----------+----------------+----------------+------------------+----------------+----------+-----------+ | ss_row_id | ss_total_views | ss_total_edits | ss_good_articles | ss_total_pages | ss_users | ss_admins | +-----------+----------------+----------------+------------------+----------------+----------+-----------+ | 1 | 346 | 18 | 0 | 2468 | 2 | -1 | +-----------+----------------+----------------+------------------+----------------+----------+-----------+ 1 row in set (0.00 sec) mysql> select * from categorylinks limit 5; +---------+-----------------+-------------+---------------------+ | cl_from | cl_to | cl_sortkey | cl_timestamp | +---------+-----------------+-------------+---------------------+ | 1918 | Persoon | Ddofborg | 2006-01-12 23:52:23 | | 1236 | Recept | Recept | 2006-01-12 23:52:08 | | 1 | Alles | Hoofdpagina | 2006-01-12 23:51:51 | | 1256 | Communicatie | Jabber | 2006-01-12 23:52:09 | | 929 | Eten_en_drinken | Eten | 2006-01-12 23:52:00 | +---------+-----------------+-------------+---------------------+ 5 rows in set (0.00 sec)

(it continues like this)

I ran rebuildall.php. init_stats.php give a database error: $ php initStats.php wikidb: setting edits 2568, pages 417 A database error has occurred Query: INSERT INTO `site_stats` (ss_row_id,ss_total_views,ss_total_edits,ss_good_articles) VALUES ('1','0','2568','417') Function: Database::insert Error: 1062 Duplicate entry '1' for key 1 (localhost)

Backtrace: GlobalFunctions.php line 451 calls wfBacktrace() Database.php line 408 calls wfDebugDieBacktrace() Database.php line 358 calls DatabaseMysql::reportQueryError() Database.php line 948 calls DatabaseMysql::query() initStats.php line 23 calls DatabaseMysql::insert()

Any hints?

regards, Gerrit. _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l