Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-2723 now.

SQL error when creating a new group (fix completed in vcs)

I just tried to create a new user group and got this error. This is from yesterday's CVS.

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Unknown column 'group_manage_founder' in 'field list' [1054]

SQL

SELECT group_manage_founder FROM phpbb_cvs_groups WHERE group_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 132
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_groups.php
LINE: 369
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 402
CALL: acp_groups->main()

FILE: adm/index.php
LINE: 83
CALL: p_master->load_active()

Comments / History

Posted by agent00shoe on Jan 4th 2007, 02:03

The group was created despite the error. I can also change the "Founder manage only" option without any errors now.

The column in the error is group_manage_founder, but the actual column name in the db is group_founder_manage so I guess someone forgot to change that somewhere.(?)

Posted by VinDuv on Jan 4th 2007, 06:55

agent00shoe wrote:The column in the error is group_manage_founder, but the actual column name in the db is group_founder_manage so I guess someone forgot to change that somewhere.(?)
Probably in includes/acp/acp_groups.php, line 369 Wink
Code: Select all
$sql = 'SELECT group_manage_founder
   FROM ' . GROUPS_TABLE . '
         WHERE group_id = ' . $group_perm_from;
$result = $db->sql_query($sql);

Posted by agent00shoe on Jan 4th 2007, 12:23

I didn't feel like tracking it down. Razz

Linked ticket with changeset: r6839

Action performed by Anonymous (I am too lazy to register) on Jan 4th 2007, 16:07

Ticket details

Related SVN changesets