SQL Forum Edit Error PHPBB3

[terryh]

Hi, when I edit a forum in the ACP, I get this error:

SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb3_forums SET parent_id = 0, forum_type = 0, forum_status = 0, forum_parents = '', forum_name = 'Services', forum_link = '', forum_desc = '', forum_desc_uid = '', forum_desc_options = 7, forum_desc_bitfield = '', forum_post_tpl = '', forum_rules = '', forum_rules_uid = '', forum_rules_options = 7, forum_rules_bitfield = '', forum_rules_link = '', forum_image = '', forum_style = 0, display_subforum_list = 1, display_on_index = 0, forum_topics_per_page = 0, enable_indexing = 1, enable_icons = 0, enable_prune = 0, prune_days = 7, prune_viewed = 7, prune_freq = 1, forum_pertopic = 5, forum_perpost = 2, forum_peredit = 0, forum_flags = 32 WHERE forum_id = 31

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1265
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 197
CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

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

How can I fix it?

PS: I recently had the posting template mod installed.

 

[CyberFreak]

Have you ran the SQL query given in the install file?

 

[Nathan]

As Fowler has said, the query that needs to be run for the mod to work and also fix your error is:

ALTER TABLE phpbb_forums ADD forum_post_tpl TEXT DEFAULT '' NULL;

 

[terryh]

Thanks, it worked =)