×
Kunena 5.1.6.1 Released - Security Release (09 Nov 2018)

The Kunena team has announce the arrival of Kunena 5.1.6 [K 5.1.6] which is now available for download as a native Joomla extension for J! 3.9.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 Security release.

K5.1.6.1 is a install update.

× 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
9 months 3 weeks ago - 9 months 3 weeks 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

File Attachment:

Mike
Buzz50 Seniors
'Head Buzzer'
Last edit: 9 months 3 weeks ago by buzz50. Reason: added Kunena version

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

More
9 months 2 weeks 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
9 months 2 weeks 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?

File Attachment:

Mike
Buzz50 Seniors
'Head Buzzer'

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

More
9 months 2 weeks 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.

  • 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.120 seconds