PHP-Nuke Nederland Forums-viewtopic-Could not obtain moderator status

PHP-Nuke Nederland: Forums

PHP-Nuke Nederland :: View topic - Could not obtain moderator status

Forum FAQ • Search • Memberlist • Usergroups • Register • • Profile • Log in to check your private messages • Log in

Could not obtain moderator status

PHP-Nuke Nederland Forum Index » Algemeen 7.x

Author

Message

krike
Gevorderd

Joined: Oct 01, 2007
Posts: 62

Posted: Tue 22 Jan 2008 22:50

ik krijg het volgende als ik van een user een moderator wilt maken (permissions):

Quote:

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.use' 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 : 532
File : admin_ug_auth.php

bij het veranderen van permissie van een admin krijg ik dit niet. Ik ben al op nukefix gegaan en heb daar een dergelijke fout zien staan, maar de oplossing help niet echt. (ik moet oude code vervangen in de index.php van de module "your account" met nieuwe, maar die nieuwe code zit er al in)

maar ik ben gaan kijken in de file die de error terug geeft en de code ziet er als volgt uit:

Quote:

$sql = "SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug
WHERE ug.user_id IN (" . implode(',', $group_user) . ") ***
AND aa.group_id = ug.group_id
AND aa.auth_mod = 1
GROUP BY ug.user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain moderator status', '', __LINE__, __FILE__, $sql);
}

de 3 *** markeren waar de fout normaal moet zijn. kan iemand me helpen?

_________________

Donaties

Adverteren

Wilt u het forum steunen, dan kunt u nu eenvoudig doneren met PayPal.

PHP-Nuke Nederland Forum Index » Algemeen 7.x

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Forums ©


All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2004-2008 by BlueLion. SEO enhanced with the Sitemapper script You can syndicate our news using the file backend.php or ultramode.txt PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license. Pagina rendering: 0.07 seconden	RSS Feeds:
:: fisubsilver shadow phpbb2 style by Daz :: PHP-Nuke theme by BlueLion ::