No announcement yet.

Changed Forum permissions for guests, receive SQL Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Changed Forum permissions for guests, receive SQL Error

    I changed the forum permissions so guests could see threads but not view the content, when logging out and checking this I receive a database error on any of the forums I dissallowed, Unregistered/Not Logged In Users

    The Error is as follows:

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,

    FROM thread AS thread

    WHERE thread.threadid IN (0,824,823,710,693)
    ORDER BY sticky DESC, thread.lastpost DESC;

    MySQL Error : Unknown table 'post' in field list
    Error Number : 1109
    Date : Tuesday, January 24th 2006 @ 06:07:14 AM
    Script : *Removed*
    Referrer : *Removed*
    IP Address : **.***.***.***
    Username : Unregistered
    Classname : vb_database

    Thanks in advance for your support

  • #2
    re upload the script that gives the error and disable all plugins and test again.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.