Problema con la DB en mensajes de visita

playbye · 17 Sep 2008

Hola tengo un problema con la DB en los mensajes de visita, al ir a avanzado sale este mensaje de error:

PHP:

Database error in vBulletin 3.7.3:

Invalid SQL:

            (
                SELECT
                    visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress
                    ,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
                    ,ame_flag
                FROM visitormessage AS visitormessage
                LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                LEFT JOIN deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
                
                WHERE visitormessage.userid = 132 AND visitormessage.postuserid = 1 AND visitormessage.state IN ('visible','moderation','deleted')
                
            )
            UNION
            (
                SELECT
                    visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress
                    ,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 visitormessage AS visitormessage
                LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                LEFT JOIN deletionlog AS deletionlog ON (visitormessage.vmid = deletionlog.primaryid AND deletionlog.type = 'visitormessage')
                
                WHERE visitormessage.userid = 1 AND visitormessage.postuserid = 132 AND visitormessage.state IN ('visible','moderation','deleted')
                
            )
            ORDER BY pmdateline DESC;

MySQL Error   : The used SELECT statements have a different number of columns
Error Number  : 1222
Request Date  : Wednesday, September 17th 2008 @ 12:34:19 PM
Error Date    : Wednesday, September 17th 2008 @ 12:34:19 PM
Script        : http://charlyallstar.com/vbulletin/visitormessage.php?do=message
Referrer      : http://charlyallstar.com/vbulletin/member.php?u=132
IP Address    : 201.132.102.163
Username      : Charly
Classname     : vB_Database
MySQL Version : 5.0.51a-community

Espero y me puedan auxiliar.

Gracias!!

Problema con la DB en mensajes de visita

playbye