edit... its actually vb3.8 the error is from
I get this error every few hours via email. Not sure what it is about. Something to do with the album anyways.
I get this error every few hours via email. Not sure what it is about. Something to do with the album anyways.
valid SQL:
SELECT user.userid, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
albumpicture.dateline, picture.pictureid, picture.userid, picture.extension,
picture.idhash, picture.thumbnail_filesize, picture.caption AS caption,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
album.albumid AS albumid, album.title AS albumstitle
FROM vb_albumpicture AS albumpicture
INNER JOIN vb_picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vb_album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN vb_user AS user ON(user.userid = album.userid)
LEFT JOIN vb_userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '0' AND userlist.type = 'buddy')
WHERE (album.state = 'public' OR (NOT ISNULL(userlist.relationid) AND album.state = 'private'))
ORDER BY RAND()
LIMIT 0, 2;
SELECT user.userid, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
albumpicture.dateline, picture.pictureid, picture.userid, picture.extension,
picture.idhash, picture.thumbnail_filesize, picture.caption AS caption,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
album.albumid AS albumid, album.title AS albumstitle
FROM vb_albumpicture AS albumpicture
INNER JOIN vb_picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vb_album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN vb_user AS user ON(user.userid = album.userid)
LEFT JOIN vb_userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '0' AND userlist.type = 'buddy')
WHERE (album.state = 'public' OR (NOT ISNULL(userlist.relationid) AND album.state = 'private'))
ORDER BY RAND()
LIMIT 0, 2;
Comment