• Dev

  • PHPBB 3.x Importer

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

    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 👋

            a year later

            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 *
            from            fl01_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 *
            from            fl01_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 *
            from            fl01_tagsinner joinfl01_discussion_tagonfl01_tags.id=fl01_discussion_tag.tag_idwherefl01_discussions.id=fl01_discussion_tag.discussion_id))) and not exists (select 1
            from            fl01_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.*
            from            fl01_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 *
            from            fl01_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 *
            from            fl01_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 *
            from            fl01_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
            from            fl01_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