Bug Fixed When add-on is disabled, Get errors and unable to post...

[Paul]

Hi,
Currently running 2.2.1 - When i disabled the Mod i was getting the following :


Corresponding server log error :

[LIST]
[*]XF\Db\Exception: MySQL query error [1364]: Field 'xfa_fss_shipping' doesn't have a default value
[*]src/XF/Db/AbstractStatement.php:217
[*]Generated by: Paul
[*]May 19, 2019 at 6:59 PM
[/LIST]
Stack trace
INSERT  INTO `xf_thread` (`node_id`, `user_id`, `username`, `discussion_state`, `title`, `discussion_open`, `sticky`, `post_date`, `last_post_date`, `last_post_user_id`, `last_post_username`, `thread_id`, `reply_count`, `view_count`, `discussion_type`, `first_post_id`, `last_post_id`, `first_post_reaction_score`, `first_post_reactions`, `prefix_id`, `custom_fields`, `tags`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1364, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1364, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(221): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_thread', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/Thread/Creator.php(285): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\Thread\Creator->_save()
#8 src/XF/Pub/Controller/Forum.php(750): XF\Service\Thread\Creator->save()
#9 src/addons/EWR/Atendo/Pub/Controller/Forum.php(32): XF\Pub\Controller\Forum->actionPostThread(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(321): EWR\Atendo\Pub\Controller\Forum->actionPostThread(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'PostThread', Object(XF\Mvc\RouteMatch), Object(EWR\Porta\Pub\Controller\Forum), NULL)
#12 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(EWR\Porta\Pub\Controller\Forum), NULL)
#13 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#15 src/XF.php(390): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}

Thanks
Paul

 

[Clement]

Was it a new install or an upgrade from xF1 ?

 

[Paul]

Hiya MtoR,
Was a new install around the back end of last year....Deffo not an Xf1 install upgrade..

 

[Clement]

I'll have to check and fix the bug in the next release

 

[Paul]

Thank you !!

 

[Paul]

Any idea when that might be MtoR please??

 

[Clement]

I can't tell you exactly.
Soon for sure.

 

[Paul]

Hi @MtoR,
Any news on this please? I would like to be able to successfully uninstall this without it causing the SQL error i was seeing above, and it's been a couple of months since my request...
Thanks
Paul

 

[Clement]

I totally missed that one sorry.
I'll check out.

 

[Paul]

I totally missed that one sorry.
I'll check out.

Many thanks @MtoR