MediaWiki Upgrade, but One Thing Didn’t Work

closeThis post was published 13 years 4 months 3 days ago. A number of changes have been made to the site since then, so please contact me if anything is broken or seems wrong.

I upgraded MediaWiki from 1.9.3 to 1.10.0 on May 10. I like the new features. Only problem: page restrictions were moved from a column in the page table to a separate table in the upgrade. The upgrade script, though this will be fixed in a later release, made `wikidb.page_restrictions.pr_expiry` equal to NULL instead of “infinity”. Problem? Shouldn’t be ordinarily, but Special:Protectedpages didn’t work; the entries from pre-1.10.0 didn’t display. I just changed them all manually using phpMyAdmin, but it’s fortunate I have a small wiki. Maybe I should learn SQL to cope with possible future errors…


I am an avid technology and software user, in addition to being reasonably well-versed in CSS, JavaScript, HTML, PHP, Python, and (though it still scares me) Perl. Aside from my technological tendencies, I am also a theatre technician, sound designer, violinist, singer, and actor.

Leave a Reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail (or subscribe without commenting)

Comments are subject to moderation, and are licensed for display in perpetuity once posted. Learn more.