UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support error deleting spam posts

I'm guessing my forum has gotten too large and my numbers are no longer integers? When I attempt to delete a spam post I often get this error now:

Line#: 377
SQL Error: Incorrect integer value: '' for column 'FORUM_LAST_POST_ID' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_FORUMS SET FORUM_LAST_POSTER_ID = 0 , FORUM_LAST_TOPIC_ID = 0 , FORUM_LAST_POST_ID = '' , FORUM_LAST_POST_TIME = '' , FORUM_LAST_POSTER_NAME = '' , FORUM_LAST_POST_SUBJECT = '' , FORUM_LAST_POST_ICON = '' , FORUM_TOPICS = 1446 , FORUM_POSTS = 20642 WHERE FORUM_ID = 17

Thoughts?

You may have tables that were exported and imported between formats over the years which is causing the tables to lose their intended format Some of them may be set to latin1_swedish.

set your character set to UTF8 and collate to utf8_unicode_ci

Example:
ALTER TABLE $table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

EDIT:
research "SQL Error 1366"

Also read through this, since you are running your forums using MICROSOFT WINDOWS.
http://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors