Kunena 6.2.5 & module Kunena Latest 6.0.7 released

The Kunena team has announce the arrival of Kunena 6.2.5 [K 6.2.5] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question How to delete Topic and all its posts using SQL

More
6 years 2 months ago - 6 years 2 months ago #1 by buzz50
Can someone please give me the SQL to delete a topic and all its posts just from the Topic id please?

If not then what would be the consequences of deleting just the Topic and leaving the messages and messages_text and anything else which is created?

I am using Kunena 5.0.13

[img

Mike
Buzz50 Seniors
'Head Buzzer'
Last edit: 6 years 2 months ago by buzz50. Reason: added Kunena version

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #2 by rich
You don't need delete via SQL. If you delete a topic permanently, it deletes also all included messages. There are no consequences, only the topic with all messages is removed for ever.

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #3 by buzz50

rich wrote: You don't need delete via SQL. If you delete a topic permanently, it deletes also all included messages. There are no consequences, only the topic with all messages is removed for ever.


Thank you but what I meant to say was:

I want to delete a topic using SQL

Is there a query that you can please supply or, if not, then if I delete on the Topic, will that cause me problems?

[img

Mike
Buzz50 Seniors
'Head Buzzer'

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #4 by 810
These are the queries that we run on kunena, when deleting topics:
github.com/Kunena/Kunena-Forum/blob/K5.0...opic/helper.php#L366

Please Log in or Create an account to join the conversation.

Time to create page: 0.398 seconds