Forum Invalid SQL when i want to see user profile
 

i get this error when i want to view an user profile:

Quote:
Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT album.*,
a.attachmentid, album.moderation,
fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail

FROM vb_album AS album
LEFT JOIN vb_attachment AS a ON (album.coverattachmentid = a.attachmentid)
LEFT JOIN vb_filedata AS fd ON (fd.filedataid = a.filedataid)

WHERE
album.userid = 4
AND
album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)

ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column 'fd.thumbnail_width' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 6th 2010 @ 09:48:52 PM
Error Date : Wednesday, January 6th 2010 @ 09:48:52 PM
Script : http://www.xxxxxx/foro/member.php/4-Carlos-Alberto
Referrer : http://wwwxxxx/foro/forum.php
IP Address : 190.31.84.238
Username : admin
Classname : vB_Database
MySQL Version : 5.0.85-community

how can i solve it? :confused: