Seeker-Smith
Well-known member
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
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
Last edited:
