Skip to content
Helge's blog

Helge's blog

  • Home
  • Unix commands

Category: Mysql

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

14 September, 2021 Helge Mysql, PHP Leave a comment

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

Continue reading

Mysql / Mariadb performance test

21 June, 2017 Helge Mysql Leave a comment

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

Continue reading

Upgrade Moodle 2.2.1 to 2.6.2+

25 March, 2014 Admin Moodle, Mysql Leave a comment

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

Continue reading

Mysql SQL in bash one-liner

14 February, 2014 Helge bash, Linux, Mysql Leave a comment

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

Continue reading

Finding spam users

31 October, 2013 Helge bash, Mysql, Wordpress Leave a comment

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

Continue reading

Alert Blog Admin php script

25 October, 2012 Helge Mail, Mysql, PHP, Wordpress One comment

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

Continue reading

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

Categories

  • Apache
  • bash
  • Cygwin
  • Database
  • Docs
  • Editor
  • Education
  • Email
  • Firewall
  • Git
  • Imap
  • Landscapes
  • Ldap
  • Linux
  • Mail
  • Me "blogging"
  • Mediawiki
  • Moodle
  • Mysql
  • Online courses
  • Open source
  • Perl
  • PHP
  • Postgresql
  • Science
  • Security
  • Stream
  • Technology
  • UiB
  • Uncategorized
  • Version control
  • Video
  • Virtual server
  • Windows
  • Wordpress
  • Wordpress plugin
  • zsh
WordPress Theme: Tortuga by ThemeZee.