Okay I have done some checking to recreate the circumstances again.
I did a fresh install of 1.3.0.53. Install went fine, my forum structure is like this.
Catagory 1
Forum 1
Catagory 2
Forum 2
Catagory 3
Forum 3
Each forum is set to Private on all options.
I went to the user I created, it started at simple permissions. I went to advanced and changed just three permissions. I then hit submit, and it brought me to the group permissions control page. This is on a live page with no modifications to the database.
Now, I used a default WAMP 5 server package and installed. Under the came settings I get the following.
- Couldn't obtain user/group 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 'AND g.group_single_user = 1' at line 1
-
- SELECT aa.*, g.group_single_user FROM ip_auth_access aa, ip_user_group ug, ip_groups g WHERE ug.user_id = 3 AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND aa.forum_id = AND g.group_single_user = 1
-
- Line : 280
- File : admin_ug_auth.php
So where to go from here, I do not know. I have found out that there is an issue almost identical with phpbb2 with a couple of mods, but their fix even when adapted did not change anything.
UPDATED
So, I managed to get the WAMP version to save permissions and bypass the error mind you this is just a temp fix but it works thus far.
Open ./adm/admin_ug_auth.php
-------------------------------------------------------------------------------
Find (Around line 280 )
-------------------------------------------------------------------------------
$sql = ($mode == 'user') ? ("SELECT aa.*, g.group_single_user FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE. " g WHERE ug.user_id = $user_id AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND aa.forum_id = $forum_id AND g.group_single_user = 1") : ("SELECT * FROM " . AUTH_ACCESS_TABLE . " WHERE group_id = $group_id AND forum_id = $forum_id");
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, "Couldn't obtain user/group permissions", "", __LINE__, __FILE__, $sql);
}
if ($row = $db->sql_fetchrow($result))
{
for ($k = 0; $k < count($forum_auth_fields); $k++)
{
$change_acl_list[$forum_id][$forum_auth_fields[$k]] = $row[$forum_auth_fields[$k]];
}
}
$used_forums[$forum_id] = 1;
-------------------------------------------------------------------------------
IN-LINE FIND
-------------------------------------------------------------------------------
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, "Couldn't obtain user/group permissions", "", __LINE__, __FILE__, $sql);
}
-------------------------------------------------------------------------------
REPLACE WITH
-------------------------------------------------------------------------------
if (!($result = $db->sql_query($sql)))
/* {
message_die(GENERAL_ERROR, "Couldn't obtain user/group permissions", "", __LINE__, __FILE__, $sql);
} */
With this change you are able to adjust advanced permissions, in forums styles like mine. Included is a default file for replacement, it has no other mods than what is listed above.