Announcement

Collapse
No announcement yet.

Whats this database error?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Whats this database error?

    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.

    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;
    Last edited by paintballer.ie; Fri 9th Jul '10, 5:28am.
    The Paintball Resource

    Critic My site HERE

  • #2
    Hello,

    Could you please add the full SQL error?. And please try to post in the correct forum for your vBulletin version.
    Andrés Durán Hewitt

    Comment

    Related Topics

    Collapse

    Working...
    X