Database – Helge's blog

Machform error: Cardinality violation: 1242 Subquery returns more than 1 row

We have a multiuser Machform PHP application running on a Redhat 7 Linux server with Apache webserver and MariaDB database. In a […]

I have two different Linux servers, and wanted to test if one where faster than the other. I used mysqlslap together with […]

We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120 unique wiki’s, […]

We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication you can […]

I upgraded our Open Journal Systems from 2.2.2 to 2.4.2 and afterwards we saw the email logs were gone. This was related […]

I tried to upgrade Moodle 2.2.1 to 2.6.2+ and got this error message: Default exception handler: DDL sql execution error Debug: Data […]

We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with the name: […]