>>
Site Map
>>
Forums
>>
phpBB Module
Forum module - topics in forum:
phpBB Module - Discussions relating directly to the PHP-Nuke phpBB module.
Could not obtain moderator status
Trying to auth a user for a restricted forum, change his access leve and save but I get this error:
| Code: : |
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
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 : 529
File : admin_ug_auth.php |
Im afraid Im no php wiz (by any stretch of the imagination) is there an obvious problem here?
Cheers,
Wil.
Ive found a fix for the problem, thought Id post it here in case anyone else has the same issue.
Found it on Nuke Fixes
Run the script from your Forums module, then delete it.
Works for me.
As you didn't post which PHP-Nuke version you're using I do recommend to update yours to patch 3.1. The link you gave above points to a fix included in the 3.0 patch.
BL
