XF 2.1 Unused 1.5.7 add-on creating errors on 2.1.4 on new thread creation

[Hobbes]

I'm getting this error any time I try to create a new thread on our newly updated forum (version 2.1.4.) We upgraded from 1.5.7 recently and this was part of a "Best Answers" add-on that we actually NEVER used, but even with it disabled after the upgrade, it's throwing out this weird error when we try creating any threads.

Any ideas what to do here?

 

[Hobbes]

If it helps for troubleshooting, I believe it was this resource (which has been deleted.)

Mark Posts as Best Answer [Deleted]

Lior. submitted a new resource: Mark Posts as Best Answer - Allows users to mark a post in their threads as best answer. This add-on allows thread creators to mark a post as the best answer among all other answers. The selected best answer is displayed at the top of the thread, as the first...

xenforo.com

I found this thread on here:

XF 1.4 - Failed install "Mark Posts as Best Answer" - can't create new threads?

I tried to install v 1.5.1 of the addon "Mark Posts as Best Answer" today together with XF 1.4.2. The installation failed after about ~3 seconds displaying this: Server Error Mysqli statement execute error : Got error 64 'Temp file write failure' from InnoDB...

xenforo.com

And this was a suggestion:

I had a similar error and this thread was the top google result (and the page with the solution was around 10)... So for anyone else who finds it: the fix is either to alter the field in db so a default value is not required (or set a default) or comment out a line in the my.ini/cnf to disable STRICT_TRANS_TABLES SQL.

http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

 

[Hobbes]

Hey, enough noodling around got 'er fixed lol! Ended up using PHPmyAdmin to delete the entry from the table, fixed it right up (in case anyone else ever has this issue.)