Monthly Archives: October 2015

Converting unsigned to signed integers (using Powershell or Excel)

Let’s assume you got unsigned 32 bit integers, that actually represent 32 bit signed integers (using 2’s complement). How to get back the original (negative) values? The formula is pretty easy: signed = (raw+2^31) % 2^32 – 2^31 In Excel: … Continue reading

Posted in Uncategorized | Leave a comment

MediaWiki: Search for page content directly in the database with SQL

To search text in the last revision of MediaWiki pages directly in the database with (My)SQL, use the following request: This may be useful for instance to find pages which are using a deprecated plugin.

Posted in Uncategorized | Leave a comment

Zimbra: How to delete read-only events from a calendar

Today I needed to delete all the events from a calendar in Zimbra. It seemed straight-forward: open the calendar switch to the list view set appropriate start date and end dates select all hit “Delete” Unfortunately, Zimbra refused to proceed, … Continue reading

Posted in Uncategorized | Leave a comment