error on forum - cant create sub-forum?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

error on forum - cant create sub-forum?

Post by behedwin »

I tried to make a new sub-forum on my board.

I got this error message.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'forum_post_tpl' 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 (23, 1, 0, '', 'Mummbi´s Corner', '', 'Dont enter here if you dont want to see those very special links Mummbi post when you least expect it.', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 0, 48, '89', 90)

BACKTRACE

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()
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

That's from your posting template MOD.

I've seen that before so there's probably a post in the support section on the page where you downloaded it on how to fix it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

gah
i had lots of mods installed

i did a wipe of all mods
by uploading a new install except the folders /files /images and the file config.php

all mods are gone
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

Have a look at the Support Toolkit too and run the database cleaner.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

the STK does not work on my board

i get this error

Code: Select all

Warning: include(STK_ROOT_PATHincludes/critical_repair.PHP_EXT): failed to open stream: No such file or directory in /customers/e/2/1/murethand.com/httpd.www/forum/includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104 Warning: include(): Failed opening 'STK_ROOT_PATHincludes/critical_repair.PHP_EXT' for inclusion (include_path='.:/usr/share/php') in /customers/e/2/1/murethand.com/httpd.www/forum/includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104 Fatal error: Class 'critical_repair' not found in /customers/e/2/1/murethand.com/httpd.www/forum/includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104 
yes im using latest version

and i have another thread about this here
http://www.phpbb.com/customise/db/offic ... 83-t_98221
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

Have a scan through here
http://www.phpbb.com/customise/db/mod/p ... 3/support/
and see if there are any topic on uninstalling that MOD because you still have something left. Make sure you've also deleted any files that were uploaded with the MOD.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

well there is no files from this mod left on my board since i uploaded a new install except the folder /files /images and file config.php

all other files are new and fresh.

no old files left

i made a post in the linked section.
hope i get some answers that way maybe
i cant find anything that i can see is discussed about my issue.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

Looks like there's a column called forum_post_tpl in the users table.
You could try deleting that.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

i take it you mean here
http://prntscr.com/70l2x
i cant find it
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

No.
In the database in phpmyadmin.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

no
there is nothing in the db with that name atall.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

Sorry not the users table, the forums table.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

um i dont understand how to delete that column

http://prntscr.com/70lqz
http://prntscr.com/70ls9
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70271
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: error on forum - cant create sub-forum?

Post by KevC »

At the top of the page you should have a tab called structure.

That will allow you to see all of the fields used to make the table.
You can then select that specific one and delete it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
behedwin
Registered User
Posts: 176
Joined: Tue Mar 15, 2011 9:02 pm

Re: error on forum - cant create sub-forum?

Post by behedwin »

woooweee

it works now

thanks allot.

i rly hope i get the database cleaner to work to remove kinks likes this.
Locked

Return to “[3.0.x] Support Forum”