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

XF 1.1 Importing problems from vBulletin 4

Discussion in 'Installation, Upgrade, and Import Support' started by Sean James, Mar 8, 2012.

  1. Sean James

    Sean James Well-Known Member

    I am trying to convert a vBulletin 4.1.11 board to XenForo 1.1.2.

    I tried Paul M's importer first which is no longer supported but it would halt on importing Blogs which then stopped me from importing attachments.

    I am now trying this one:
    http://xenforo.com/community/threads/vbulletin-4-to-xenforo-importer.27758/

    I am having a problem when importing users:

    I am thinking this might be caused by mySQL version?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Sean James likes this.
  3. Sean James

    Sean James Well-Known Member

  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This line number doesn't match for me. Can you confirm that you are running XF 1.1.2? Or maybe some of the files are bad.

    Confirm your version and run a file check:

    Admin CP -> Tools -> File Health Check
     
  5. Sean James

    Sean James Well-Known Member

    Hey Jake, thanks for taking the time to help mate.

    When I run the file check i get this, this is a clean install of 1.1.2

    I am using the latest version of the importer.
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Oh I see that importer package has you overwrite that file.

    I found the relevant code in the modified importer. I don't see any obvious problems to explain the error.

    I would like to know the complete query that is generating the error, but unfortunately the log you posted only shows part of the query. If you would like to give me FTP and admin access then I can debug the error to see what is going on.
     
  7. Sean James

    Sean James Well-Known Member

    Hey Jake sending you a private message mate.
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I pulled the exact query that is returning the syntax error. The query is fine. It runs on my own vB database without error.

    I think your hunch was correct. I think it's your MySQL configuration.
     
  9. Sean James

    Sean James Well-Known Member

    Thanks mate, much appreciated ;)

    I will contact the server host and see if they can tell what the problem might be.
     
  10. Sean James

    Sean James Well-Known Member

    The vBulletin database is running on 4.1 and the new XenForo one is 5.0, could this also be a problem?

    Host also says I should create a php5.ini file as this might fix the problem.

     
  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Possibly. Though I don't see anything about the query that I recognize as being exclusive to MySQL5. But that query is being run against the vB database, not the XF database.
     

Share This Page