Tyran
22.01.2008, 15:07
... bei "Gruppen Nachrichten" im Kontrollzentrum.
Ist das nen Bug ??
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
,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 deletionlog AS deletionlog
INNER JOIN groupmessage AS groupmessage ON (deletionlog.primaryid = groupmessage.gmid AND type = 'groupmessage')
LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND deletionlog.dateline >= 1198418703
ORDER BY groupmessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Column: 'type' in on clause is ambiguous
Error Number : 1052
Date : Tuesday, January 22nd 2008 @ 03:05:03 PM
Script : moderation.php?do=viewgms&type=deleted
Referrer : moderation.php?do=viewvms&type=moderated
IP Address : -
Username : Administrator
Classname : vb_database
MySQL Version : 4.0.21
Ist das nen Bug ??
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
,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 deletionlog AS deletionlog
INNER JOIN groupmessage AS groupmessage ON (deletionlog.primaryid = groupmessage.gmid AND type = 'groupmessage')
LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND deletionlog.dateline >= 1198418703
ORDER BY groupmessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Column: 'type' in on clause is ambiguous
Error Number : 1052
Date : Tuesday, January 22nd 2008 @ 03:05:03 PM
Script : moderation.php?do=viewgms&type=deleted
Referrer : moderation.php?do=viewvms&type=moderated
IP Address : -
Username : Administrator
Classname : vb_database
MySQL Version : 4.0.21