« Last post by PoML on December 04, 2022, 07:42:58 AM »
On this topic, I have found a few hints as to what causes it to go wrong:
1. Switching between html code and wysiwyg editor.
2. removing extra newlines that sometimes "just appear" when saving
3. Adding non-supported unicode-characters.
Last night both the two latter happened.
After reading that SMF now supported the full unicode specification, I of cource had to push my luck by adding this string between two chapters in an article:
🎄🎅 🎄 🤶 🎄 ❄ 🎄 ☃ 🎄 🎁 🎄 ⛄ 🎄 🛷 🎄 🔔 🎄 🎇 🎄 🎉 🎄
First this error when saving:
Incorrect string value: '\xF0\x9F\x8E\x84\xF0\x9F...' for column `c5jnzrz36_db538176`.`smf_tp_articles`.`body` at row 1
(the `c5jnzrz36_db538176` is simply the backend slightly cryptic database name)
Then I tried to remove and save again.
Then I suddenly had a lot of extra newlines.
Then I had two copies of the full article and I ended up with a "memory full" error from the backend.
As several of these symptoms are the same, I start to believe that if the HTML is wrong or contains non-supported characters then there is a flawed error handling somewhere.
Dont't know if that helps to find the root cause, but at least some of the symptoms should be an easy fix.
One is that the data type for an article should support what you can have in normal forum messages. As show above, there was no error saving this text here...?
Second is that somehow it seems from time to time a function to insert extra newlines is triggered when saving. A little like if you tick the "add
in html email" in the newsletter send feature of SMF.
Is this a good hint to what is wrong?
Debugging error handling is worse - I know, that can be a nightmare.
Thanks for any help!