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?


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts