You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 343 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Error when setting PHPBB permissions on super user [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
empower
Nuke Cadet
Nuke Cadet


Joined: Jun 21, 2003
Posts: 3


PostPosted: Mon Jun 23, 2003 2:05 am Reply with quoteBack to top

When trying to make the super user a moderator of a forum I get the following error message:
------------------------------------------------
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 ' 1)' at line 2
INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (10, , 1)
Line : 385
File : /home/saaorgn/public_html/modules/Forums/admin/admin_ug_auth.php
---------------------------------------------
I can make other members moderators just not the super user.
Anyone else tried this?
Find all posts by empowerView user's profileSend private message
Mighty_Y
Sergeant
Sergeant


Joined: Feb 27, 2003
Posts: 94


PostPosted: Mon Jun 23, 2003 2:56 am Reply with quoteBack to top

I think you first need to remove the member form the moderators group. You can't make a member a moderator when he is in that group
Find all posts by Mighty_YView user's profileSend private messageVisit poster's website
gybanez
Nuke Cadet
Nuke Cadet


Joined: Jun 10, 2003
Posts: 8


PostPosted: Mon Jun 23, 2003 10:14 am Reply with quoteBack to top

i think i got that before and I fixed it by going to myphpadmin on table nuke_bbauth_access and doing a Repair.

Make sure to backup first!!!! good luck
Find all posts by gybanezView user's profileSend private message
Netrioter
Nuke Soldier
Nuke Soldier


Joined: Jun 06, 2003
Posts: 13


PostPosted: Tue Jun 24, 2003 9:31 am Reply with quoteBack to top

i think its a bug in all phpbb 2.0.x forums. normally when u make it, the forum should auto create a single user group for this user, but it dont do it, when the user is in a other moderator group.
Find all posts by NetrioterView user's profileSend private messageVisit poster's website
Morlon
Nuke Cadet
Nuke Cadet


Joined: Sep 23, 2003
Posts: 1


PostPosted: Tue Sep 23, 2003 1:37 am Reply with quoteBack to top

I've got a similar problem when setting "downgrading" a user from Admin to User in the user auth section.

First I removed him from the admin group and then i wanted to change this permission and get the Error:

SQL Error : 1064 You have an error in your SQL syntax near ' 1, 1, 1, 1, 1, 1, 1, 0)' at line 2

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_sticky, auth_announce, auth_vote, auth_mod) VALUES (10, , 1, 1, 1, 1, 1, 1, 1, 0)

When changing mod rights for sections in this place i've got the error:

SQL Error : 1064 You have an error in your SQL syntax near 'AND auth_mod = 0' at line 3

DELETE FROM nuke_bbauth_access WHERE group_id = AND auth_mod = 0

All have to do with a missing group_id, so i checked the file admin_ug_auth.php and after checking some results i found out, that entries in the table nuke_bbauth_access are missing and the first SQL-query is getting no result.

edit: a repair of the table doesn't help
Find all posts by MorlonView user's profileSend private message
gybanez
Nuke Cadet
Nuke Cadet


Joined: Jun 10, 2003
Posts: 8


PostPosted: Tue Sep 23, 2003 7:46 am Reply with quoteBack to top

from my experience with the built in forum in php-nuke...I get almost sql debug messages if I try to modify any permissions of a user if they belong in any group.

Try this: Remove that user from any group first then make the necessary change to the user. Afterwards, add them back to the group they originally belonged in before you removed them. It's a pain but it does work.
Find all posts by gybanezView user's profileSend private message
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Tue Sep 23, 2003 7:50 am Reply with quoteBack to top

The permission problems have been fixed. Try searching the Forums for the answer...it's out there Smile

_________________
Getting Started | My Projects
Find all posts by mikemView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.061 Seconds - 87 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::