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

XF 1.2 Importer - Problem with "users"

Discussion in 'Installation, Upgrade, and Import Support' started by Richey, Aug 20, 2013.

  1. Richey

    Richey Member

    Hello xenForo Community,

    I switched from IPB to xenForo and try to import my IPB 3.4.5 data into xenForo 1.2.

    Now there is an error when importing the users. I have about 800 users but xenForo only imports 45 of them (without displaying errors). All of them are validated and in the same member-group.

    Can someone please help me?

    Kind regards,
    Richey.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Is the 45 figure what you see in the front end or actually in the users list in the ACP?
     
    satchi22 likes this.
  3. Richey

    Richey Member

    Hi Brogan,

    there are only 45 users in the front end, the acp and in the MySQL-table, so xenForo definitely imported only 45 entries.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Is there anything unusual about the 750+ users who weren't imported?
    Anything in common between them?
     
  5. Richey

    Richey Member

    No Brogan, I can't find any problems or differences regarding the other users.
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    And these are all valid, active members on your IPB forum currently?
    Can you link to a few of the ones which weren't imported?
     
  7. Richey

    Richey Member

    Yes. But not all of them are active in the last time. And I just noticed in the MySQL table that the most of the "not imported users" have no entry in the "last_post/last_visit" columns. I will fix this and tell you if it works.
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Was this an import from different software previously?
    I am wondering how that data is missing as there should always be a last post/visit time and date no matter how long ago it is.

    Although admittedly I have no knowledge of IPB or how it works, so this could be standard functionality, but it seems unlikely.
     
  9. Richey

    Richey Member

    Yes, there was a different software in the past.
    But I can't find differences between the imported table rows and the non-imported (in the IPB database).
     
    satchi22 likes this.
  10. Brogan

    Brogan XenForo Moderator Staff Member

    It sounds like incomplete data in the IPB database (possibly due to the previous import) is causing the records to not be imported.
    As borne out by the fact that there is no data in some of the fields.
     
    Richey and satchi22 like this.
  11. Richey

    Richey Member

    I think you are right (n)
    I will go on searching and tell you if I find the "mistake/bug/error/..."
     
  12. Richey

    Richey Member

    OMG, I found the "problem". The IPB database has a table called "pfields_content". IPB stores the content of profile fields there. There are only 45 entries ... don't ask me why ;) I only had to create the missing rows for the other members with a mysql script. That's it.

    And thank you for your help @Brogan !
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    I'll flag this to @Mike just in case.

    I don't know anything about the IPB schema so have no idea if it's normal for users not to have a record in that table.

    If it is then the XF importer can be updated to take that into account.
     
  14. Mike

    Mike XenForo Developer Staff Member

    I've tweaked the code, but I suspect all users should have a record in that table.
     
    Brogan likes this.

Share This Page