SQL error. Cannot add a category

[Kilzin]

Support Request Template
What version of phpBB are you using? phpBB 3.0.5
What is your board's URL? No answer given
Who do you host your board with? Byethost
How did you install your board? I used a tool provided by my host
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? No
What MODs do you have installed? Board3Portal, WoW Raid Progression, AutoMOD, User blog MOD and PHPbb Gallery. Has remove Forum Sponsor by AutoMOD
What styles do you currently have installed? SE Pro
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
When did your problem begin? Few days ago
Please describe your problem. I has remove a MOD "Forum Sponsor" by AutoMOD. When I try add a category in the ACP then I got this error message:

SQL ERROR [ mysql4 ]

Field 'forum_sponsor' 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_flags, left_id, right_id) VALUES (0, 0, 0, '', 'Announcements', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 32, 45, 46)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1032
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 181
CALL: acp_forums->update_forum_data()

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

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

How I can solve problem?
Generated by SRT Generator ($Rev: 3603 $)

[Stoepsel]

Edit: Removed link to KB article on default value errors since it only applies to standard phpBB database fields and not to fields added by MODs.

[Brf]

That added column is not contained in that code anymore, so the Mod code has been removed OK.

You need to go into phpmyAdmin and remove that forum_sponsor column from the phpbb_forum tables

[Kilzin]

I cannot find forum_sponsor column into phpmyadmin. How can I find it?

EDIT: I have found the table and remove it. Now I can add category! Thanks for help!

[Lumpy Burgertushie]

the phpbb_forums table, click the browse tab and look for that field.


robert