Error when setting Permissions in Nuke 6.9

Nuke Cadet Joined: Jan 05, 2004 Posts: 3

When I set user permissions in the forum I get this error.
Any Help would be much appreciated.

Thank you

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

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_mod) VALUES (31, , 1, 1, 1, 1, 1, 0)

Line : 425
File : /home/sleuths/public_html/Nuke/modules/Forums/admin/admin_ug_auth.php

------------------------------------------------------------------------------------

I am using PHPnuke 6.9 on Apache sever.

Theme: SpacePilot3K
Operation System Linux
Apache Version 1.3.29 (Unix)
Kernel Version 2.4.20-24.9
Perl Version 5.8.0
PHP Version 4.3.2
MySQL Version 4.0.15-standard

------------------------------------------------------------------------------------

admin_ug_auth.php fuction in question

//
// Checks complete, make updates to DB
//
$delete_sql = '';
while( list($forum_id, $action) = @each($forum_auth_action) )
{
if ( $action == 'delete' )
{
$delete_sql .= ( ( $delete_sql != '' ) ? ', ' : '' ) . $forum_id;
}
else
{
if ( $action == 'insert' )
{
$sql_field = '';
$sql_value = '';
while ( list($auth_type, $value) = @each($update_acl_status[$forum_id]) )
{
$sql_field .= ( ( $sql_field != '' ) ? ', ' : '' ) . $auth_type;
$sql_value .= ( ( $sql_value != '' ) ? ', ' : '' ) . $value;
}
$sql_field .= ( ( $sql_field != '' ) ? ', ' : '' ) . 'auth_mod';
$sql_value .= ( ( $sql_value != '' ) ? ', ' : '' ) . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]);

$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (forum_id, group_id, $sql_field)
VALUES ($forum_id, $group_id, $sql_value)";
}
else
{
$sql_values = '';
while ( list($auth_type, $value) = @each($update_acl_status[$forum_id]) )
{
$sql_values .= ( ( $sql_values != '' ) ? ', ' : '' ) . $auth_type . ' = ' . $value;
}
$sql_values .= ( ( $sql_values != '' ) ? ', ' : '' ) . 'auth_mod = ' . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]);

$sql = "UPDATE " . AUTH_ACCESS_TABLE . "
SET $sql_values
WHERE group_id = $group_id
AND forum_id = $forum_id";
}
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't update private forum permissions", "", __LINE__, __FILE__, $sql);
}
}
}

Posted: Thu Jan 15, 2004 9:42 am

i had the same problem. use this

http://www.nukeresources.com/downloads-file-746.html

Nuke Soldier Joined: Dec 23, 2003 Posts: 15

I had this problem too. Tried the fix and got this:

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, 1, 0)' 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_mod) VALUES (6, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

Line : 385
File : /usr/home/egidius/public_html/home/modules/Forums/admin/admin_ug_auth.php

--------------------------------------
Operating system FreeBSD
Apache version 1.3.29 (Unix)
PHP version 4.3.3
MySQL version 4.0.17

Nuke Cadet Joined: Jan 25, 2004 Posts: 7

egidius wrote:

I had this problem too. Tried the fix and got this:

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, 1, 0)' 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_mod) VALUES (6, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

Line : 385
File : /usr/home/egidius/public_html/home/modules/Forums/admin/admin_ug_auth.php

--------------------------------------
Operating system FreeBSD
Apache version 1.3.29 (Unix)
PHP version 4.3.3
MySQL version 4.0.17

i have this same issue i posted on other places how come we dont get any help?