FUDforum: Bug Reports » In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error

Home » FUDforum Development » Bug Reports » In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error

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

Re: In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error [message #11484 is a reply to message #11481]

Mon, 30 June 2003 18:02

lstep

Messages: 50
Registered: June 2003

Karma:

Member

OK, my wife found the bug (and the patch Very Happy

The problem comes from the mismatch in single and double quotes in the file
theme/default/modque.php, around line 2085, there is the following excerpt:

'._uid.'

It should be:

"._uid"

Here is the exact corrected snippet of the file theme/default/modque.php:

.($usr->is_mod != 'A' ? ' INNER JOIN fud25_mod mm ON f.id=mm.forum_id AND mm.user_id='._uid.' ' : '')."
INNER JOIN fud25_cat c ON f.cat_id=c.id
LEFT JOIN fud25_users u ON m.poster_id=u.id
LEFT JOIN fud25_level l ON u.level_id=l.id
LEFT JOIN fud25_poll p ON m.poll_id=p.id
LEFT JOIN fud25_poll_opt_track pot ON pot.poll_id=p.id AND pot.user_id="._uid."
WHERE
f.moderated='Y' AND m.approved='N'
ORDER BY f.view_order, m.post_stamp DESC LIMIT ".$POSTS_PER_PAGE);

Report message to a moderator

[Message index]

		In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error By: lstep on Mon, 30 June 2003 16:10
		Re: In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error By: lstep on Mon, 30 June 2003 18:02
		Re: In FUDforum 2.5.0 stable, clicking on queue moderation gives an SQL error By: Ilia on Wed, 09 July 2003 13:30

Previous Topic:	Single quote in user name
Next Topic:	2.5.0 minipager bug (thread.php.t)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 23:50:34 GMT 2024

Total time taken to generate the page: 0.04106 seconds