foxfirefey: A wee rat holds a paw to its mouth. Oh, the shock! (myword)
[personal profile] foxfirefey posting in [site community profile] dw_wiki
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 |
+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of people who comment anonymously.
Links will be displayed as unclickable URLs to help prevent spam.