FUDforum: Bug Reports » users are unable to register with the forum, SQL error, fresh install

Home » FUDforum Development » Bug Reports » users are unable to register with the forum, SQL error, fresh install

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

Re: users are unable to register with the forum, SQL error, fresh install [message #9062 is a reply to message #9058]

Tue, 11 March 2003 08:33

bbarnett

Messages: 19
Registered: March 2003

Karma:

Junior Member

Well, I've discovered the issue.

Install FUD forum .8 release. Set up your forums so that none are readable by any registered user. Add a new user. This line:

$lmid=q_singleval("SELECT MAX(last_post_id) FROM fud23_forum WHERE ".($GLOBALS['usr']->is_mod != 'A' ? " id IN(".get_all_perms(_uid).") AND " : '')." cat_id!=0");

gives the error, because get_all_perms(_uid) returns nothing, if the user has no read ability on any forum.

Commenting out the line fixes things for now.

This is something that I'm sure a few people use. I have a closed board, with 10 different forums. Each forum is viewable by new, registered users.. but no forum is readable or postable until that user is added to a group.

Any ideas on a good fix? Quick fix was:

$lmid=q_singleval("SELECT MAX(last_post_id) FROM fud23_forum WHERE ".($GLOBALS['usr']->is_mod != 'A' ? " id IN(".get_all_perms(_uid).") AND " : '')." cat_id!=0");

Changed to :

$boogerface = get_all_perms(_uid);
if ($boogerface) {
$lmid=q_singleval("SELECT MAX(last_post_id) FROM fud23_forum WHERE ".($GLOBALS['usr']->is_mod != 'A' ? " id IN($boogerface) AND " : '')." cat_id!=0");
}

Report message to a moderator

[Message index]

		users are unable to register with the forum, SQL error, fresh install By: bbarnett on Sat, 08 March 2003 15:39
		Re: users are unable to register with the forum, SQL error, fresh install By: bbarnett on Mon, 10 March 2003 23:28
		Re: users are unable to register with the forum, SQL error, fresh install By: bbarnett on Tue, 11 March 2003 08:33
		Re: users are unable to register with the forum, SQL error, fresh install By: bbarnett on Tue, 11 March 2003 15:23
		Re: users are unable to register with the forum, SQL error, fresh install By: Ilia on Thu, 13 March 2003 15:32
		Re: users are unable to register with the forum, SQL error, fresh install By: warath on Sun, 12 December 2004 03:51
		Re: users are unable to register with the forum, SQL error, fresh install By: Ilia on Sun, 12 December 2004 15:05
		Re: users are unable to register with the forum, SQL error, fresh install By: warath on Sun, 12 December 2004 19:59
		Re: users are unable to register with the forum, SQL error, fresh install By: Ilia on Mon, 13 December 2004 18:01

Previous Topic:	how to download newsgroups for first time
Next Topic:	error on cat.inc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 06 02:58:40 GMT 2024

Total time taken to generate the page: 0.05675 seconds