Field 'forum_sponsor' doesn't have a default value [1364]

[MarcB]

Support Request Template
What version of phpBB are you using? phpBB 3.0.7
What is your board's URL? http://www.blackbirdownersclub.eu/phpBB3
Who do you host your board with? No answer given
How did you install your board? I used the download package from phpBB.com
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? Yes
What MODs do you have installed? Board3 Portal v1.0.5
What styles do you currently have installed? Prosilver and Subsilver
What language(s) is your board currently using? Dutch
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? When creating a new sub forum
Please describe your problem.
When creating a new subforum, following error shows up, unfortunately the steps described on http://www.phpbb.com/kb/article/doesnt- ... ue-errors/ did not solve the problem

Code: Select all

Algemene fout
SQL ERROR [ mysqli ]

Field 'forum_sponsor' doesn't have a default value [1364]

SQL

INSERT INTO phpbb3_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 (32, 1, 0, '', 'Activiteitenkalender 2011', '', 'De tour ritten en treffens van 2011.\nDit forum is read only!', '', 7, '', '', '', 7, '', '', '', 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 50, '92', 93)

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1018
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 186
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()
[size=60]Generated by SRT Generator ($Rev: 4502 $)[/size]

[KevC]

You need to ask in the topic or support section for that MOD.

[MarcB]

The only mod installed is the portal from Board3.de. I didn't find any relation to the forum_sponsor fields with this mod. Perhaps it is still something that was inherited from years ago when others were managing our board.

Is it perhaps an option to remove all fields from the database that are not originally created by phpBB software? I do have to upgrade to version 3.08 and can make an export of the database. Before doing so remove all non standard phpBB fields from the database and then import into phpBB 3.08. After that, install the portal from Board3.de

[AmigoJack]

Simply execute this SQL command:

Code: Select all

ALTER TABLE phpbb3_forums ALTER COLUMN forum_sponsor SET DEFAULT ''

[MarcB]

Simply execute this SQL command:

Code: Select all

ALTER TABLE phpbb3_forums ALTER COLUMN forum_sponsor SET DEFAULT ''

Last evening I tried to change the Default value using phpmyadmin, selected the database and used the edit tool. However, I could not enter any value like "0" or "Null". The system came back with an error message that no value could be entered. Is this SQL command doing the same thing?

[KevC]

It's this MOD.
You need to ask here.
http://www.phpbb.com/customise/db/mod/f ... r/support/

[MarcB]

Simply execute this SQL command:

Code: Select all

ALTER TABLE phpbb3_forums ALTER COLUMN forum_sponsor SET DEFAULT ''

Thanks, this did the trick

It's this MOD.
You need to ask here.
http://www.phpbb.com/customise/db/mod/f ... r/support/

Thanks for the info, I will raise the question on how to get rid of the "left overs" from long time ago

[postcd]

I downloaded new 1.0.1 Mod version and copied all mod files and followed all install instructions again. Then no install.php was needed to execute and it works again.