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 wp_users
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;
Hi Marinus,
I am facing the same issue in WordPress Bitnami Stack, how do I do this, is there is step by step guide, I’m not familiar with CLI of WP.
Thank you
Hi there – you can access your database and run the following command: ALTER TABLE wp_users ADD spam TINYINT
When I run that command, with root user, I receive the error:
“Invalid default value for ‘user_registered'”
Any thoughts?
Seems like something is wrong with the user_registered column in your table. I would have to have a look myself in order to give further advice. Feel free to reach out by email!
Thanks to your article, I solved my issue, thank you very much !
Happy to hear that!