This is a continuation of post:
https://www.ubbcentral.com/forums/u...-cant-delete-or-add-new-forum#Post264008

After getting forum deletes and creates working.
I decided to run the re builders starting with Posts.
Well I get a error on some very large posts.
Path was edited for security.
Code
Script: content_rebuild.inc.php - Line: 89
UPDATE ubbt_POSTS

Data too long for column 'POST_BODY' at row 1

Yes strict mode is enabled.
In phpmyadmin in variables I see for sql mode:
Code
ONLY_FULL_GROUP_BY,​STRICT_TRANS_TABLES,​NO_ZERO_IN_DATE,​NO_ZERO_DATE,​ERROR_FOR_DIVISION_BY_ZERO,​NO_AUTO_CREATE_USER,​NO_ENGINE_SUBSTITUTION
7/15/2020 change
​NO_ENGINE_SUBSTITUTION
I am not sure if I can edit that setting.

Posts table post_body as well as post default body is set to
Code
type text
length/values
Default NULL
Collation utf8mb4_general_ci
Attributes
NULL checked
A_I unchecked
Comments
Viruality
Move column
All values with no entry are blank

Now I did use the built in tool to convert to utf8mb4

There is more than one post because I deleted the first two.
And I still get the error after it passes the last one I deleted.
But there are unknown more of them.
Post count is 415506 and I only get to like 185.000 when the error occurs.
As I said they are extremely long posts.

At this point I am not sure if this is a bug or hosting issue or operator error or changing to utf8mb4..

All I know is this site has been upgraded over the years and it is now on UBB7.7.4 and it has a lot of posts to run through.

If you want to see the full error it is very long, but I can post it.
Did I say the posts are large?

Blue Man Group
There is no such thing as stupid questions. Just stupid answers