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

Question K1.7 - bug - permanently remove topic

Mortti
Offline
Elite Member

14 years 7 months ago #107905 by Mortti

Replied by Mortti on topic Re: K1.7 - bug - permanently remove topic

Can you check that 101 ItemID?

Also always to admins is helpful to give some Configuration Report

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

karmany
Topic Author
Offline
Junior Member

13 years 10 months ago - 13 years 10 months ago #126309 by karmany

Replied by karmany on topic Re: K1.7 - bug - permanently remove topic

This bug is not fixed. (Joomla! 2.5.4 and Kunena 1.7.2)

I debugged the code. The problem is (kunena.moderation.class.php):

Code:

$sql2 = "DELETE FROM #__kunena_messages_text WHERE `mesid` IN ({$this->_db->Quote(implode(',',$messid))});";
$this->_db->setQuery ($sql2);
$this->_db->query ();

The query seems correct, but

Code:

$this->_db->query ();

Do not delete the last message.

The error message is: COM_KUNENA_MODERATION_ERROR_MESSAGE_NOT_FOUND

- "Tu sitio para aprender, enseñar y compartir"

Last edit: 13 years 10 months ago by karmany.

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

karmany
Topic Author
Offline
Junior Member

13 years 10 months ago - 13 years 10 months ago #126314 by karmany

Replied by karmany on topic Re: K1.7 - bug - permanently remove topic

I think the query is not correct. I made the query from phpmyadmin and is the same result.
The query is:

Code:

DELETE FROM `prefijo_kunena_messages_text` WHERE `mesid` IN ('355,356')

Message 355 is deleted, but not 356 message.

Is it possible that in the sql query, missing 2 quotes?

Code:

DELETE FROM `prefijo_kunena_messages_text` WHERE `mesid` IN ('355','356')

- "Tu sitio para aprender, enseñar y compartir"

Last edit: 13 years 10 months ago by karmany.

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

Matias
Offline
Administrator

13 years 10 months ago - 13 years 10 months ago #126318 by Matias

Replied by Matias on topic Re: K1.7 - bug - permanently remove topic

Thank you for your report and pointing out how to fix it. The fix is actually to remove the quotes, not to add them:

Code:

$sql2 = "DELETE FROM #__kunena_messages_text WHERE `mesid` IN (".implode(',',$messid).");";

The problem in Kunena 1.7 was always that the moderation function is so complicated that nobody can really follow what it does.

Kunena 2.0 already fixes the issue and release date has already been set.

Last edit: 13 years 10 months ago by Matias.

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

Matias
Offline
Administrator

13 years 10 months ago #126320 by Matias

Replied by Matias on topic Re: K1.7 - bug - permanently remove topic

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

karmany
Topic Author
Offline
Junior Member

13 years 10 months ago - 13 years 10 months ago #126321 by karmany

Replied by karmany on topic Re: K1.7 - bug - permanently remove topic

Excellent support!

This bug is fixed: no error in database.
(Missing 1 parentheses: www.kunena.org/forum/168-K-17-Support/12...-Kunena-1-7-2#126319 )

But you still see an error screen: Equal to the (number_of_messages - 1). These notifications are:
class.kunena.php

Code:

577: foreach ( $messagesHold as $messageHold ) {

Because, KN_DEL_THREAD_PERMINANTLY: Delete a complete thread from the database.

This is only a report error but not a database error.

- "Tu sitio para aprender, enseñar y compartir"

Last edit: 13 years 10 months ago by karmany.

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

Time to create page: 0.209 seconds