What is your setting as Ruben advised above?
https://www.ubbcentral.com/forums/u.../re-error-on-inert-into-posts#Post263955

checked or unchecked?

[Linked Image]


Did you know that you can uncheck that box, then go to Control Panel > Content Rebuilder
and have the UBB.threads software convert your tables for you:

[Linked Image]

When you click that link, the utf8mb4 conversion process will begin.
That process looks like this example:

[Linked Image]
[Linked Image]
(the conversion screenshots above were from my WIP/development server. For release/public code, "Tables not converted" instead will show the number of actual tables converted on your forum install.)


Then follow the "Enable "MySQL Full Unicode Support" from the Database Settings page" directions given once the tool finishes it's job.

Which will bring you back to the checkbox that Ruben, Gizmo and myself have asked you about earlier in this thread:

[Linked Image]

All that the checkbox does is tell the MySQLi connector to use the utf8mb4 character set for communication with the database server. Also when the box is checked, the hyperlink from "Update All Tables to UTF8mb4" within Content Rebuilder/Transition Actions will be disabled. That is all it does.


CODE:
The checkbox sets the default character set to be used when sending data from and to the database server.

[Linked Image]

Last edited by isaac; 06/30/2020 5:45 PM. Reason: added screenshots

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com