Support No Answer Media of the Month

[wickedstangs]

Need help removing app from Xenforo 2.0

XF\Db\Exception: MySQL query error [1364]: Field 'xfa_motm_thread_id' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 160
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1389
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1121
XF\Mvc\Entity\Entity->save() in src/addons/XFMG/Service/Album/Creator.php at line 136
XFMG\Service\Album\Creator->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
XFMG\Service\Album\Creator->save() in src/addons/XFMG/Pub/Controller/Media.php at line 850
XFMG\Pub\Controller\Media->getContainerToSaveMedia() insrc/addons/XFMG/Pub/Controller/Media.php at line 687
XFMG\Pub\Controller\Media->actionSaveMedia() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 328
XF::runApp() in index.php at line 13

 

[Clement]

Go in the db, edit the xf_thread table and change xfa_motm_thread_id to add a default value.

 

[wickedstangs]

Go in the db, edit the xf_thread table and change xfa_motm_thread_id to add a default value.

I could not find xfa_motm_thread_id

I did find this xengallery_xfa_motm_vote

 

[Clement]

No no sorry it's in xf_mg_media

 

[wickedstangs]

No no sorry it's in xf_mg_media

Which one?

 

[Clement]

xf_mg_media_item

 

[wickedstangs]

xf_mg_media_item

do I drop it?

 

[Clement]

The table ? Hell no !

The column I pointed out, ie. xfa_motm_thread_id, in it yes.