![]() |
Forum Whats this database error? I get this error every few hours via email. Not sure what it is about. Something to do with the album anyways. Quote: 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; |
| الساعة الآن 02:00 PM |
Powered by vBulletin® Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir