Warning: The author of this contribution does not provide support for it anymore.

Posting Template

issue with this mod - Posting Template

issue with this mod

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
Image
Image
allen62
Registered User
Posts: 24
Joined: Wed Oct 15, 2014 8:29 am
Name: Allen 62

Re: issue with this mod

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?
5hocK
Registered User
Posts: 3139
Joined: Wed Nov 23, 2011 7:00 pm
Location: UK

Re: issue with this mod

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
Registered User
Posts: 24
Joined: Wed Oct 15, 2014 8:29 am
Name: Allen 62

Re: issue with this mod

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()
allen62
Registered User
Posts: 24
Joined: Wed Oct 15, 2014 8:29 am
Name: Allen 62

Re: issue with this mod

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.
5hocK
Registered User
Posts: 3139
Joined: Wed Nov 23, 2011 7:00 pm
Location: UK

Re: issue with this mod

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
allen62
Registered User
Posts: 24
Joined: Wed Oct 15, 2014 8:29 am
Name: Allen 62

Re: issue with this mod

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.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
RMcGirr83
Former Team Member
Posts: 22025
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: issue with this mod

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

Thank you very much @RMcGirr83 and @5hocK for help problem is fixed now :D
allen62
Registered User
Posts: 24
Joined: Wed Oct 15, 2014 8:29 am
Name: Allen 62

Re: issue with this mod

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

Doesn't work with new version of board right?
YOUAREtehSCENE
Registered User
Posts: 194
Joined: Wed Feb 11, 2009 3:35 am
Location: Boston, Mass