2.0.14 with apache 2.4 and php 7

[usergroup]

We have the following arrow on the Regirtration page.

Database Error
Field 'im_ignore_list' doesn't have a default value
File: /usr/share/smfv2/Sources/Subs-Members.php
Line: 771

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.14, while your database is at version 2.0.9. The above error might possibly go away if you execute the latest version of upgrade.php.

upgrade.php is blank

[Paulo.chon]

HI,

Look at your Database.

A table seems to be in error.

[usergroup]

All Tables checked, Status OK.

[vbgamer45]

You will need to alter the im_ignore_list filed in your database and provide a default or make so it can be null. You can do so in phpmyadmin just find the table then in the structure look for that field and modify it.

[Kindred]

While vbgamer has one correct resolution...  the actual issue is not with your php or OS... it's with your mySQL version.
Apparently, they made a bug in certain mySQL versions which caused this error (google it)

The solution is to upgrade to a more recent version of mySQL

[Arantor]

Eh? This is more likely on more recent versions of MySQL because the trend in MySQL is to be more to the SQL spec and more strict than not.

This looks like NO_TRANS_TABLES is set in the sql_mode, something a shared host isn't going to want to change, and the correct solution is to modify the database structure to have a default.