phpBB2 by Przemo

[clueless]

When I try to make users moderators, I receive the following error:
How can I fix this?
Thank you

Kod:

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)' at line 2 INSERT INTO phpbb_auth_access (forum_id, group_id, auth_mod) VALUES (2, , 1) Line : 393 File : /******/admin/admin_ug_auth.php

[Gadatliwa Kasia]

[clueless]

Here's the area around line 339 of admin_ug_auth.php

Kod:

$forum_auth_action[$forum_id] = 'insert';                             }                             else if ( isset($auth_access[$forum_id][$auth_field]) && !empty($update_acl_status[$forum_id][$auth_field]) )                             {                                 $forum_auth_action[$forum_id] = 'update';                             }                         }                         else if ( ( empty($auth_access[$forum_id]['auth_mod']) &&                             ( isset($auth_access[$forum_id][$auth_field]) && $change_acl_list[$forum_id][$auth_field] == $auth_access[$forum_id][$auth_field] ) ) && $forum_auth_action[$forum_id] == 'delete' )                         {

[Przemo]

Something is wrong with your database,maybe you have damaged your data in the SQL. My advice --> manually repair table. Only that solution cames to my mind.

[clueless]

thanks a lot, I'll go and repair the table

[clueless]

OK, I dropped the table and reinstalled, using the following structure:

Kod:

# # Table structure for table `phpbb_auth_access` # CREATE TABLE `phpbb_auth_access` (   `group_id` mediumint(8) NOT NULL default '0',   `forum_id` smallint(5) unsigned NOT NULL default '0',   `auth_view` tinyint(1) NOT NULL default '0',   `auth_read` tinyint(1) NOT NULL default '0',   `auth_post` tinyint(1) NOT NULL default '0',   `auth_reply` tinyint(1) NOT NULL default '0',   `auth_edit` tinyint(1) NOT NULL default '0',   `auth_delete` tinyint(1) NOT NULL default '0',   `auth_sticky` tinyint(1) NOT NULL default '0',   `auth_announce` tinyint(1) NOT NULL default '0',   `auth_globalannounce` tinyint(1) NOT NULL default '0',   `auth_vote` tinyint(1) NOT NULL default '0',   `auth_pollcreate` tinyint(1) NOT NULL default '0',   `auth_attachments` tinyint(1) NOT NULL default '0',   `auth_mod` tinyint(1) NOT NULL default '0',   `auth_download` tinyint(1) NOT NULL default '0',   KEY `group_id` (`group_id`),   KEY `forum_id` (`forum_id`) ) TYPE=MyISAM;

I am still getting the same error!!
Please help!

[Przemo]

Of course becouse table phpbb_groups is incomplete.

[clueless]

[Gadatliwa Kasia]

[Tech]

.

Kod:

# # Struktura tabeli dla  `phpbb_groups` # CREATE TABLE `phpbb_groups` (   `group_id` mediumint(8) NOT NULL auto_increment,   `group_type` tinyint(4) NOT NULL default '1',   `group_name` varchar(40) NOT NULL default '',   `group_description` varchar(255) NOT NULL default '',   `group_moderator` mediumint(8) NOT NULL default '0',   `group_single_user` tinyint(1) NOT NULL default '1',   `group_order` mediumint(8) NOT NULL default '0',   `group_count` int(4) unsigned default '99999999',   `group_count_enable` smallint(2) unsigned default '0',   `group_allow_email` tinyint(2) NOT NULL default '5',   `group_count_max` int(4) unsigned default '99999999',   PRIMARY KEY  (`group_id`),   KEY `group_single_user` (`group_single_user`) ) TYPE=MyISAM AUTO_INCREMENT=22248 ; # # Zrzut danych tabeli `phpbb_groups` # INSERT INTO `phpbb_groups` VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1, 0, 99999999, 0, 5, 99999999); INSERT INTO `phpbb_groups` VALUES (2, 1, 'Admin', 'Personal User', 0, 1, 0, 99999999, 0, 5, 99999999);