FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » sql error when anonymous has no rights
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
sql error when anonymous has no rights [message #8551] Fri, 07 February 2003 09:50 Go to next message
spot is currently offline  spot   Germany
Messages: 1
Registered: February 2003
Karma: 0
Junior Member
Hi,
FUDforum Version 2.3.7
if anonymous has no visible and read rights from Groupmanager, I get an error, when I (as anonymous) go to Members and then go to one of the members. Error log viewer shows this:
(t=usrinfo&id=2&rid=&S=6dd6181d51fea5ae9eadd99c259c4bf2) 1064: You have an error in your SQL syntax near ') AND fud23_thread.locked='N' AND fud23_msg.approved='Y' AND fud23_forum.cat_id' at line 8
Query: SELECT count(*) FROM fud23_poll INNER JOIN fud23_msg ON fud23_poll.id=fud23_msg.poll_id INNER JOIN fud23_thread ON fud23_thread.id=fud23_msg.thread_id INNER JOIN fud23_forum ON fud23_thread.forum_id=fud23_forum.id WHERE fud23_poll.owner=2 AND fud23_thread.forum_id IN () AND fud23_thread.locked='N' AND fud23_msg.approved='Y' AND fud23_forum.cat_id!=0

the same happens, if I log in as member, go to members, go to one of the members (this is ok), but then I want to logout and again I get SQL-Error.
Re: sql error when anonymous has no rights [message #8630 is a reply to message #8551] Tue, 11 February 2003 21:50 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Fixed in CVS.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: paging bug for postgresql
Next Topic: Postgres error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 04:53:09 GMT 2024

Total time taken to generate the page: 0.02241 seconds