FUDforum: Bug Reports » moderation error

Home » FUDforum Development » Bug Reports » moderation error

Show: Today's Messages :: Polls :: Message Navigator

moderation error [message #2885]

Tue, 04 June 2002 11:06

tufan

Messages: 70
Registered: June 2002

Karma: 0

Member

There is a small bug in the script.

When reading the thread in the tree view in a moderated forum, UNAPPROVED messages appear as a link (though they shouldn't appear), but when clicked, a database error occurs...

This is due to a small bug in the sql query.

You can correct it by editing forum/template/src/tree.php.t

--- FIND (around line 156) -----
WHERE
thread_id=".$th." ORDER BY id");

--- AND CHANGE IT TO -----

WHERE
thread_id=".$th." AND {SQL_TABLE_PREFIX}msg.approved='Y' ORDER BY id");

For your information,