Error Upon Attempted Creation of New Category

[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

[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.

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

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

[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

[Spineless Mike]

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.

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

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.

[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

[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 ^_^'