Question How to delete a Kunena Message using Joomla MySQL database

Using Jooma 3.8.2, PHP 7.0.98, Kunena 5.0.12

In my Kunena forum, the text of a post contained a broken link, so I absolutely had to edit or delete the post in order to make the search engine crawlers happy. (They will ding you for broken links.)

Problem was that I could not edit or delete the post from the Kunena front end, even as a superuser.

Solution: I deleted the post via Joomla database on my server.
Method: Find the post, and its id number in the database. Look in tbl_kuenena_messages or in tbl_kunena_messages_text until you find the offending post. (Depending on your setup, you might find the ID # of the post in Kunena forum in the front end on the top right corner of the post. Or in the Joomla database, you can do a Control-F in your browser, and search for the title or text in the post.)
Then I deleted the line item with that ID number from each of 3 tables:
tbl_kunena_messages
tbl_kunena_messages_text
tbl_kunena_topics

And, I optimized those 3 sql tables using C-Panel.

That seemed to work. There may be another step that I'm not aware of, such as doing something to the log files.

More info: In Kunena backend Tools / Diagnostics. I ran the diagnostics, which identified some broken and orphaned items. I clicked on the suggested fixes, which resulted in a good diagnostics report. But, still I had to use the Joomla database as described above to delete the items that I could not edit or delete via Kunena's front end. However, I suggest using Kunena / Tools / Diagnostics, before and after making changes to the Joomla database.