DiJaexxl
24.05.2008, 09:04
Hallo,
ich bekomme so 12 mal am Tag diesen Datenbankfehler, seit ich auf die 3.7 Version umgerüstet habe.
Datenbankfehler in vBulletin 3.7.0:
Invalid SQL:
(
SELECT
visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
,0 AS del_userid, '' AS del_username, '' AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_visitormessage AS visitormessage
LEFT JOIN vb3_user AS user ON (visitormessage.postuserid = user.userid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE visitormessage.userid = 2198 AND visitormessage.postuserid = 1000 AND visitormessage.state IN ('visible','moderation')
)
UNION
(
SELECT
visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_visitormessage AS visitormessage
LEFT JOIN vb3_user AS user ON (visitormessage.postuserid = user.userid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb3_deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
WHERE visitormessage.userid = 1000 AND visitormessage.postuserid = 2198 AND visitormessage.state IN ('visible','moderation','deleted')
)
ORDER BY pmdateline DESC
LIMIT 0, 10;
MySQL-Fehler : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Fehler-Nr. : 1267
Fehler-Zeit : Friday, 23.05.2008 @ 16:06:22
Datum : Friday, 23.05.2008 @ 16:06:22
Skript : http://www.cbf-1000.de/VBForum/converse.php?u=2198&u2=1000
Referrer : http://www.cbf-1000.de/VBForum/member.php?u=2198
Klassenname : vB_Database
MySQL-Version :
Hat einer eine Idee. Ich denke nicht, das es sich um ein Add on handelt
ich bekomme so 12 mal am Tag diesen Datenbankfehler, seit ich auf die 3.7 Version umgerüstet habe.
Datenbankfehler in vBulletin 3.7.0:
Invalid SQL:
(
SELECT
visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
,0 AS del_userid, '' AS del_username, '' AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_visitormessage AS visitormessage
LEFT JOIN vb3_user AS user ON (visitormessage.postuserid = user.userid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE visitormessage.userid = 2198 AND visitormessage.postuserid = 1000 AND visitormessage.state IN ('visible','moderation')
)
UNION
(
SELECT
visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_visitormessage AS visitormessage
LEFT JOIN vb3_user AS user ON (visitormessage.postuserid = user.userid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb3_deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
WHERE visitormessage.userid = 1000 AND visitormessage.postuserid = 2198 AND visitormessage.state IN ('visible','moderation','deleted')
)
ORDER BY pmdateline DESC
LIMIT 0, 10;
MySQL-Fehler : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Fehler-Nr. : 1267
Fehler-Zeit : Friday, 23.05.2008 @ 16:06:22
Datum : Friday, 23.05.2008 @ 16:06:22
Skript : http://www.cbf-1000.de/VBForum/converse.php?u=2198&u2=1000
Referrer : http://www.cbf-1000.de/VBForum/member.php?u=2198
Klassenname : vB_Database
MySQL-Version :
Hat einer eine Idee. Ich denke nicht, das es sich um ein Add on handelt