×
Kunena 5.1 RC 3 Released (16 Feb 2018)

The Kunena team is proud to announce the arrival of Kunena 5.1.0 RC3 [K 5.1.0] which is now available for download as a native Joomla extension for J! 3.8.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a RC release.

× 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
4 weeks 2 hours ago - 4 weeks 2 hours ago #1 by buzz50
buzz50 created the topic: How to delete Topic and all its posts using SQL
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


Mike
Buzz50 Seniors
'Head Buzzer'
Last Edit: 4 weeks 2 hours ago by buzz50. Reason: added Kunena version

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

More
3 weeks 1 day ago #2 by rich
rich replied the topic: How to delete Topic and all its posts using SQL
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
3 weeks 1 day ago #3 by buzz50
buzz50 replied the topic: How to delete Topic and all its posts using SQL

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?


Mike
Buzz50 Seniors
'Head Buzzer'

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

More
3 weeks 1 day ago #4 by 810
810 replied the topic: How to delete Topic and all its posts using SQL
These are the queries that we run on kunena, when deleting topics:
github.com/Kunena/Kunena-Forum/blob/K5.0...opic/helper.php#L366

Your feedback on the JED helps us improve Kunena!

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.072 seconds