We need to detect SQL strict mode and warn the user!

[jegelstaff]

As of MySQL 5.7, MariaDB 10.2.4, Strict mode is the default in MySQL (STRICT_TRANS_TABLES, and some other setting(s) indicate this is on when you query for the modes). We need to check this as part of every admin page load and tell the users, like the DB patch process that comes up automatically. We can try to fix it, but possibly the user doesn't have rights to alter the mode, and it would come back incorrectly on startup most likely, so should always be fixed by a DB admin.

[jegelstaff]

We can also detect and use INSERT IGNORE and UPDATE IGNORE.

[jegelstaff]

More info: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-strict