I get the following error message in converting:
Converting personal messages (part 1)... Unsuccessful!
This query:INSERT IGNORE INTO `raumcon`.smf114_pm_recipients
(ID_PM, ID_MEMBER, labels, is_read)
SELECT pm.ID_PM, mem.ID_MEMBER, -1 AS labels, 1 AS is_read
FROM `raumcon`.smf114_personal_messages AS pm
INNER JOIN `raumcon`.smf114_convert AS c ON (c.real_id = pm.ID_PM)
INNER JOIN `raumcon`.smf114_members AS mem ON (mem.memberName = c.temp)
WHERE c.type = 'personal_messages'
AND pm.deletedBySender = 1;Caused the error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
I am trying to convert YaBB 2.2.1 to SMF 1.1.0 in this case. I got the same message when converting to SMF 1.1.4 or 1.1.8.