Jump to content

Archived

This topic is now archived and is closed to further replies.

shotoutofnowhere

SQL syntax error in admin panel

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

Share this post


Link to post
Share on other sites
Well, you can't have an empty IN() clause, that's the error.  The software should account for this boundary case.

Share this post


Link to post
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).

Share this post


Link to post
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?

Share this post


Link to post
Share on other sites
That's beyond the scope of my knowledge... I know nothing about phpBB.

Share this post


Link to post
Share on other sites

×

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.