XF 1.2 Troubles importing from vB 4.x to XenForo

[Gramish]

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?

 

[Paul B]

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

 

[Gramish]

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

 

[Paul B]

Which flavour of utf8?

 

[Gramish]

utf8_general_ci collation

 

[Paul B]

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

show variables like "character_set_database";

show variables like "collation_database";

 

[Gramish]

source:

collation_database utf8_general_ci
character_set_database utf8

destination
character_set_database utf8
collation_database utf8_general_ci

 

[Mike]

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".

 

[Gramish]

No luck unfortunately

 

[Mike]

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.)

 

[Gramish]

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

 

[Mike]

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.