https://www.icyphoenix.com/viewtopic.php?f=35&t=6714
-----------------------------------
gonvela
Wed 25 Nov, 2009 12:09

Mistake On Having Granted Permissions (SOLUTION)
-----------------------------------
Hello I have a poblema, am thinking a new sub forum and attempt about giving the permission of moderating to a person who already this of moderating does fabric of time and in enough sub forum and says this to me. That I do not have not P. .... of what is, come so(then) if someone can help me a bit thank you very much. Regards  

[b] Error general

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 phpbb_auth_access aa, phpbb_user_group ug, phpbb_groups g WHERE ug.user_id = 124 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[/b]


-----------------------------------
Yros
Wed 25 Nov, 2009 13:40

Re: Mistake On Having Granted Permissions
-----------------------------------
I didn't understood everything you said but I think your problem is the following one :
- You want to give Moderator's permissions to an user ( right ? )

Then the best way to do it is to add him to a specific group ( like ' Moderators ' ) which you will gave permissions on the forums you want ( ACP > Groups > Permissions ). It's always better to give permissions via groups than via a single user.

ps : if you have some troubles with English you can also add your idea in your mother language ( which seems to be Spanish, isn't it ? ) because some of us also speak Spanish and will be able to translate for you or at least understand perfectly what you mean ;)

About your SQL error, I don't remember when I had the same so I can't really help you ... But I think that if you use permissions via groups as I said, it will fix your prob' ( Remove user's privileges and add him to a group with the same privileges )


-----------------------------------
gonvela
Mon 30 Nov, 2009 23:18

Re: Mistake On Having Granted Permissions
-----------------------------------
Bueno pues gracias por dejarme expresarme en español , mi problema es que desde unos dias el foro no me deja dar permisos de moderador a ningun usuario, sea moderador , o no los permisos nuevos me sale este error, gracias por vuestra ayuda
saludos.


-----------------------------------
KasLimon
Tue 01 Dec, 2009 09:26

Re: Mistake On Having Granted Permissions
-----------------------------------
Hola.

Cuando tengas problemas y no puedas expresarte bien en inglés te recomiendo acudir a www.icyphoenix.es, el sitio de soporte oficial en español ;) 

Has aplicado el último parche a tu foro? http://www.icyphoenix.com/viewtopic.php?f=22&t=6435

---
The user asks for help with an error that is displayed when he's trying to set users moderator permissions.

I've requested him to tell me whether he has or not installed the last patch.

Greets!


-----------------------------------
gonvela
Wed 02 Dec, 2009 00:57

Re: Mistake On Having Granted Permissions
-----------------------------------
Thanks Kaslimon, but it is a long time with the error and nobody knows how to fix it, so I decided to try here, good and nothing pache install error keeps coming up.
Those who will not let me give permissions for GENERAL ERROR SCREEN sale permits in advanced mode, and if I leave the screen goes into simple mode.


-----------------------------------
KasLimon
Wed 02 Dec, 2009 10:50

Re: Mistake On Having Granted Permissions
-----------------------------------
It's a strange error, it seems your tpl file is damaged... Try to upload [i]templates/common/acp/auth_ug_body.tpl[/i] and [i]adm/admin_ug_auth.php[/i] from the main IP package.
Then clean cache and try again.

If it doesn't work, try doing this:
[b]Open [/b][i]adm/admin_ug_auth.php[/i]
[b]Find[/b][code linenumbers=false]						// FORUMS AUTH MOVED CODE - BEGIN[/code][b]After, add[/b][code linenumbers=false]						if (!empty($forum_id))
						{[/code][b]Find[/b][code linenumbers=false]						// FORUMS AUTH MOVED CODE - END
						$change_acl_list[$forum_id][$auth_field] = $value;[/code][b]After, add[/b][code linenumbers=false]						}[/code]

Greets!


-----------------------------------
gonvela
Wed 02 Dec, 2009 15:50

Re: Mistake On Having Granted Permissions
-----------------------------------
I've done, what I've said, I updated the files and nothing still with the same error. And the file that you say there are no lines of code that you put. 

The strange thing is that I do with all users but with some, and with whom I do I get in advanced mode and I can put in simple mode.

thanks for the trouble you are taking


-----------------------------------
KasLimon
Wed 02 Dec, 2009 16:24

Re: Mistake On Having Granted Permissions
-----------------------------------
That you're saying (that you don't find the code) confirms my fist hypothesis: You have not installed the last patch, so please update your forum: http://www.icyphoenix.com/viewtopic.php?f=22&t=6435

Only by updating your forum, the problem may be resolved, if not just try to do the modifications I told you before.

Greets!


-----------------------------------
gonvela
Wed 02 Dec, 2009 18:38

Re: Mistake On Having Granted Permissions
-----------------------------------
Well get the solution, the problem is in the BD in this table [b]phpbb_auth_access[/b]
corresponding to the board permissions.
SOLUTION: Empty the table and re-grant privileges [b]phpbb_auth_access[/b]

Thank you all for your help
greetings


