[3.0]: "Invalid default value for 'expire_time'" when running upgrade.php

[Oldiesmann]

Basic Information

Attempting to run upgrade.php, at least from the shell, results in an "Invalid default value for 'expire_time'" error..

Steps to reproduce

1. Run php upgrade.php from the shell after making sure you're using the latest revision

Expected result

Upgrade runs successfully

Actual result

2026-03-19T00:24:51+00:00
Step 1: Login
Making sure SMF can write to "/srv/http/smf/Settings.php"... done.
Making sure SMF can write to "/srv/http/smf/Settings_bak.php"... done.
Making sure SMF can write to "/srv/http/smf/custom_avatar"... done.
Making sure SMF can write to "/srv/http/smf/cache/db_last_error.php"... done.
Step 2: Upgrade Options
Saving the following settings in the settings table: enable_sm_stats... done.
Step 4: Migrations
 +++ Add any missing functions (PostgreSQL)... skipped.
 +++ Converting MySQL tables to the InnoDB engine and dynamic rows... done.
 +++ Language Upgrade... done.
 +++ Setting default value for log_errors.session column... done.
 +++ Adding support for edit history... done.
 +++ Adding version information to posts and personal messages... done.
 +++ Adding SMF version information to log_packages... done.
 +++ Adding support for recurring events... done.
 +++ Migrating holidays to events... skipped.
 +++ Setting the UID column for calendar events... done.
 +++ Adding SpoofDetector support... done.
 +++ Improving search results storage... done.
 +++ Update mail_type... done.
 +++ Remove cookieTime setting... done.
 +++ Adjusting permissions... done.
 +++ Ensuring "uiq_admin_info_files" is structured correctly... done.
 +++ Ensuring "uiq_approval_queue" is structured correctly... done.
 +++ Ensuring "uiq_attachments" is structured correctly... done.
 +++ Ensuring "uiq_background_tasks" is structured correctly... done.
 +++ Ensuring "uiq_ban_groups" is structured correctly... Invalid default value for 'expire_time'[michael@michael-linux smf]$

Version/Git revision

8b9e91d

Database Engine

MySQL

Database Version

mariadb from 12.2.2-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1

PHP Version

8.5.4

Logs

Additional Information

I was able to successfully change that column from int(10) to bigint(20) from the command line, but the error persists afterwards. I'm assuming SMF is attempting to convert that null to a string.

[Sesquipedalian]

Hm. I can't reproduce this. Can you show us the CREATE TABLE statement for your database's copy of that table?