[3.0]: "Field 'exdates' doesn't have a default value" when installing

[Oldiesmann]

Basic Information

When installing SMF 3.0 with MySQL 9.1, you are given an error message stating that some queries didn't execute properly, with a message of "Line #1606: Field 'exdates' doesn't have a default value". This is because the "exdates" field is defined as NOT NULL, but the INSERT query to add initial data to the calendar table doesn't attempt to insert anything in that field

Steps to reproduce

1. Try to install SMF 3.0 with MySQL 9.1 (default setup with WAMPServer in this case)

Expected result

Expect forum to install properly

Actual result

The following error/warning is given instead:

Version/Git revision

2eeafd1

Database Engine

MySQL

Database Version

9.1.0

PHP Version

8.4.2

Logs

No response

Additional Information

We need to either explicitly insert an empty string into that column, specify a default value or allow it to be NULL, though I don't know if SMF will handle NULL values.

[sbulen]

This one's a dupe, I think...

#8235

#8246