Skip to content
Helge's blog
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx
  • bash
  • Linux
  • Mysql
  • Postgresql
  • Om oss
Search
Helge's blog
Close menu
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx
  • bash
  • Linux
  • Mysql
  • Postgresql
  • Om oss
Helge's blog
Search Toggle menu

Category: Mysql

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 […]

Recent Posts

  • Stream Twitch in a WordPress post
  • WordPress can be used for online courses
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs
  • Apache reverse-proxy to Nginx

Recent Comments

  • Dana Costea on Use openssl to encrypt secrets
  • Trst on Apache reverse-proxy to Nginx
  • صيانة مولينكس on Connect to windows remote desktop from linux mint
  • Fernando Castillo on Connect to windows remote desktop from linux mint
  • صيانة براون on Connect to windows remote desktop from linux mint

Recent Comments

  • Dana Costea on Use openssl to encrypt secrets
  • Trst on Apache reverse-proxy to Nginx
  • صيانة مولينكس on Connect to windows remote desktop from linux mint
  • Fernando Castillo on Connect to windows remote desktop from linux mint
  • صيانة براون on Connect to windows remote desktop from linux mint
© 2025 Helge's blog. Proudly powered by Sydney