I recently upgraded my forum to the 3.1 series. This is the first time I tried to create a new forum after doing so, and I got this error:
Code: Select all
General Error SQL ERROR [ mysqli ] Field 'hide_attr' doesn't have a default value  SQL INSERT INTO MYPHPBB_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, enable_shadow_prune, prune_days, prune_viewed, prune_freq, prune_shadow_days, prune_shadow_freq, forum_options, forum_flags, left_id, right_id) VALUES (10, 1, 0, '', 'NEW FORUM NAME', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 0, 7, 7, 1, 7, 1, 0, 80, '120', 121) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 855 CALL: trigger_error() FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 329 CALL: phpbb\db\driver\mysqli->sql_query() FILE: [ROOT]/includes/acp/acp_forums.php LINE: 1125 CALL: phpbb\db\driver\factory->sql_query() FILE: [ROOT]/includes/acp/acp_forums.php LINE: 199 CALL: acp_forums->update_forum_data() FILE: [ROOT]/includes/functions_module.php LINE: 674 CALL: acp_forums->main() FILE: [ROOT]/adm/index.php LINE: 81 CALL: p_master->load_active()
to drop that column, and I was able to create my forum successfully. My question is now: Is there something else I should do now to prevent problems in the future?
Any help would be great!