Php Users Please Help

[9th_cow]

made one of our members an admin by mistake and now whenever i try and edit this to correct my mistake im given the following error (this is a common occurance when editing most members)

 

General Error

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, 0)' at line 2

 

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (5, , 1, 1, 1, 1, 1, 1, 1, 1, 0)

 

Line : 425

File : /home/vhosts/5000121596/9thawacs.com/htdocs/modules/Forums/admin/admin_ug_auth.php

 

 

this mean anything to anyone ?

 

i cannot for the life of me thing of how to fix this

 

thanks in advance if anyone can help

[TCH-Dick]

what version of Nuke and phpBB are you using?

 

Ok found it, looks like you have PhpNuke 6.9 and phbb 2.0.5 from NukeCops

[TCH-Dick]

Ok this should fix it

 

Private forum permissions fix 1

[DarqFlare]

In any case, the reason it wasn't working was because there are two commas after the 5.

[vendlus]

In any case, the reason it wasn't working was because there are two commas after the 5.

I think that it's actually missing a number between those commas. The number of columns doesn't match the number of input numbers. Not that this matters if the fix is at that link.