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

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

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

Post by MarcB » Sun Dec 12, 2010 7:37 pm

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 :cry:

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]

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69470
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by KevC » Sun Dec 12, 2010 9:27 pm

You need to ask in the topic or support section for that MOD.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by MarcB » Mon Dec 13, 2010 7:26 am

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 :?:

User avatar
AmigoJack
Registered User
Posts: 5661
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by AmigoJack » Mon Dec 13, 2010 9:06 am

Simply execute this SQL command:

Code: Select all

ALTER TABLE phpbb3_forums ALTER COLUMN forum_sponsor SET DEFAULT ''
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by MarcB » Mon Dec 13, 2010 11:53 am

AmigoJack wrote: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?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69470
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by KevC » Mon Dec 13, 2010 11:58 am

It's this MOD.
You need to ask here.
http://www.phpbb.com/customise/db/mod/f ... r/support/
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by MarcB » Mon Dec 13, 2010 6:20 pm

AmigoJack wrote:Simply execute this SQL command:

Code: Select all

ALTER TABLE phpbb3_forums ALTER COLUMN forum_sponsor SET DEFAULT ''
Thanks, this did the trick :)

Kevin Clark wrote: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 :)

User avatar
postcd
Registered User
Posts: 83
Joined: Sun Oct 14, 2007 3:42 pm
Contact:

Re: Field 'forum_sponsor' doesn't have a default value [1364

Post by postcd » Sun Jul 17, 2011 5:18 pm

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. :idea:
I have Health Forum and also webmaster Hosting Forum. Interested in making money? Try money maker forum.

Locked

Return to “[3.0.x] Support Forum”