-
Notifications
You must be signed in to change notification settings - Fork 21
Open
Description
I had two unknown column errors importing from phpBB 3.1.4. I'm assuming they changed the table schema whilst upgrading.
The errors were in the topics table, with the field topic_approved missing, and in the posts table with the field post_approved missing. I fixed it by running these SQL commands..
ALTER TABLE phpbb_topics ADD topic_approved INT;
UPDATE phpbb_topics SET topic_approved = 0;
ALTER TABLE phpbb_posts ADD post_approved INT;
UPDATE phpbb_posts SET post_approved = 0;
Essentially I just created the missing columns, and set them to 0. Re-ran the import and it worked!
Metadata
Metadata
Assignees
Labels
No labels