Previous Thread
Next Thread
Print Thread
Hop To
error deleting spam posts
#258776 10/26/2016 2:47 PM
Joined: Jun 2006
Posts: 686
Addict
OP Offline
Addict
Joined: Jun 2006
Posts: 686
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
BellaOnline #258777 10/26/2016 2:55 PM
Joined: Apr 2004
Posts: 1,700
Likes: 50
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,700
Likes: 50
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 3:00 PM.

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

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
[NOTABUG] Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
Who's Online Now
2 members (Gizmo, 1 invisible), 94 guests, and 71 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
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