Jump to content

SQL syntax error in admin panel


shotoutofnowhere

Recommended Posts

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 status

DEBUG MODE

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.' 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 : 528
File : admin_ug_auth.php
Link to comment
Share on other sites

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).
Link to comment
Share on other sites

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?
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.