SQL Error

Regular Joined: Jan 14, 2004 Posts: 53

Everyonce and a while I get these. It usually happens on just one person as in this case. I'm trying to give one person special Privs.

Here is the error:

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)' 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_download, auth_mod) VALUES (32, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)

Line : 425
File : /var/www/html/forum/modules/Forums/admin/admin_ug_auth.php

Any Ideas?

I had a similar problem with this user the other day. I found a work around, but never wrote it down. Apperently somethings wrong here.

Posted: Sun Jul 11, 2004 6:39 pm

Could it be because after the value 32, there is no value, just a comma? (taking a stab)

Posted: Sun Jul 11, 2004 6:49 pm

Yes I noticed that, but why does that space end up there. I do believe that is the problem. But I have no clue how to fix it.

Thanks for the quick reply.

Posted: Sun Jul 11, 2004 6:55 pm

Place a value (like 0) there and try again....apparently it's the "group_id" value....

Posted: Sun Jul 11, 2004 7:05 pm

But don't I need the correct number there. If I put 0 and it should be 48 won't it mess things up?

Posted: Sun Jul 11, 2004 7:09 pm

Ahh, yes.....but not sure about the number for "groups_id"......you could always use phpmyadmin to change the number to the correct one. Figured it would solve the syntax error however Raven, Bob or someone else who actually programs for a living probably knows this off the top of their head.

Posted: Sun Jul 11, 2004 7:13 pm

I think that is what I did the other day, But it took a while to figure out the group ID.

But thanks.

I think what I really need to do is find out why this keeps happening and fix that problem, rather than just working around it again.

thanks for the input though Very Happy

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

Try this if you haven't already:

Chatserv wrote:

For anyone else having this problem first upload the following file:
http://nukeresources.com/files/admin_ug_auth.zip

If you still can't change a user's perms then use this fix:
http://www.nukeresources.com/downloadview-details-747-Private_forum_permissions_fix_2.html

Follow the instructions detailed in the download's description, once done delete it from the server but keep the new admin_ug_auth.php file.

Posted: Mon Jul 12, 2004 10:07 am

Thanks Raven, The first one looked like it fixed it, got no errors after it, but none of the permissions stuck. Went to fix 2 and that worked great.

Will I have this problem in the future? Or is the new auth_ug going to fix this?