Thread: phpnuke SQL Error : 1064
View Single Post
  #4 (permalink)  
Old 04-10-2006, 01:30 AM
ovaltrack ovaltrack is offline
Junior Member
  
Join Date: Jul 2005
Location: Lismore Australia
Posts: 7
i have a very simular error.....
Code:
 
DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.' 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 : 529
File : admin_ug_auth.php
I was tring to chang somones moderator status... only thing i have changed recently it upgading to nuke 7.8 (from 7.5)

any help greatly apreciated.
Reply With Quote