Wicked error found in updating private forum permissions

Posted: Fri Nov 14, 2003 12:13 pm

Found this in my forum admin panel trying to update private forum access for a user. The install is a 6.9 install that is upgraded from a 6.0 that had bbtonuke port on it.

Code:

Couldn't update private forum permissions

DEBUG MODE

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

INSERT INTO ts_bbauth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_vote, auth_mod) VALUES (32, , 1, 1, 1, 1, 1, 1, 0)

Line : 425
File : mysite.com/html/modules/Forums/admin/admin_ug_auth.php

Looks like there is a missing value going through in the insert but I have no real idea and I don't see anything in the file that tips me off immediately.

Posted: Fri Nov 14, 2003 12:17 pm

Please search before posting, this has been solved time and time before.

http://blood.recongamer.com/modules.php?name=Downloads&d_op=viewdownload&cid=2

Use that file, replace the old one.

Posted: Fri Nov 14, 2003 12:36 pm

Sorry about that....must not have searched in detail for that problem.

Posted: Thu Dec 04, 2003 10:18 pm

Sorry to come back to this issue but I replaced the file with the updated one in the link and had no chance in behavior. Even went so far as to clean out browser cache and completely shutdown both my db and apache and start them back up to make sure it was loading the right file. Any thoughts?

Sergeant Joined: Nov 03, 2003 Posts: 78 Location: DC

that fix only works with 2.0.4-2.0.6 is that ur forum version? and also nukeresources has a 2nd fix but its a little more risky than that file replacement. http://www.nukeresources.com/downloads-file-747.html

Nuke Soldier Joined: Nov 07, 2003 Posts: 22

the fixgroup file that jag refers to works very well for me, apparently a group id number is not being set, therefore you can't change the permissions.

the fixgroup file goes through the database and fixes any users that do not have a group. i just use it anytime i need to update group permissions on a user that i know is new since the last time that i ran the script. otherwise i just let it ride until then.

or you could just run it anytime you want to.

Nuke Soldier Joined: Oct 13, 2003 Posts: 33

When I run that file I get this: You can't access this file directly... Is this normal? maybe I am running it wrong? I placed it in the root and then ran it through my browser like this: http://mysite .com/fixgroup.php

Is this the correct way? and I have tried replacing: Admim_ug_auth with the fixed one also with no luck.

Thank you for any help.

Nuke Soldier Joined: Dec 03, 2003 Posts: 16

after download from blood website,the error msg is gone... that is good..
but unfortunately... by the time u make changes to user, it won't have effect, it will become user and not moderator all again....
any others try?

Sergeant Joined: Feb 26, 2003 Posts: 111

echostorm wrote:

When I run that file I get this: You can't access this file directly... Is this normal? maybe I am running it wrong? I placed it in the root and then ran it through my browser like this: http://mysite .com/fixgroup.php

Is this the correct way? and I have tried replacing: Admim_ug_auth with the fixed one also with no luck.

Thank you for any help.

upload to the Forums folder and point your browser to http://www.yoursite.com/modules.php?name=Forums&file=fixgroup

Nuke Soldier Joined: Oct 13, 2003 Posts: 33

Lol, Thank you! Wink

I can't believe I didn't look at the forums path. Embarassed

Sergeant Joined: Nov 03, 2003 Posts: 78 Location: DC

lol at least 20 people per day report this error, it should be an announcement dont u think? itll save the forums and hundreds of people a wicked amount of time from searching the forums and stuff.

Nuke Soldier Joined: Dec 20, 2003 Posts: 16

No, I dont think there should be a announcement.

I think they should just incorporate the FIXES to FIX the problems that are still dragging along.

Seeing as I "have been" a Club Member for 6 months in the past, I'm un satisfied with paying for phpnuke and still having to bug-free it myself.

I've recently denounced my club account and will just wait patiently for the next "final" bug release.

Funny thing they fixed the modules.php error and added the fix to the download after about 1 week.

This groups error has been around since 6.8 that i know of.

Sometimes you dont get what you pay for Confused

Sergeant Joined: Nov 03, 2003 Posts: 78 Location: DC

WebKnight wrote:

Sometimes you dont get what you pay for Confused

Why did u have to pay for it in the first place? its free software, you just need to install it yourself...

Nuke Cadet Joined: Dec 29, 2003 Posts: 7

Download this file and replace modules/Forums/admin/admin_ug_auth.php with this one.
http://www.nukeresources.com/downloads-file-746-details-Private_forum_permissions_fix_1.html

If that doesn't work, download and run this file. Upload it to modules/Forums/
http://www.nukeresources.com/downloads-file-747-details-Private_forum_permissions_fix_2.html

-Taken from http://www.nukecops.com/postlite13237-sql+error+1064.html

Posted: Tue Jan 06, 2004 1:46 am

PCplayground wrote:

echostorm wrote:

When I run that file I get this: You can't access this file directly... Is this normal? maybe I am running it wrong? I placed it in the root and then ran it through my browser like this: http://mysite .com/fixgroup.php

Is this the correct way? and I have tried replacing: Admim_ug_auth with the fixed one also with no luck.

Thank you for any help.

upload to the Forums folder and point your browser to http://www.yoursite.com/modules.php?name=Forums&file=fixgroup

I still get "You can't access this file directly..."
Crying or Very sad