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:

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,

http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/firefox-spread-btn-1.png

Report message to a moderator

[Message index]

		moderation error By: tufan on Tue, 04 June 2002 11:06
		Re: moderation error By: Ilia on Tue, 04 June 2002 15:58

Previous Topic:	INNER JOIN on mysql 3.22.32 broken?
Next Topic:	Spellchecking creates new lines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 17:57:43 GMT 2025

Total time taken to generate the page: 0.06429 seconds