New subject: [Mediawiki-l] Site statistics and categories screwed up

12 Jan 2006

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.