14 September, 202119 October, 2021Mysql, PHP 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 […]
21 June, 20175 April, 2018Mysql Mysql / Mariadb performance test I have two different Linux servers, and wanted to test if one where faster than the other. I used mysqlslap together with […]
25 March, 201423 May, 2014Moodle, Mysql Upgrade Moodle 2.2.1 to 2.6.2+ 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 […]
14 February, 201411 December, 2017bash, Linux, Mysql Mysql SQL in bash one-liner If you just need a quick way to get some data from a mysql database in your shell (bash), you could do […]
31 October, 201314 February, 2014bash, Mysql, Wordpress Finding spam users We had a lot of spam users in our multisite wordpress system. This was because we had self-registration enabled for a period. […]
25 October, 20129 October, 2017Mail, Mysql, PHP, Wordpress Alert Blog Admin php script I had to send emails to all the Blog admins in our WordPress Multisite installation. This is how I did it: [code […]