Moreover, I have blanked out my post on the SEO Sitemap extension forum as I do not believe that extension is related to the error message that's generated when I attempt to make a new forum.
https://www.phpbb.com/customise/db/exte ... pic/203561
We were using phpBB 3.0.9 and recently upgraded to 3.2.5. I have received the following error message when I attempt to make a new forum.
Code: Select all
General Error SQL ERROR [ mysqli ] *Field 'forum_seo_bottom' doesn't have a default value * SQL INSERT INTO phpbb_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_recent_topics, forum_options, forum_flags, left_id, right_id) VALUES (47, 1, 0, '', 'Mayzent (Siponimod)', '', '<t>Mayzent is an oral treatment for secondary<br/>\nprogressive MS.</t>', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 1, 0, 0, 7, 7, 1, 7, 1, 1, 0, 112, '90', 91) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 997 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: 1149 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: 676 CALL: acp_forums->main() FILE: [ROOT]/adm/index.php LINE: 82 CALL: p_master->load_active()
I believe that the old SEO extension was simply named phpBB SEO though I cannot locate it at this time.
The relevant question now appears to be this, how do we clean out these no longer used fields from the database table?