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

XF 1.2 Troubles importing from vB 4.x to XenForo

Discussion in 'Installation, Upgrade, and Import Support' started by Gramish, Aug 13, 2013.

  1. Gramish

    Gramish New Member

    I run a Swedish forum and when I try to import threads from vB to XF almost all threads end up without content/title. Could this be an encoding error? Anyone else had these troubles?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The threads which are imported without content/title, do they contain special characters or have anything in common?
     
  3. Gramish

    Gramish New Member

    Probably has Å, Ä or Ö in them. The weird thing is that collations says UTF-8 as well as language on the db getting imported from.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Which flavour of utf8?
     
  5. Gramish

    Gramish New Member

    utf8_general_ci collation
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Can you run these two queries on the source and destination databases?

    Code:
    show variables like "character_set_database";
    Code:
    show variables like "collation_database";
     
  7. Gramish

    Gramish New Member

    source:

    collation_database utf8_general_ci
    character_set_database utf8

    destination
    character_set_database utf8
    collation_database utf8_general_ci

    :(
     
  8. Mike

    Mike XenForo Developer Staff Member

    In vB, what character set does your default language have? If it's not UTF-8, when you start the import, force the character set to "latin1". If it is UTF-8, try forcing it to "utf8".
     
  9. Gramish

    Gramish New Member

    No luck unfortunately
     
  10. Mike

    Mike XenForo Developer Staff Member

    Can you confirm the collation of your vBulletin "post" table? (Run this query: SHOW CREATE TABLE post; You might need to add a table prefix.)

    Also, can you confirm what character set your default language in vBulletin is using? (Set via the control panel.)
     
  11. Gramish

    Gramish New Member

    DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci on post, should I try forcing utf8_swedish_ci? The character set is utf8.
     
  12. Mike

    Mike XenForo Developer Staff Member

    Are the individual columns utf8 as well? (Normally they would be, but they can be different.)

    Forcing the character set when starting the import to "utf8" should be sufficient then.

    If that still fails, I can try to debug it if you submit a ticket with FTP and admin CP details. I'd need you to start the import (insofar as entering the source details and getting to the step list). To debug quickly, if you can provide the ID of a thread whose title ends up blank (the ID of it in vBulletin), that'd help. I can then test directly against that.
     

Share This Page