phpBB3 SEO Sitemap

SQL error on making new forum - phpBB3 SEO Sitemap

SQL error on making new forum

by Floyd » Tue Apr 23, 2019 2:03 pm

I'm using v. 3.2.5 recently upgraded from 3.0.9. For the first time since the upgrade I attempted to create a new forum. However, I received SQL the error below. How do I fix this problem? I'm using the SEO Sitemap extension.

---------------------------------------------------------------------------------

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'forum_seo_desc' doesn't have a default value [1364]

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>Discussion of the oral treatment Mayzent for
secondary progressive MS.</t>', '', 7, '', '', '', 7, '', '', '', 0, 1, 0,
0, 1, 1, 0, 0, 7, 7, 1, 7, 1, 1, 0, 112, '82', 83)

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()
Entropy is maintenance free.
Floyd
Registered User
Posts: 84
Joined: Tue Sep 03, 2013 10:16 am

Re: SQL error on making new forum

by Floyd » Fri Apr 26, 2019 4:42 am

This issue has been solved and was unrelated to the SEO Sitemap extension.

viewtopic.php?f=556&t=2509686
Entropy is maintenance free.
Floyd
Registered User
Posts: 84
Joined: Tue Sep 03, 2013 10:16 am