Skip to content

Update spamblock query to work in MySQL 5.7+ with default "strict" mode

onli requested to merge github/fork/fasterit/update-spamblock-for-mysql-5.7 into master

Created by: fasterit

The old query will fail with ONLY_FULL_GROUP_BY set which is default from MySQL 5.7.5 onwards. This results in the .htaccess file not being updated.

Also adding some fencing to the foreach to prevent php error messages.

Cf. https://board.s9y.org/viewtopic.php?f=11&t=24753

Merge request reports