[frenckomegl]

here:

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

FROM my_album AS album
LEFT JOIN my_picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

WHERE album.userid = 1
AND album.state IN ('public', 'private', 'profile')


ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column 'album.coverpictureid' in 'on clause'
Error Number : 1054
Request Date : Saturday, September 4th 2010 @ 06:50:40 PM
Error Date : Saturday, September 4th 2010 @ 06:50:40 PM
Script : http://habbofrizz.altervista.org/forum/member.php?u=1
Referrer : http://habbofrizz.altervista.org/forum/index.php
IP Address :
Username : ReFrenck
Classname : vB_Database
MySQL Version : 4.1.22-standard-log