hide_attr error on 3.1 series

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
Diego898
Registered User
Posts: 113
Joined: Mon Oct 18, 2004 9:31 pm

hide_attr error on 3.1 series

Post by 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!
User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 8978
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: hide_attr error on 3.1 series

Post by Raul [ThE KuKa] »

Diego898 wrote:......................
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 ;)
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


Diego898
Registered User
Posts: 113
Joined: Mon Oct 18, 2004 9:31 pm

Re: hide_attr error on 3.1 series

Post by Diego898 »

agreed! What can I do now?
User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 8978
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: hide_attr error on 3.1 series

Post by 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
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Lumpy Burgertushie
Registered User
Posts: 68474
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: hide_attr error on 3.1 series

Post by Lumpy Burgertushie »

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

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: hide_attr error on 3.1 series

Post by Oyabun1 »

Lumpy Burgertushie wrote: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.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Locked

Return to “[3.1.x] Support Forum”