[Mediawiki-l] Site statistics and categories screwed up

[Jan]

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 at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> 
>