SQL Error

donjski · 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.

SmackDaddy · 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)

donjski · Regular Joined: Jan 14, 2004 Posts: 53

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.

SmackDaddy · Posted: Sun Jul 11, 2004 6:55 pm

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

donjski · Regular Joined: Jan 14, 2004 Posts: 53

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

SmackDaddy · 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.

donjski · Regular Joined: Jan 14, 2004 Posts: 53

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

Raven · Posted: Sun Jul 11, 2004 9:28 pm

Try this if you haven't already:

Chatserv wrote:

For anyone else having this problem first upload the following file:

Only registered users can see links on this board!
Get registered or login to the forums!

If you still can't change a user's perms then use this fix:

Only registered users can see links on this board!
Get registered or login to the forums!

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.

donjski · Regular Joined: Jan 14, 2004 Posts: 53

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?