Couldn't update private forum permissions

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

Couldn't update private forum permissions

DEBUG MODE

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

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (4, , 1)

Line : 385
File : /blah/blah/blah/modules/Forums/admin/admin_ug_auth.php

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

haha I thought I wasnt going to have to post any bugs for awhile. lol

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

any ideas? YOu guys have a fix for it?

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

do I need to add something to the sql database?

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

Code:

if ( $delete_sql != '' )
{
$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
WHERE group_id = $group_id
AND forum_id IN ($delete_sql)";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't delete permission entries", "", __LINE__, __FILE__, $sql);
}
}

I dont know if I am reading this right but if I am the AUTH_ACCESS_TABLE should that be auth_access ? because that is how its in the sql database?

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

and

Code:

Couldn't delete auth access info

DEBUG MODE

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

Major Joined: Jan 13, 2003 Posts: 892

Are you using the port from here? I just went and tried on my site and had no trouble changing permissions back and forth accessing ect.... on existing and new forums. Not much help but wanted ya to know your not being ignored. Maybe when one of the others pops on they will have some ideas to help you out.

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

yeah I am using this port from here.

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

Do you have to it in order or something?

It shows me as a moderator. But nobody else I try to add. I get that error everytime.

Premium Joined: Jan 26, 2003 Posts: 230 Location: USA

This is what I figured out.

I couldnt add users to be moderators or the forums.
I had them in a moderator group. Then I tried to go to user permission and add them as a moderator as well.

It wasnt working and I got that same error. I had to delete the groups and just add them to the selected forums to moderate

Major Joined: Jan 13, 2003 Posts: 892

Ok now I understand better at least what you are trying to do. I thought you meant change the forums permissions/access levels. I only have one group and thats a special one without any extra permissions. I'll see how it goes to make a user a mod see if I can duplicate your problem.

Joined: Jan 31, 2004 Posts: -88

the groups themselves work fine cause I run the port on my site and I've got a couple of private forums that are available only to those groups.

AI

Posted: Tue Apr 15, 2003 4:28 am

Hi.
I have got same error when I tried to make a user moderator.
Problem were ONLY with this user. I did make others without any problem.
The error I got is:
General Error
Couldn't delete auth access info

DEBUG MODE

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

Line : 175
File : xxxxxxxxxx/kraksimo.com/modules/Forums/admin/admin_ug_auth.php

any ideas?
thanks in advance...

Posted: Tue Apr 15, 2003 7:49 am

File: admin_ug_auth.php

Change all instances of:

Code:

WHERE group_id = $group_id

to:

Code:

WHERE group_id = '$group_id'

Posted: Tue Apr 15, 2003 9:13 am

chatserv wrote:

File: admin_ug_auth.php

Change all instances of:

Code:

WHERE group_id = $group_id

to:

Code:

WHERE group_id = '$group_id'

Hi.
Thanks for the quick reply.
I did that but I got another error in the same case:

Couldn't update auth access

DEBUG MODE

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

UPDATE nuke_bbauth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 WHERE group_id =

Line : 187
File : ......../modules/Forums/admin/admin_ug_auth.php
thanks...