getting error from forum.

Hangin' Around Joined: Sep 18, 2003 Posts: 36

I am getting this error from the forum config.
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 (1, , 1)

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

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

Search the forums for 'SQL Error : 1064 You have an error in your SQL syntax'. This is not unique to the release, unfortunately.

New Member Joined: Nov 02, 2003 Posts: 11

I got a similar error when I tried to give a member certain permissions after I assigned him to a group. It is strange when I deleted him from the group I could change his permissions then I could add him back to the group. you just cant do it in the other order. Couldn't tell you why tho. I had that problem on all versions of nuke tho.

Posted: Tue Jan 20, 2004 4:55 pm

I am getting the same error on your 7.0 too raven and I can't lock out any
forums either, do you happen to know what the problem is?
That one I showed you was on a friends site, I am getting the same thing on your rc1 too. i would like to get the forums fixed one way or the other, if not oh well can't win them all, hope someone can help?
thanks guys

Posted: Tue Jan 20, 2004 5:00 pm

Bones,

This has been a long standing issue since FB integrated. It can be resolved by changing the order you assign permissions. If you search the forums as I mentioned above, I believe the answer is detailed there. Have you tried that?

Posted: Tue Jan 20, 2004 5:06 pm

I searched the forums like you said even went to nukecops, nobody answered me over there. I tried everywhere. No biggy I will think of something. thanks gaylen for your help.

Posted: Tue Jan 20, 2004 5:12 pm

Did you try this one http://www.ravenphpscripts.com/posts400-highlight1064.html+error+sql+syntax ?

Posted: Tue Jan 20, 2004 5:54 pm

I tried that one too, it worked with 6.5 with no problem but I tried
that with your 7.0 and didn't work, maybe i'm doing something wrong
who knows, i might be.