Problem with Forum Permissions

New Member Joined: Oct 19, 2004 Posts: 5

Hi Guys

I have stumbled across a problem when attempting to update the forum permissions for my site.

The original error I had was...

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, 1, 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_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

Line : 425
File : /home/undergro/public_html/modules/Forums/admin/admin_ug_auth.php

I was advised to try entering..

VALUES (1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

I tried that but am now getting..

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, 1, 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_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (1, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

Line : 425
File : /home/undergro/public_html/modules/Forums/admin/admin_ug_auth.php

If anyone can help it would be greatly appreciated because as it stands I cant authorise anyone on the site to view certain forums.

Thanks

viRuS

Posted: Thu Oct 21, 2004 6:58 am

I think this one has been answered a few times before.
Search this forum for admin_auth.php

Posted: Thu Oct 21, 2004 1:42 pm

Ok thanks.

But I have sat here for an hour now trawling these forums and I still can't find anything to help me.

If you could let me know or give me a more direct link.

Thanks

viRuS

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I think if you also search for 'SQL Error : 1064' you will find the answer.

Posted: Fri Oct 22, 2004 6:35 am

Ok thanks

I think I seem to have fixed it using a file that was found for me by a friend.

I have hosted the file and you can download it from here www.underground-killers.co.uk/downloads/fixgroup_195.zip

Oh and Raven do you have msn? if so please add me as it would be great to chat with you.

My addy is fgvirus@gmail.com.

Thanks

viRuS

Posted: Fri Oct 22, 2004 6:36 am

By the way, that file should be unzipped and then placed in to modules/forums dir and ran.

Hope it helps!

viRuS

Posted: Fri Oct 22, 2004 7:13 am

-UK-viRuS wrote:

Ok thanks

I think I seem to have fixed it using a file that was found for me by a friend.

I have hosted the file and you can download it from here www.underground-killers.co.uk/downloads/fixgroup_195.zip

Oh and Raven do you have msn? if so please add me as it would be great to chat with you.

My addy is fgvirus@gmail.com.

Thanks

viRuS

I refuse to use anymore MS applications if I don't have to Evil or Very Mad

. However, I do have YIM and AIM.