XF 1.5 Mysqli statement execute error : Field 'atp_dont_track_this_ext' doesn't have a default value

[UMILE]

Hello everyone. I have a big problem. I use xenforo version 1.5.19. When I create a new forum, this error appears to me
Mysqli statement execute error : Field 'atp_dont_track_this_ext' doesn't have a default value

2. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
4. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
6. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
8. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
10. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
12. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
14. XenForo_DataWriter->save() in XenForo/ControllerAdmin/Forum.php at line 129
16. XenForo_ControllerAdmin_Forum->actionSave() in XenForo/FrontController.php at line 369
18. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
20. XenForo_FrontController->run() in /web/htdocs/www.ilriparatore.com/home/forum/admin.php at line 13

in cp admin panel appear a log error:




Error info Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'atp_dont_track_this_ext' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generato Da: LINO, 9 minuti fa
Analisi dello Stack #0 /web/htdocs/www.ilriparatore.com/home/forum/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /web/htdocs/www.ilriparatore.com/home/forum/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /web/htdocs/www.ilriparatore.com/home/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_forum', Array)
#4 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/ControllerAdmin/Forum.php(129): XenForo_DataWriter->save()
#7 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/FrontController.php(369): XenForo_ControllerAdmin_Forum->actionSave()
#8 /web/htdocs/www.ilriparatore.com/home/forum/library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /web/htdocs/www.ilriparatore.com/home/forum/admin.php(13): XenForo_FrontController->run()
#10 {main}
Stato Richiesta array(3) {
["url"] => string(56) "https://www.ilriparatore.com/forum/admin.php?forums/save"
["_GET"] => array(1) {
["forums/save"] => string(0) ""
}
["_POST"] => array(21) {
["title"] => string(4) "Dump"
["node_name"] => string(0) ""
["description"] => string(0) ""
["parent_node_id"] => string(3) "272"
["display_order"] => string(1) "1"
["display_in_list"] => string(1) "1"
["allow_posting"] => string(1) "1"
["allow_poll"] => string(1) "1"
["count_messages"] => string(1) "1"
["find_new"] => string(1) "1"
["min_tags"] => string(1) "0"
["allowed_watch_notifications"] => string(3) "all"
["default_sort_order"] => string(14) "last_post_date"
["default_sort_direction"] => string(4) "desc"
["list_date_limit_days"] => string(1) "0"
["default_prefix_id"] => string(1) "0"
["node_type_id"] => string(5) "Forum"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(27) "/forum/admin.php?forums/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}




I have not installed any addons. He suddenly appeared alone. My php version is 5.6.32.
I switched to a new version of php (7.02), but nothing has changed.
how can I solve this problem?
thanks to everyone

 

[UMILE]

I resolved this problem. I reistall addon Enhanced Attachment System (EAS2).
in the list of my addons was no longer present but on my server there was still the PHC folder and all the subfolders .. I installed it again and everything works.
Unfortunately if the disistall it ,the problem occurs again. How can I do?

 

[UMILE]

I resolved this problem. I reistall addon Advanced Attachment System (AAS) On xenforo 1.5.19.
in the list of my addons was no longer present but on my server there was still the PHC folder and all the subfolders .. I installed it again and everything works.
I can not install XF2 because the problem reoccurs. How can I delete any references to this addon from the mysql tables? Pleaseeeeeeeeeeeeeee help me. Please, he shouldes help me.

 

[UMILE]

on my forum xf version is 1.5.19 and I am forced not to disable the addon because the problem occurs and I can not create forums but only categories. So you can understand that if I update xf 1.5.19 to xf2 I can not create forums in my site because that accdon accdon does not exist for xf2. The problem is that this addon is not completely removed. Traces remain in the mysql tables.

 

[UMILE]

Stack Analysis
#0 [internal function]: XF\Template\Templater->handleTemplateError(512, 'Template admin:...', 'C:\\xampp\\htdocs...', 564, Array)
#1 src\XF\Template\Templater.php(564): trigger_error('Template admin:...', 512)
#2 src\XF\Template\Templater.php(519): XF\Template\Templater->getTemplateData('admin', 'atp_seo_externa...')
#3 src\XF\Template\Templater.php(1229): XF\Template\Templater->getTemplateCode('admin', 'atp_seo_externa...')
#4 src\XF\Template\Templater.php(1304): XF\Template\Templater->renderTemplate('admin:atp_seo_e...', Array)
#5 internal_data\code_cache\templates\l3\s0\admin\option_macros.php(217): XF\Template\Templater->includeTemplate('atp_seo_externa...', Array)
#6 src\XF\Template\Templater.php(643): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array, Array)
#7 internal_data\code_cache\templates\l3\s0\admin\addon_options.php(63): XF\Template\Templater->callMacro('option_macros', 'option_row', Array, Array)
#8 src\XF\Template\Templater.php(1230): XF\Template\Templater->{closure}(Object(XF\Template\Templater), Array)
#9 src\XF\Template\Template.php(24): XF\Template\Templater->renderTemplate('admin:addon_opt...', Array)
#10 src\XF\Mvc\Renderer\Html.php(48): XF\Template\Template->render()
#11 src\XF\Mvc\Dispatcher.php(332): XF\Mvc\Renderer\Html->renderView('XF:AddOn\\Option...', 'admin:addon_opt...', Array)
#12 src\XF\Mvc\Dispatcher.php(303): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#13 src\XF\Mvc\Dispatcher.php(44): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#14 src\XF\App.php(1879): XF\Mvc\Dispatcher->run()
#15 src\XF.php(328): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}

Request Status
array(4) {
["url"] => string(45) "/admin.php?add-ons/phc_AttachmentPlus/options"
["referrer"] => string(36) "https://localhost/admin.php?add-ons/"
["_GET"] => array(1) {
["add-ons/phc_AttachmentPlus/options"] => string(0) ""
}
["_POST"] => array(0) {
}
}

 

[Ozzy47]

You need to ask the addon developer in the addon thread what the proper steps are to remove their addons.

 

[UMILE]

Xenmade has contacted me this Morning. Tnks

 

[UMILE]

XenMADE Thank you very much. I solved the problem
I run query in mysql database - XF_Forum

ALTER TABLE `xf_forum` CHANGE `atp_dont_track_this_ext` `atp_dont_track_this_ext` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''