UBB.threads PHP Forum Software Community Forums Thread Like Summary - 7.7.4 error on rebuilders

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.

Yes strict mode is enabled.
In phpmyadmin in variables I see for sql mode:
I am not sure if I can edit that setting.

Posts table post_body as well as post default body is set to
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?

For many years, nothing was changed with that regard, except your server side database (MySQL) and your scripting language (PHP) versions and their configurations.

For example, within the php config of UBBCentral's server, 65,380 is the char limit for the display of posts (txt blobs), even though a higher number of chars can be stored within the database. an example post within a private forum

Something that I do not believe existed previously, but can be added for a future version, is an "overflow trigger." One that will warn the user of their post being too large. Also adding content-truncation during the post content rebuild process (admin tools)

I will try to evaluate but I kinda walked into this.
This is a shared hosting account. So I do not have access to everything I would like.
And of course I have no history on what the host has done.
I also have no idea who or what was changed over the years.
All I know is it was updated over the years per the owner.
And I did the current update to 7.7.4 from 7.6X
The only modifications I did was shorten the refresh time for the wol page and changing post body and post default body in the posts table to longtext..
So the re builders would complete.
Of course I did have to do some DB diving to fix the corrupted/orphaned forums from past deletions that were never successful

It appears it is working correctly for now and not causing any issues with the various functions.

Since I am not getting any errors now it is difficult to find those huge posts now.