https://www.icyphoenix.com/viewtopic.php?f=29&t=7903&p=53002#p53002
-----------------------------------
Ghostsearcher
Wed 29 Jun, 2011 17:32

[DEV] Can't Set Permissions In Forums And Another Thing - Bug?
-----------------------------------
Hi there!

Maybe i found a bug!?
Let's see...

I'm using icyphoenix (git, please see my signature for details) and i've noticed: I can't set permissions to the standard forums.
Don't missunderstand me: It is a fresh install and no(!) changes are made!

So, as standard set permissions, i've noticed that guests can write and open new topics in the forum. :shock: Is that normal?
I tried to change the permissions under acp>forum>permissions>"Test Forum 1" (the second one, so not the category but the normal forum!)
Then i click for "Public" and then "Advanced Mode". I changed from "ALL" to "REG" this two points: Post and Reply.
After Submitting comes a error displayed:
[quote]SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY (u.user_id) ORDER BY u.user_id ASC' at line 4 [1064]

SQL

SELECT u.user_id, u.user_level FROM ip_users u, ip_forums_watch fw WHERE u.user_id = fw.user_id AND fw.forum_id = 3 AND u.user_id NOT IN () GROUP BY (u.user_id) ORDER BY u.user_id ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 289
CALL: sql_db->sql_error()

FILE: includes/class_notifications.php
LINE: 307
CALL: sql_db->sql_query()

FILE: adm/admin_forumauth.php
LINE: 111
CALL: class_notifications->delete_not_auth_notifications()[/quote]
But the permissions are now set in ACP! :shock:
And guests can further write and open up topics in the forums.... -.-" 

Well, firstly i've got MySql 5.1 and not 4 and secondly this error also comes up if i use only submit w/o using "Advanced Mode" before.
Incredible.
Same problems are in all the other forums which are set as standard: Reporting and Recycle

- Another thing:
In this case i tried to start a new topic as guest and misspassed the "Visual Confirmation for Guests".
Ok, I thought it's no problem. But after displaying the error site (i've given a mistaken code and so on) i have to go "back" and voila, no text anymore!
I think this could also be possible if a registered user is written 2 post to quickly. Didn't test it.
But if so, it's not good.
If the text is present again it would be more comfortable and my user could not be upset.
I hope you know what i mean?
Because if i write one text after the next one, and not less, and i submit it for just displaying an errorpage which steal my text, so i would be very angry!
There should be a better solution for it, i think.

Hope i could help a bit with my eventual bug tracking. ;)
Thank you!

Greetings, Ghostsearcher


