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 |
+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+

(no subject)

Date: 2013-03-17 12:33 pm (UTC)
pauamma: Cartooney crab holding drink (Default)
From: [personal profile] pauamma
I'm curious: what problems was it causing and (if you know) why? (eg, is it the non-ASCII first character?)

Profile

dw_wiki: Going to the wiki! (Default)
Dreamwidth Wiki Management

November 2016

S M T W T F S
  12345
6789101112
13141516171819
2021222324 2526
27282930   

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags