https://www.icyphoenix.com/viewtopic.php?f=35&t=6123&p=41511#p41511
-----------------------------------
d16174l4n63l
Mon 20 Jul, 2009 06:18

Re: 1.2.0.27 To 1.3.0.53 ADV Permissions Issue
-----------------------------------
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.

[hr]

Now, I used a default WAMP 5 server package and installed.  Under the came settings I get the following.

[code linenumbers=true]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[/code]

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.

[code linenumbers=false]
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);
	} */
[/code]

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.


