SQL error. Cannot add a 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.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Kilzin
Registered User
Posts: 22
Joined: Wed Jan 13, 2010 4:53 am
Location: Örebro, Sweden

SQL error. Cannot add a category

Post by 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 $)
Last edited by ric323 on Mon Jan 25, 2010 6:22 am, edited 1 time in total.
Reason: Topic icon changed
Sorry for bad english. Im swedish and have little problem with english :P
Stoepsel
Registered User
Posts: 395
Joined: Sun Oct 23, 2005 11:23 am

Re: SQL error. Cannot add a category

Post by 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.
Last edited by Stoepsel on Sun Jan 24, 2010 11:03 am, edited 1 time in total.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52310
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL error. Cannot add a category

Post by 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
User avatar
Kilzin
Registered User
Posts: 22
Joined: Wed Jan 13, 2010 4:53 am
Location: Örebro, Sweden

Re: SQL error. Cannot add a category

Post by 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!
Last edited by Kilzin on Mon Jan 25, 2010 6:16 am, edited 1 time in total.
Sorry for bad english. Im swedish and have little problem with english :P
User avatar
Lumpy Burgertushie
Registered User
Posts: 68564
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: SQL error. Cannot add a category

Post by Lumpy Burgertushie »

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


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

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Locked

Return to “[3.0.x] Support Forum”