While converting a website from single to multisite I bumped into an issue while creating accounts. When looking into the logs I noticed:
WordPress database error Unknown column ‘spam’ in ‘field list’ for query INSERT INTO
The issue is clear, i’m missing the ‘spam’ column in wp_users. Since i’m running this environment in Docker and I didn’t have easy database access available I wrote a wp-cli command fixing this issue;
Thanks to RJT for improving the script!