MODS.DB9.DK

[Christel]

I am having trouble with the auto_group mod. At first it worked great and now it's giving errors. I don't believe I installed another mod after this one....can anyone help me? I searched for a sollution inhere but none off them gave me the exact answer....thanks in advance!

Code: Select all

Could not insert new group

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_groups (group_type, group_name, group_description, group_moderator, group_count, group_count_max,group_count_enable, group_single_user) VALUES (2, 'Vips', 'Voor de crewmembers.....', 2, '99999999', '99999999', '' '0')

Line : 394
File : /home/virtual/site83/fst/var/www/html/forum/admin/admin_groups.php

And here you'll find the query in the admin_groups.php:

Code: Select all

else if( $mode == 'newgroup' )
                {
                        $sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_count, group_count_max,group_count_enable, group_single_user)
                                VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_count', '$group_count_max', '$group_count_enable'        '0')";
                        if ( !$db->sql_query($sql) )
                        {
                                message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);
                        }
                        $new_group_id = $db->sql_nextid();

[crinrict]

There is a comma missing in your code:


FIND:

Code: Select all

'$group_count_enable'    '0')";

REPLACE WITH

Code: Select all

'$group_count_enable', '0')";