Unless you are a Joomla, Kunena AND SQL expert, you MUST NOT run SQL quieres against your install database by hand.
A single typo can and will have the potential to damage to drop portions or all of your data and WILL render you system useless. Most ALTER, INSERT, UPDATE, DELETE, DROP statements cannot be undone. Once executed and something goes wrong data is lost forever. Only way back: Restore from your backup
I realize that people want to help each other with SQL queries 'fixing' underlying problems. in most cases the problem you see is a side effect from another problem or upgrade or migration.
If that is the case get an expert (free or pay for it) to do it for you.
Even the best most accurate SQL statement written for one specific problem, used out of context, against a different version can be fatal.
Just today I witnessed a thread in which somebody carelessly copied some SQL statements around as a 'fix' and by accident, forgot to copy the entire statement, dropping one rather important part of the query.
SQL statements and myphpAdmin are not for novices. Not in Kunena, not in Joomla or any other system you want to keep using.
We will advise all our team members going forward to not post any such 'solutions' on the public forum. If one of the developers sends you something in a private message, directed at you, then and only then should you consider running it AFTER you made a complete backup of your site.
A clean install of Kunena will not need any SQL queries to be run by hand. Only if something got modified or changed or hacked will we ever resort to such drastical measures.
So - if you want to keep your forum data, don't hack it unless you are - as stated before - a Joomla, Kunena & SQL expert.
The topic has been locked.