Tag: MySQL

MediaWiki problems with MySQL VARBINARY padding

I have been wanting to protect a certain page on my Dutch 15Monkeys wiki for weeks. I could install the ReCaptcha extension already (the best Captcha there is), but it's just that one page that's being spammed. So far, I've been unsuccessful in regaining my Sysop right for that wiki. I need these rights if I'm going to protect these pages. Read More »
By Rowan Rodrik, 3 years ago, on March 09, 2009, at 14:03 | 2 comments

Lost my Sysop rights in the 15Monkeys wikis

I am constantly bugged by spammers in my 15 Monkeys wiki farm[1, 2], but I wasn't allowed to protect the victim pages anymore. So, I wondered where my Sysop rights had gone. Read More »
By Rowan Rodrik, 3 years ago, on February 04, 2009, at 20:02 | 1 comment

Images not showing after upgrade to MediaWiki 1.13

When I upgraded two of my MediaWiki installations[1, 2] a while ago, images were no longer being displayed. I found out that this was due to some problem with a change to the image.image_name column. Read More »
By Rowan Rodrik, 3 years ago, on December 27, 2008, at 19:12 | 1 comment

Purging a MySQL database without losing meta data

When I clone a production database to a development database, I always need to empty the development database first. I could never find an SQL command to completely purge a database, bur, recently, I learned something about MySQL that surprised me: MySQL doesn't lose the user rights for a database when you drop it. So, purging a MySQL database (without losing any access data meta data about that DB) is as simple as issuing the following statements: Read More »
By Rowan Rodrik, 4 years ago, on July 12, 2008, at 01:07 | No comments