Cannot add forum moderators

Involved Joined: Apr 22, 2006 Posts: 356

I am trying to add moderators for my forums and keep getting this when I try to add one.

SQL Error : 1064 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 ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_' at line 3

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id

Line : 524
File : admin_ug_auth.php

How do I fix this please?

Posted: Sat Oct 27, 2007 2:14 pm

http://www.ravenphpscripts.com/postp67055.html#67055

In this thread I believe Evaders suggestion may be most applicable.

Posted: Sat Oct 27, 2007 3:27 pm

Thanks fkelly,

That however did not work as my tables did not contain those mistakes.