Skip to main content

MySQL Lock Wait Timeout Exceeded Error in InnoDB Tables – How to fix it

Today I was installing the latest (at the time of writing) MediaWiki build, which is 1.27.1, to a customer, together with all the bundled plugins and add-ins, following more or less the same steps i described here (installing within IIS), here (install WikiEditor) and also here (import Wikipedia templates). Needless to say, I did everything using the main administrator account, which gets created during the MediaWiki installation phase. As usual, I also created the database using InnoDB tables, the new MySQL engine which supports table and row-based locking and is also suggested by MediaWiki as the proper choice for performance and reliability.

After doing all that, just like I did a number of other times, I moved to the special pages and I started to create the other users… And there, right after POSTing the first new user form, I was greeted by a strange (and rather obscure) HTTP Error 500.

Read More

How to import Wikipedia Templates into your own MediaWiki

If you stumbled upon this post, chances are you just installed your very own MediaWiki and want to make it prettier. That’s completely understandable since the default MediaWiki installation, with its starting set of starting extensions, modules and templates, isn’t that fancy: you can do titles/headers, make your text bold and/or italic, create wikilinks and hyperlinks and that’s about all.

Owning your very own MediaWiki is fun, but if you’ve choose MediaWiki over the other great alternatives out there – such as TikiWiki, for example – it means that you want it to look just as fine as Wikipedia – or any other professional-looking wiki – actually does. In order to do that, you will have to install quite a number of additional stuff. This article, as well as many others I’ll be publishing during the next weeks, will teach you how to do that.

Read More

SyntaxHighlight_GeSHI extension ‘ProcessBuilder not found’ issue after upgrading to MediaWiki 1.26.2 (or above)

One of the biggest update introduced with MediaWiki build 1.26.2 and above is the extensive use of Composer, a dependency manager for PHP: in short words, Composer is something very close to what NPM is for Node.js, meaning that it can be used to automatically fetch, update and mantain the package dependencies for your project, keeping them up-to-date. However, instead of storing them within a global folder, it will manage the packages on a per-project basis, installing them in a directory (e.g. vendor) that will be added to each specific project. This is the perfect cup of tea for any seasoned Linux system administrator, yet it can be quite hard to understand for those used to work on Windows servers.

We’ll talk more about the interactions between Composer and the latest MediaWiki builds in an upcoming article: for now we’ll address a very specific issue regarding how we can use Compose to fix a bug with the SyntaxHighlight extension, formerly known as SyntaxHighlight_GeSHI  (click here for more info) that will often happen after upgrading a MediaWiki installation to 1.26.2 or above (including 1.27).

Read More

MediaWiki and IIS redirect loop issue: how to fix it

If you’ve stumbled upon this post, it means that you ran into a common issue happening right after installing/upgrading to MediaWiki build 1.26.2 (and above) under a Windows/IIS environment. The problem arises everytime you try to request a URL containing special characters, such as colon or ampersand: the browser will try to load the page for 20-30 seconds, then it will timeout with a redirect loop error like the following:

This Webpage has a redirect loop

Error 310


… and so on. Since all MediaWiki‘s special pages contains at least a colon, this will most likely prevent you from running any of them.

Read More