hide_attr error on 3.1 series

[Diego898]

Hello,

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 [1364]

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()

Upon searching, I see this is part of the "Quick Title" MOD. I wasn't sure how to proceed as I don't think I can reinstall/uninstall this MOD on the 3.1 series. However, I ran the query as specified in this answer: viewtopic.php?f=46&t=2172277#p13241629

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!

[Raul [ThE KuKa]]

......................
My question is now: Is there something else I should do now to prevent problems in the future?

The error comes from 3.0.x installation, should have removed all MODs before upgrading to 3.1.x

[Diego898]

agreed! What can I do now?

[Raul [ThE KuKa]]

Ummm, you should be prepared before the forum, not after...

For my part, I delete all additional tables and fields with STK.

Read this: viewtopic.php?p=14211041#p14211041

[Lumpy Burgertushie]

however, since it is too late for using the STK you have to do this:
viewtopic.php?p=13859361#p13859361

robert

[Oyabun1]

however, since it is too late for using the STK you have to do this:
viewtopic.php?p=13859361#p13859361

That will solve other problems likely to be encountered.

For this specific problem, which isn't caused by left over modules or permissions, the easiest solution is to delete the offending column from the database. Without the MOD it won't be needed anymore. Run this query:

Code: Select all

ALTER TABLE MYPHPBB_forums DROP COLUMN hide_attr

Always backup the database before making any changes to it.

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running queries.