@nodeham said in Ready to give up on nodebb. nodebb-plugin-import phpbb:
ER_BAD_FIELD_ERROR: Unknown column 'phpbb_topics.topic_approved' in 'field list'
Hey, well, with no offense to that freelance developer but this error is clearly coming from the database, literally saying that a column does not exist.
I am 100% sure that whatever PHPBB version you are using is way past what the exporter supports, which is 6-7 years old.
Having said that, I am more than happy to help, basically what needs to be done is to upgrade the PHP exporter's support https://github.com/psychobunny/nodebb-plugin-import-phpbb which is possible, but we're going to need to look at the new database structure.
@NodeHam are you willing to share a PHPBB database dump with us? privately of course, and if it has sensitive information, I recommend obfuscating them, maybe just usernames, emails, names, dob, whatever else.... If you can't share the actual data, maybe an empty database so structure only, that usually works 99% of the time, but we can't fully test it without some sample data.