Support Forum
Support Forum
Offline
We have had two posts disappear from our forum. The person that created the post subscribed to it and received two emails stating that someone had responded to her post. When she clicked the link in the emails she saw the posts on the forum, however when she went back later they had disappeared.
This person knows the others that posted and asked them if they were deleted, and neither one of them edited or deleted their post after they posted it.
Is there anyway to tell what happened? She forwarded the emails she received showing the posts had been made and I have checked the forum and they are definitely not there.
It might have been a fluke, but if makes me very very nervous!
Thank you!
Offline
We are only aware, currently, of one circumstance that can stop a post saving even though it appears to save and this is if the user has tried to use an emoji in the post content but your mySQL database is not capable of storing them - and that just means it is an older version.
If you could ask this user if they did this and also tell me what version of mySQL database your server is running (forum admin > toolbox > environment) then we can explain what is happening about this. If that is not the issue then we may need a little more data regarding the post content.
 |
YELLOW
SWORDFISH
|
Offline
Hi Yellow Swordfish,
I have checked the emails from both posts and yes, they both have smiley faces in them.
I am using this mySQL version: Version: 5.5.42
Is there anyway to disable these emojis so this problem doesn't happen again or any other solution?
Thank you!!
Offline
should be no issue with that mysql version... and you are running wp 4.2.2? can you look at your db and tell us what the charset is for the sfposts table?
there are wp plugins (or use a hook) that allows for disabling of emojis... but not sure that would help here - Andy would be able to tell...
Visit Cruise Talk Central and Mr Papa's World
Offline
Thank you for your reply to this, sorry it has taken me a bit to come back to it.
So I accessed my sfposts table in my db but I am not sure where to find the "charset". Can you help me with that?
I haven't had any other posts disappear that I know of, but it would help me a lot if I knew it was solved.
Thank you!
Offline
Hey Jenn,
You shouldn't need to go into the sfposts table to look. If using phpMyAdmin for example - if you look at your list of tables and find sfposts (don't click and enter it) it will be in it's own column called 'Collation', just before size.
Offline
Thanks Ike.
This is the value in that column for the sfposts table: utf8mb4_unicode_ci
Does that help?
Offline
That's the one, although I'm not sure about how that would affect things. I'm guessing as it's the correct charset that it probably rules something out, but I'm pretty new to databases so will have to wait for Andy or Steve to pick this one up!
Offline
I have to admit that I am totally 100% puzzled how posts could disappear. If something like that was happening i would expect more symptoms.
Can we discount any WP caching plugins because that can make ot appear that posts have vanished?
And if no - could you go to the topic in question - open the forum tools menu - click on view properties and when you have the list up - click on the verify button which will rebuild the indexing for the topic.
|
YELLOW
SWORDFISH
|
Offline
Thanks for your reply, Yellow Swordfish.
I do not have any caching plugins installed that I know of. I would be happy to provide a list of my plugins if that is helpful.
I also tried your suggestion of verifying both the Forum ID and the Topic ID of that particular topic where the posts have disappeared and that did not solve the problem either. At least the missing posts did not reappear.
You mentioned in your first post that this is something to do with the emojis. Is this a known problem? And has there been a solution?
All RSS1 Guest(s)