April 16, 2008, 10:29 pm 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.us' at line 3


SQL was: 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


 remote addr: **.**.**.**

You are trying to access a restricted area.





We are Sorry, but this section of our site is for Registered Users Only.





You can register for free by clicking here, then you can


access this section without restrictions. Thanks.





[ Go Back ]

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.us' 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 : 559


File : admin_ug_auth.php

Couldn't update private forum permissions





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 ' 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)' at line 2





INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (31, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)





Line : 385


File : admin_ug_auth.php

AND aa.group_id = ug.group_id 


            AND aa.auth_mod = 1 


         GROUP BY ug.us' <------------ (this one)     at line 3 

WHERE ug.group_id = aa.group_id


                                AND u.user_id = ug.user_id


            AND ug.user_pending = 0


            AND u.user_level NOT IN (" . MOD . ", " . ADMIN . ")


                        GROUP BY u.user_id


                        HAVING SUM(aa.auth_mod) > 0";


                if ( !($result = $db->sql_query($sql)) )

After applying the above new users should get a group assigned to them but users that had registered before might now have one, to correct this save the following to a file, name it fixgroup.php upload it to your Forum's folder and point your browser to: 


http://your_site.com/modules.php?name=Forums&file=fixgroup 





Delete the file once done. 





php: 





<?php 


//*****  check users and user groups ****// 


if (!eregi("modules.php", $PHP_SELF)) { 


    die ("You can't access this file directly..."); 


} 


if ($popup != "1"){ 


    $module_name = basename(dirname(__FILE__)); 


    require("modules/".$module_name."/nukebb.php"); 


} 


else 


{ 


    $phpbb_root_path = 'modules/Forums/'; 


} 





define('IN_PHPBB', true); 


include($phpbb_root_path . 'extension.inc'); 


include($phpbb_root_path . 'common.'.$phpEx); 


include('includes/functions_search.'.$phpEx); 





// Start session management 


$userdata = session_pagestart($user_ip, PAGE_SEARCH, $nukeuser); 


init_userprefs($userdata); 


// End session management 





$sql = "SELECT user_id, username 


    FROM " . USERS_TABLE ." 


    WHERE user_id > 0"; 


if ( !($result = $db->sql_query($sql)) ) 


{ 


    message_die(GENERAL_ERROR, 'Could not obtain user list', '', __LINE__, __FILE__, $sql); 


} 





$liste =''; 


while ( $row = $db->sql_fetchrow($result) ) 


{ 


   $username = $row['username']; 


   $user_id = $row['user_id']; 


   $usergroup = ''; 


     


   $sql1 = "SELECT ug.group_id 


          FROM " . USER_GROUP_TABLE ." ug, ". GROUPS_TABLE. " g   


          WHERE ug.user_id = $user_id 


            AND ug.group_id = g.group_id 


            AND g.group_single_user  = 1 


            "; 


               


   if ( ($result1 = $db->sql_query($sql1)) ) 


   { 


       $row1 = $db->sql_fetchrow($result1); 


          $usergroup =( ( $row1['group_id'] != '' ) ? $row1['group_id'] : 'User has no user group'.$row1 ); 


           


   } 





          if (!($row1['group_id'] != '')) 


          { 


               


         $sql2 = "SELECT MAX(group_id) AS total 


            FROM " . GROUPS_TABLE; 


         if ( !($result2 = $db->sql_query($sql2)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sq2l); 


         } 





         if ( !($row2 = $db->sql_fetchrow($result2)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not obtain next group_id information', '', __LINE__, __FILE__, $sql2); 


         } 


         $group_id = $row2['total'] + 1; 


           


           


         $sql3 = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator) 


            VALUES ($group_id, '', 'Personal User', 1, 0)"; 


         if ( !($result3 = $db->sql_query($sql3, BEGIN_TRANSACTION)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql3); 


         } 





         $sql4 = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending) 


            VALUES ($user_id, $group_id, 0)"; 


         if( !($result4 = $db->sql_query($sql4, END_TRANSACTION)) ) 


         { 


            message_die(GENERAL_ERROR, 'Could not insert data into user_group table', '', __LINE__, __FILE__, $sql4); 


         } 





               


             $usergroup = $usergroup.', adding user group '.$group_id; 


          } 








   $liste .= ( ( $liste != '' ) ? '<br> ' : '' ) . $username.' <b>'.$usergroup.'</b>'; 


} 





message_die(GENERAL_MESSAGE,'Users:<br>'.$liste); 





?> 

Users don't get a group assigned to them when they register via the Your_Account module: 





File: modules/Your_Account/index.php 


find: 


Code: 


function activate($username, $check_num) { 


    global $db, $user_prefix, $module_name, $language; 





change to: 


Code: 


function activate($username, $check_num) { 


    global $db, $user_prefix, $module_name, $language, $prefix; 





find: 


Code: 


       $db->sql_query("INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_password, user_avatar, user_avatar_type, user_regdate, user_lang) VALUES (NULL, '$row[username]', '$row[user_email]', '$user_password', 'gallery/blank.gif', '3', '$row[user_regdate]', '$language')"); 





after add: 


Code: 


       $result2 = $db->sql_query("SELECT user_id FROM ".$user_prefix."_users WHERE username='$row[username]'"); 


       $row2 = $db->sql_fetchrow($result2); 


       $guserid = intval($row2[user_id]); 


       $db->sql_query("INSERT INTO ".$prefix."_bbgroups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', '1', '0')"); 


       $group_id = $db->sql_nextid(); 


       $db->sql_query("INSERT INTO ".$prefix."_bbuser_group (user_id, group_id, user_pending) VALUES ('$guserid', '$group_id', '0')");