phpBB • Free and Open Source Forum Software

allen62 · by **allen62** » Thu Jun 04, 2015 1:51 pm

hi
i was using phpbb3 version 3.0.12 and i upgrade it to 3.1.3 aabout a month ago everything is working fine just some problem with creating new forums whenever i try to create new forum it will give me this error

i posted here : viewtopic.php?f=456&t=2284951&p=14079921#p14079921 here : viewtopic.php?f=466&t=2310056&p=14038846#p14038846 and here : https://www.phpbb.com/customise/db/exte ... pic/142716
they told me to post here . i need help i am trying to solve this issue from one month so plz someone give me solution . thanx

5hocK · by **5hocK** » Fri Jun 05, 2015 7:01 pm

The errors look like it's an extension, not a Mod installed, this one https://www.phpbb.com/customise/db/exte ... emplate_4/
(easier if you post the code, not an image as posted code can be copy/pasted for searching)

When you were using 3.0.12, did you have the Mod version installed? Did you remove all Mods before you updated to 3.1.x?

allen62 · by **allen62** » Sat Jun 06, 2015 3:03 am

this was my problem i was new to phpbb3 that time i dont know to remove all mods i upgrade it with mods second i post in posting tempelate extension also they told me its mod issue . now i cant put new database plz help me .

Re: [RC] Posting Template
Postby martti » Mon May 18, 2015 8:25 am

allen62 wrote:
i have some issue with this extension . while try to create new forums it will give me error details are here viewtopic.php?f=466&t=2310056

This extension has no column in the forums table. A quick Google search reveals the column forum_post_tpl is from the MOD Posting Template.

Re: general error while creating new forums
Postby Oyabun1 » Sat May 02, 2015 6:37 am

here are my posts links : https://www.phpbb.com/community/viewtopic.php?f=456&t=2284951&p=14079921#p14079921
https://www.phpbb.com/customise/db/extension/posting_template_4/support/topic/142716

That would be the support forum for whichever posting template MOD you had, not here.

allen62 · by **allen62** » Sat Jun 06, 2015 3:07 am

here is error i copy paste it

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, enable_shadow_prune, prune_days, prune_viewed, prune_freq, prune_shadow_days, prune_shadow_freq, forum_recent_topics, forum_allow_solve, forum_allow_unsolve, forum_solve_text, forum_solve_color, forum_lock_solved, forum_options, forum_flags, left_id, right_id) VALUES (0, 1, 0, '', 'test', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 0, 7, 7, 1, 7, 1, 1, 1, 1, '', '', 0, 0, 48, 51, 52)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1125
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 199
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

5hocK · by **5hocK** » Sat Jun 06, 2015 2:17 pm

There is a way to remove all mods but you have to delete all your extensions first, just put them back after as it's easy to do

Follow the instructions in this post viewtopic.php?f=466&t=2304631#p14002471
Used this myself and it works wonderfully.

allen62 · by **allen62** » Sun Jun 07, 2015 7:55 am

bro i follow procedure . still same error while creating new forums . then i update data base i purge cache same error . when i was disabling/deleting extenions only one externsion was not deleting name "Xfirecpf"
plz i need solution thanx

RMcGirr83 · by **RMcGirr83** » Sun Jun 07, 2015 11:05 am

Within phpmyadmin go to your forums table (eg, phpbb_forums) and delete the forum_post_tpl field completely from the database. Make sure you have a backup of the database first though.

allen62 · by **allen62** » Sun Jun 07, 2015 12:57 pm

Thank you very much @RMcGirr83 and @5hocK for help problem is fixed now

YOUAREtehSCENE · by **YOUAREtehSCENE** » Mon Jul 18, 2016 9:44 pm

Doesn't work with new version of board right?

Posting Template

issue with this mod - Posting Template