XF 2.1 Import Fails vb5 CLI

[Seeker-Smith]

This is the error I'm getting.

Starting import from vBulletin 5.x...
- Importing...
In AbstractStatement.php line 228:

MySQL statement prepare error [1270]: Illegal mix of collations (utf8_unico
de_ci,COERCIBLE), (utf8_unicode_ci,COERCIBLE), (latin1_bin,IMPLICIT) for op
eration 'concat'


xf:import [--processes PROCESSES] [--finalize]

Exception query:
SELECT
#CONCAT(u.id, '-node', n.parentid) AS attachmentid,
IF(u.filename IS NULL, CONCAT(u.id, '.', f.extension), u.filename) AS filename,
n.userid AS userid,
n.nodeid AS attachmentid,
n.oldid AS legacyid,
f.filedataid,
n.parentid AS postid,
n.nodeid,
f.dateline,
f.userid AS filedata_userid,
0 AS counter
FROM (
SELECT a.filedataid, a.nodeid,
IF (a.filename = '', NULL, a.filename) AS filename,
CONCAT('attach', a.nodeid) AS id
FROM attach AS a
UNION
SELECT p.filedataid, p.nodeid, NULL AS filename,
CONCAT('photo', p.filedataid) AS id
FROM photo AS p
) AS u
INNER JOIN filedata AS
f ON (f.filedataid = u.filedataid)
INNER JOIN node AS
n ON (n.nodeid = u.nodeid)
WHERE f.filedataid IN(2, 3, 4, 5, 6, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 66, 70, 71, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 124, 125, 126, 127, 128, 129, 130, 131, 132, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 151, 152, 154, 155, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251)
ORDER BY f.filedataid

 

[iCafe]

@Seeker-Smith ker

MySQL statement prepare error [1270]: Illegal mix of collations (utf8_unico
de_ci,COERCIBLE), (utf8_unicode_ci,COERCIBLE), (latin1_bin,IMPLICIT) for op
eration 'concat'

 

[Seeker-Smith]

SOLUTION
In case anyone needs it.
ALTER TABLE filedata MODIFY extension VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci;