Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question SQL-query to change thread

More
16 years 8 months ago #25910 by crisscross
I have a somewhat delicate problem. After upgrading from fireboard to Kenena everything seemed fine. Today a user notified me of a strange problem.
I have one big thread with over 12,000 replies. One of the moderators did merge this thread with another thread some time ago. Now the thread starts with a message that should not be the first one in the thread (it is much later of origin and is not a "thread-starter").
I checked the database and this is the current status:

The first message in the thread is message id: 190112
All the other messages have this id as parent.

The second message is message id: 3779
This message is the one that should be the parent id (the first message in this thread).

I know that this probably could be solved by a sql-query or two in php-myadmin but I am a little bit paranoid over this as this is an old thread that should not be destroyed.

Can anyone out there help me with what query/queries I should perform to correct this?

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

More
16 years 8 months ago #25941 by Matias
Here's how you should do it (just an idea):

1) Look at the thread field. If it is not 3779, change thread=3779 where thread=190112.
2) Change parent=3779 where thread=3779
3) Change parent=0 where id=3779

The last one is important if you still want to see the thread after making those changes.

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

Time to create page: 0.217 seconds