KURTZ
01-21-2008, 06:07 PM
when i select Social Group Messages in my UCP i've the following error ...
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM nWmoderation AS moderation
INNER JOIN nWgroupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND type = 'groupmessage')
LEFT JOIN nWuser AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN nWsocialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN nWavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN nWcustomavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND moderation.dateline >= 1198343179
ORDER BY groupmessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Column: 'type' in on clause is ambiguous
Error Number : 1052
Date : Monday, January 21st 2008 @ 06:06:19 PM
Script : http://www.nowhine.net/board/moderation.php?do=viewgms&type=moderated
Referrer : http://www.nowhine.net/board/moderation.php?do=viewvms&type=moderated
IP Address : XXX.XXX.XXX.XXX
Username : ADMIN
Classname : vb_database
MySQL Version : 4.0.27-standard-log
someone can help me? Thx
PS. i've just updated my board @ Beta 4
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM nWmoderation AS moderation
INNER JOIN nWgroupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND type = 'groupmessage')
LEFT JOIN nWuser AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN nWsocialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN nWavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN nWcustomavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND moderation.dateline >= 1198343179
ORDER BY groupmessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Column: 'type' in on clause is ambiguous
Error Number : 1052
Date : Monday, January 21st 2008 @ 06:06:19 PM
Script : http://www.nowhine.net/board/moderation.php?do=viewgms&type=moderated
Referrer : http://www.nowhine.net/board/moderation.php?do=viewvms&type=moderated
IP Address : XXX.XXX.XXX.XXX
Username : ADMIN
Classname : vb_database
MySQL Version : 4.0.27-standard-log
someone can help me? Thx
PS. i've just updated my board @ Beta 4