• 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

#1
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?
 

Brogan

XenForo moderator
Staff member
#2
The threads which are imported without content/title, do they contain special characters or have anything in common?
 
#3
Probably has Å, Ä or Ö in them. The weird thing is that collations says UTF-8 as well as language on the db getting imported from.
 

Brogan

XenForo moderator
Staff member
#6
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
source:

collation_database utf8_general_ci
character_set_database utf8

destination
character_set_database utf8
collation_database utf8_general_ci

:(
 

Mike

XenForo developer
Staff member
#8
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".
 

Mike

XenForo developer
Staff member
#10
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.)
 

Mike

XenForo developer
Staff member
#12
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.