×
Kunena 5.1.2 Released - Security Release (15 Jul 2018)

The Kunena team has announce the arrival of Kunena 5.1.2 [K 5.1.2] 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 Security 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 Optimizing Kunena database tables

More
1 week 5 days ago #1 by Slacker
I have discovered that, when I try to optimize Kunena database tables with phpMyAdmin it is not possible and I get the advice to create a new table from the old one and then check it with analyze in phpMyAdmin. The reason I want to do this is that I have deleted about 30 % of mine forumposts.

I found this page with suggestions on how to do it:
www.geeksengine.com/database/manage-table/create-table-as.php

create table products_bk
as
select * from products
(naturally the table names are different than above for kunena)

This diminish my kunena_messages table with at least 50 % in size.
I guess after creating a new table I have to change name of both the old and new table.

I have looked for advice about this, but not found any, so I am grateful for input here.

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

More
1 week 4 days ago #2 by rich
You don't need to optimize the database. If you delete forum posts, it removes also the related rows in the database. But you must delete the messages permanently.

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

More
1 week 4 days ago #3 by wolfsauge
Why have a gotten a dozen notifications? This is not even my post!

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

More
1 week 3 days ago #4 by rich
I'm sorry, it was a error at the mail delivery for subscribers. Therefore you also got the mails.

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.091 seconds