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.

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

We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120

We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication

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

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

We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with

If you just need a quick way to get some data from a mysql database in your shell (bash), you

We had a lot of spam users in our multisite wordpress system. This was because we had self-registration enabled for

I had to send emails to all the Blog admins in our WordPress Multisite installation. This is how I did

I’ve wrote a simple bash script to dump databases from a Postgresql 8.1 database server which uses the pg_dump and