
24-01-2008, 21:28
|
 | Moderador | | Registrado em: Jul 2007 Localização: Em Casa Idade: 18
Posts: 1,165
Agradecimentos: 342
Agradecido 476 vez em 192 Posts
Peso da Avaliação
: 13 | |
Erro no upgrade
unico errinho. que apareceu quando fiz o Upgrade. de versão. Mensagens de Grupos Sociais Citação:
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.wi dth AS avwidth,customavatar.height AS avheight
FROM vb_deletionlog AS deletionlog
INNER JOIN vb_groupmessage AS groupmessage ON (deletionlog.primaryid = groupmessage.gmid AND type = 'groupmessage')
LEFT JOIN vb_user AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN vb_socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND deletionlog.dateline >= 1198628733
ORDER BY groupmessage.dateline DESC
LIMIT 0, 10;
MySQL Error : Column 'type' in on clause is ambiguous
Error Number : 1052
Date : Thursday, January 24th 2008 @ 10:25:33 PM
Script : http://www.theevolution.org/moderati...s&type=deleted
Referrer : http://www.theevolution.org/usercp.php
IP Address : 201.14.21.239
Username : lordozzy3112
Classname : vB_Database
MySQL Version : 4.1.22-standard
|
__________________
Melhor Jeito de aprender vbulletin. clica aqui Suporte Por MSN ou MP. NEM PENSA.  |