PHPBB 3.x Importer

marksoft

Hey after 5 years i finally decided to give flarum a try i dont know why its still in beta because 5 years seems to be enough time to get somehow stable even when many modules are community driven. But i am not here to blame i am here to step in so please let me know if y importer Script (Users / Topics / Posts) would be helpfull for you ? its at the moment at a beta phase but i used it to import my phpbb 3.3 with success i added also a slug function to my SQL Scripts and also some specials because for example i do not import private messages and i do not set users to moderators yet because i didn't understand how they are saved.
Maybe there is an dummy for an Flarum plugin i could asume the coding style and make it public at github

Again i am not here to blame it am here to help others to get a flarum running because i got the feeling phpbb is quite a non actual system at the moment.

greetings from vienna

luceos

marksoft i dont know why its still in beta because 5 years seems to be enough time to get somehow stable even when many modules are community drive

The people behind Flarum have had their own hardships. Since last year, much has changed and we're well on our way to release stable this year. If you'd like the history lesson feel free to check the "blog" tag here on discuss 👍️

marksoft so please let me know if y importer Script (Users / Topics / Posts) would be helpfull for you

Every importer is a great addition to the ecosystem. If you're willing to share, we'll gladly see your listing here on discuss under resources.

marksoft Maybe there is an dummy for an Flarum plugin i could asume the coding style and make it public at github

Different implementations for importers exist, I've open sourced a phpbb one (which still needs some work) not too long ago under https://github.com/Bokt/flarum-phpbb-migrate

marksoft greetings from vienna

Greetings from the Netherlands 👋

marksoft

hi i have 8.0.21 - MySQL Community Server - GPL and encounter problems with this select because MYSQL Chrashes with

Some pointers may be invalid and cause the dump to abort.

selectfl01_discussions.* fromfl01_discussionswhere (fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1) orfl01_perm_tags.is_restricted= 0) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1) orfl01_perm_tags.is_restricted= 0) orfl01_tags.parent_idis null))))) and (fl01_discussions.is_private= 0 or (((fl01_discussions.is_approved= 0 and (fl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))))))) and (fl01_discussions.hidden_atis null orfl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))) and (fl01_discussions.comment_count> 0 orfl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))) and not exists (select 1 fromfl01_discussion_userwherefl01_discussions.id=discussion_idanduser_id= 0 andsubscription= ignore) andfl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwhere 0 = 1) order bylast_posted_atdesc limit 21) union (selectfl01_discussions.* fromfl01_discussionswhere (fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1) orfl01_perm_tags.is_restricted= 0) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1) orfl01_perm_tags.is_restricted= 0) orfl01_tags.parent_idis null))))) and (fl01_discussions.is_private= 0 or (((fl01_discussions.is_approved= 0 and (fl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))))))) and (fl01_discussions.hidden_atis null orfl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))) and (fl01_discussions.comment_count> 0 orfl01_discussions.user_id= 0 or ((fl01_discussions.idnot in (selectdiscussion_idfromfl01_discussion_tagwheretag_idnot in (selectfl01_tags.idfromfl01_tagswhere (fl01_tags.idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) and (fl01_tags.parent_idin (selectfl01_perm_tags.idfromfl01_tagsasfl01_perm_tagswhere (fl01_perm_tags.is_restricted= 1 and 0 = 1)) orfl01_tags.parent_idis null))))) and exists (select * fromfl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))) andis_sticky= 1 limit 21) order by is_sticky and not exists (select 1 fromfl01_discussion_userasfl01_stickywherefl01_sticky.discussion_id=idandfl01_sticky.user_id= 0 andfl01_sticky.last_read_post_number>=last_post_number) and last_posted_at > 0 desc,last_posted_atdesc limit 21

ATTENTION AFTER UPDATE to 8.0.25 the bug no longer exists so it seems it was some MYSQL issue