Error Upon Attempted Creation of New Category

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Spineless Mike
Registered User
Posts: 7
Joined: Wed Feb 13, 2013 6:55 pm

Error Upon Attempted Creation of New Category

Post by Spineless Mike »

Recently, I've been playing with trying to install mods to my forum.
I backed up my files and began playing. I screwed around and messed it up right good and then just overwrote the screwup with my old files and went back to normal. Now, a few weeks later, I tried to create a new category and got this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'hide_attr' 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, prune_days, prune_viewed, prune_freq, forum_options, forum_flags, left_id, right_id) VALUES (0, 0, 0, '', 'text', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 0, 32, 137, 138)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1017
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 186
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
Being the newbie at forum work that I am, I have no idea what this means or what I've screwed up.
I was hoping that I could just google it, but I haven' found the solution anywhere. Is there some file that's corrupt that I can just replace, or is it a bigger problem?

Any help is appreciated.
Tots,
S Mike
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Error Upon Attempted Creation of New Category

Post by Oyabun1 »

To receive MOD support please visit our Customisations Database and post in the specific MOD’s designated support area. The link to the support area for each released MOD is also available in the first post of each released MOD listed in the MOD Database Releases forum.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Spineless Mike
Registered User
Posts: 7
Joined: Wed Feb 13, 2013 6:55 pm

Re: Error Upon Attempted Creation of New Category

Post by Spineless Mike »

I'm not requesting help with a mod, I'm simply saying that I was working with mods a few weeks ago and I might have messed something up while I was rooting around in the files.

I just want to know what file is corrupt so that I can replace it. The error report doesn't help me because I can't find any of the files mentioned (possibly part of the problem.)

This is to do with the Admin Control Panel, the forum functions as it should and no mods are installed on my board.
Janet Ward
I've Been Banned!
Posts: 64
Joined: Sun Feb 10, 2013 2:45 am

Re: Error Upon Attempted Creation of New Category

Post by Janet Ward »

The field hide_attr, from the little I do know about phpBB, isn't a default field in a phpBB Install (I think)

Google Search - phpBB General Error Doesn't Have a Default Value
User avatar
Lumpy Burgertushie
Registered User
Posts: 68479
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Error Upon Attempted Creation of New Category

Post by Lumpy Burgertushie »

that error is related to one of the MODs you attempted to install and then uninstall.

you need to go back through whatever those MODs were and make sure you removed all the changes from it.


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?
Spineless Mike
Registered User
Posts: 7
Joined: Wed Feb 13, 2013 6:55 pm

Re: Error Upon Attempted Creation of New Category

Post by Spineless Mike »

Lumpy Burgertushie wrote:that error is related to one of the MODs you attempted to install and then uninstall.

you need to go back through whatever those MODs were and make sure you removed all the changes from it.


robert
Okay, I'll try that.
Unfortunately, I used Automod to install and uninstall, and that turned out to be quite the hassle, so I'm sure this won't be any easier.
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Error Upon Attempted Creation of New Category

Post by HGN »

This specific error means that the phpbb_forums table (in the database) has a column (field) hide_attr that is not being written when creating a new forum. Since the field does not have a default value defined in the database, it will error on that.
The column is probably added by the Quick Title edition MOD. The code writing to the field is removed, but the column is still in the database.

You can remove this column by running following query using phpMyAdmin
(Executing SQL Queries in phpMyAdmin):

Code: Select all

ALTER TABLE phpbb_forums DROP COLUMN hide_attr;
Spineless Mike
Registered User
Posts: 7
Joined: Wed Feb 13, 2013 6:55 pm

Re: Error Upon Attempted Creation of New Category

Post by Spineless Mike »

HGN wrote:This specific error means that the phpbb_forums table (in the database) has a column (field) hide_attr that is not being written when creating a new forum. Since the field does not have a default value defined in the database, it will error on that.
The column is probably added by the Quick Title edition MOD. The code writing to the field is removed, but the column is still in the database.

You can remove this column by running following query using phpMyAdmin
(Executing SQL Queries in phpMyAdmin):

Code: Select all

ALTER TABLE phpbb_forums DROP COLUMN hide_attr;
Yousir, are my hero <3

Thank you very much for your help, this worked perfectly and I can freely create categories and forums again.
User avatar
Lumpy Burgertushie
Registered User
Posts: 68479
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Error Upon Attempted Creation of New Category

Post by Lumpy Burgertushie »

good work,

now, it wouldn't hurt to go back to the install instructions ( .xml file ) for that MOD and make sure it is completely uninstalled.

just follow the instructions backwards to make sure that all the file edits are gone.


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?
Spineless Mike
Registered User
Posts: 7
Joined: Wed Feb 13, 2013 6:55 pm

Re: Error Upon Attempted Creation of New Category

Post by Spineless Mike »

I've finally got it all straight in my head and have done just that. Completely uninstalled everything and gotten it all straightened out. Hopefully there won't be any more problems ^_^'
Locked

Return to “[3.0.x] Support Forum”