Previous Thread
Next Thread
Print Thread
Hop To
error deleting spam posts #258776 10/26/2016 1:47 PM
Joined: Jun 2006
Posts: 673
BellaOnline Offline OP
old hand
OP Offline
old hand
Joined: Jun 2006
Posts: 673
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 - 57,000 members / 800,000 posts
Re: error deleting spam posts [Re: BellaOnline] #258777 10/26/2016 1:55 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
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

Last edited by id242; 10/26/2016 2:00 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
1 registered members (JAISP), 64 guests, and 350 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)