SQL errors on new forum creation

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Floyd
Registered User
Posts: 85
Joined: Tue Sep 03, 2013 10:16 am

SQL errors on new forum creation

Post by Floyd » Thu Apr 25, 2019 11:45 am

To moderators, please accept this repost. It is a follow-up to my prior post on this issue.
viewtopic.php?f=556&t=2509566

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 [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>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()
This error message appears to be stating that there are fields in the phpbb_forums table which are no longer used. We used a different SEO extension then that was not carried over to the upgrade with 3.2.5. Specifically, this error message reports that the 'forum_seo_bottom' field is not being updated as it's no longer being used by the currently installed extensions.


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?
Last edited by Floyd on Thu Apr 25, 2019 12:43 pm, edited 1 time in total.
Entropy is maintenance free.

User avatar
david63
Registered User
Posts: 16401
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: SQL errors on new forum creation

Post by david63 » Thu Apr 25, 2019 12:19 pm

Floyd wrote:
Thu Apr 25, 2019 11:45 am
how do we clean out these no longer used fields from the database table?
Manually delete them from the database using phpMyAdmin (or equivalent) after having made a backup of your database
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
EA117
Registered User
Posts: 829
Joined: Wed Aug 15, 2018 3:23 am
Contact:

Re: SQL errors on new forum creation

Post by EA117 » Thu Apr 25, 2019 4:44 pm

Floyd wrote:
Thu Apr 25, 2019 11:45 am
We were using phpBB 3.0.9 and recently upgraded to 3.2.5.
Depending on what exactly "recently" means, note that removal of non-standard database fields such as this forum_seo_bottom column is what the STK database cleanup step is all about in the 3.0.x to 3.2.x upgrade instructions. If you "just did the upgrade", maybe running through the upgrade once more and making sure the STK database cleanup removes this and other non-standard fields is warranted.

But even if you can't or don't want to re-do the actual live upgrade due to the forum having been in-use for a while, you might consider whether it would be worth setting up a restore of your 3.0.9 board and database locally under XAMPP or similar. Just to run the STK database cleaner and see what other fields besides this forum_seo_bottom column the STK identifies to be removed. To give you a heads-up on what other leftover information might give you trouble later, and/or that you could remove now manually too. (Presuming the same field has not been created or used now by an extension that has been installed post-upgrade.)

Note to run 3.0.x or the STK you would have to setup a local XAMPP environment running PHP 5.x, rather than the latest.

Floyd
Registered User
Posts: 85
Joined: Tue Sep 03, 2013 10:16 am

Re: SQL errors on new forum creation

Post by Floyd » Thu Apr 25, 2019 8:43 pm

Thank you for the reply. The upgrade to 3.2.5 was done in early January.

The forum is 15 years old (we started with phpNuke) and has been through a few upgrades. Rather than wade through the weeds and try to rip out deprecated table fields, we just added a default value for the forum_seo_bottom field. The process of adding a new forum now works.
Entropy is maintenance free.

Post Reply

Return to “[3.2.x] Support Forum”