shotoutofnowhere Posted August 2, 2006 Share Posted August 2, 2006 When ever we try and make a user a moderator we get this error. I am completely new to this can anybody tell me how to fix this? It is on our forums and it worked on adding an admin as a moderator but it won't let a regular user be a moderator. Could not obtain moderator statusDEBUG MODESQL 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.' at line 3SELECT 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_idLine : 528File : admin_ug_auth.php Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/ Share on other sites More sharing options...
fenway Posted August 2, 2006 Share Posted August 2, 2006 Well, you can't have an empty IN() clause, that's the error. The software should account for this boundary case. Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/#findComment-67837 Share on other sites More sharing options...
shotoutofnowhere Posted August 2, 2006 Author Share Posted August 2, 2006 All right how do we get rid of it though and to make it work? Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/#findComment-68060 Share on other sites More sharing options...
fenway Posted August 2, 2006 Share Posted August 2, 2006 There are a few options... I'm assuming you can modify the source code. Either have an assertion that removes the IN clause if it's empty, or add in a value that you know can never be found (e.g. a NULL for a non-NULL column). Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/#findComment-68126 Share on other sites More sharing options...
shotoutofnowhere Posted August 2, 2006 Author Share Posted August 2, 2006 Well I noticed something today this is displayed at the bottom of the admin panel.Your installation does not seem to be up to date. Updates are available for your version of phpBB, please visit http://www.phpbb.com/downloads.php to obtain the latest version.The latest available version is phpBB 2.0.21.You are running phpBB 2.0.15.we are using Nuke is there an easy way to just update phpBB and see if this takes care of our problem? Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/#findComment-68155 Share on other sites More sharing options...
fenway Posted August 2, 2006 Share Posted August 2, 2006 That's beyond the scope of my knowledge... I know nothing about phpBB. Quote Link to comment https://forums.phpfreaks.com/topic/16282-sql-syntax-error-in-admin-panel/#findComment-68200 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.