1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Conversion from phpbb3.1

Discussion in 'Installation, Upgrade, and Import Support' started by MattiGB, Jul 7, 2015.

  1. MattiGB

    MattiGB Member

    Hi
    I realy love xenforo project and I want to move from my phpbb3.1 board. Is there any tutorial how to convert my database from phpbb3.1 to xenforo?
    Phpbb3.1 is different than phpbb3 so please dont link me old tutorials.
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    There isn't any specific tutorials as the process is mostly the same regardless of the source forum.

    You can see the general gist here:
    Importing | XenForo

    I don't recall when PHPBB 3.1 was released. We haven't yet had any reports of the existing PHPBB 3.0 importer not working, though it would be recommended to test the import on test data first before committing to it on your live data.
     
  3. Chris D

    Chris D XenForo Developer Staff Member

    We don't not support it, if that makes sense.

    It really depends how much the schema changed between 3.0 and 3.1.

    We haven't yet had any feedback to say it doesn't work, but it hasn't been tested either. If you run into any issues @MattiGB then let us know :)
     
  4. Daniel Hood

    Daniel Hood Well-Known Member

    Cause, who needs backwards compatibility?
     
  5. MattiGB

    MattiGB Member

    Thank you for your answers. I am realy sad that there is no official solution for this problem :(
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    To the best of our knowledge, there isn't a problem.

    If you experience issues, support will be provided.
     
  7. Mike

    Mike XenForo Developer Staff Member

    I do vaguely recall someone mentioning problems importing from phpBB 3.1, but we haven't really had many questions about it. The importer has currently only been tested with 3.0.
     
  8. MattiGB

    MattiGB Member

    Ok I used phpbb3.0 importer. There is one problem, I don't see any counters of posts. All topics and posts are hidden for normal users (admin can see them). How can I fix it?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    You may need to rebuild the caches for the counters.

    The second issue is likely related to permissions.
    You will need to check all user group permissions.
    There's a link to a guide in my signature.
     
  10. MattiGB

    MattiGB Member

    After I accept one post to be visible to other users I get error:
    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 44 bytes) in forum/library/Zend/Db/Statement/Mysqli.php on line 304
     
  11. Mike

    Mike XenForo Developer Staff Member

    We did a bit more looking into it last night and there are a fair number of changes, notably surrounding some of the issues you've run into -- the big one will be post and thread states. This is really something that can only properly be addressed with a new importer to support the changes.
     
  12. MattiGB

    MattiGB Member

    @Mike but I see that all topics, posts and users are in database. The problem is with approving them to be visible for other users. Is there any quick fix?
     
  13. Mike

    Mike XenForo Developer Staff Member

    You can try setting the discussion_state and message_state values in the thread and post tables to "visible" (and emptying xf_moderation_queue).
     
  14. MattiGB

    MattiGB Member

    @Mike how can I do it? Is it in my admin control panel?
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    You would need to do it in something like phpMyAdmin.
     
  16. MattiGB

    MattiGB Member

    Can you give me sql querry for this? It would be very helpful :)
     
  17. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_thread SET discussion_state = 'visible';
    
    UPDATE xf_post SET message_state = 'visible';
    
    TRUNCATE table xf_moderation_queue;
    Be aware that will make all threads and posts visible.
    You may want to add WHERE clauses to only change those which aren't deleted.

    So that would be these queries instead:
    Code:
    UPDATE xf_thread SET discussion_state = 'visible' WHERE discussion_state = 'moderated';
    
    UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated';
    
    TRUNCATE table xf_moderation_queue;
     
  18. MattiGB

    MattiGB Member

    Ok it works. Other issue is that the counters don't work. Where I can rebuild counter?
     
  19. Mike

    Mike XenForo Developer Staff Member

    Tools > Rebuild caches
     
  20. Daniel Hood

    Daniel Hood Well-Known Member

    /admin.php?tools/rebuild

    Rebuild Thread Information, Rebuild Forum Information
     

Share This Page