Be on the lookout for sad wiki things

[foxfirefey]

We had a category that was creating a glitch in the Mediawiki software: "Â Third_party_programs"

I had to go into the database to try and fix it; the category is now gone and I don't forsee any problems from that, but in case I did cause some, please let me know.


This required database hijinks, so for future reference if things go pear shaped, here's the info for the category in the categorylinks table:

+---------+-------+--------------------------+---------------------+-------------------+--------------+---------+
| cl_from | cl_to | cl_sortkey               | cl_timestamp        | cl_sortkey_prefix | cl_collation | cl_type |
+---------+-------+--------------------------+---------------------+-------------------+--------------+---------+
|    1244 | Index |  THIRD PARTY PROGRAMS   | 2010-01-11 16:20:13 |                   | uppercase    | subcat  |
+---------+-------+--------------------------+---------------------+-------------------+--------------+---------+

And the category table:

+--------+------------------------------------------+-----------+-------------+-----------+
| cat_id | cat_title                                | cat_pages | cat_subcats | cat_files |
+--------+------------------------------------------+-----------+-------------+-----------+
|     98 |  Third_party_programs                   |         0 |           0 |         0 |
+--------+------------------------------------------+-----------+-------------+-----------+

And in the page table:

+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title               | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random    | page_touched   | page_latest | page_len |
+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
|    1244 |             14 |  Third_party_programs   |                   |          156 |                0 |           1 | 0.971628604236 | 20101207201106 |        7082 |       19 |
+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+

Comments

[pauamma]

I'm curious: what problems was it causing and (if you know) why? (eg, is it the non-ASCII first character?)