Hello, I currently run a very heavily modified, but small SMF forum with around 20 active users. We basically use the forum more as an information store than a discussion platform, so would rather we be able to keep all posts. User accounts seem painless enough to set up and I presume there's a way to reattribute posts at a later point anyway.
I have found this conversion script - https://github.com/ItalianSpaceAstronauticsAssociation/smf2_to_flarum which I have tried to run (with modifications to update the newer table names), however my knowledge of SQL and in particular PHP is rudimentary at best, and while it did show all the posts (but only 16 out of 112 users, interestingly, which the script believed to be the total amount) the actual import failed with foreign key errors.
I'm not really sure where to go next from here, I believe there is some way to disable foreign key checks but I have no idea how I'd go about it, or if I do it in the php script, phpMyAdmin or even command line of the database itself. Any assistance would be greatly appreciated!
Error messages for every single post/topic are;
Cannot add or update a child row: a foreign key constraint fails (`database_name`.`discussions`, CONSTRAINT `discussions_first_post_id_foreign` FOREIGN KEY (`first_post_id`) REFERENCES `posts` (`id`) ON DELETE SET NULL)
Cannot add or update a child row: a foreign key constraint fails (`database_name`.`posts`, CONSTRAINT `posts_discussion_id_foreign` FOREIGN KEY (`discussion_id`) REFERENCES `discussions` (`id`) ON DELETE CASCADE)