Kunena 7.0.3 Released

The Kunena team has announce the arrival of Kunena 7.0.3 [K 7.0.3] 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

Solved [K.5.0.RC5] topicMissingCategory Test Failed

More
9 years 8 months ago #177527 by ssh
[K.5.0.RC5] topicMissingCategory Test Failed was created by ssh
How can I know or find the topic causing this error?

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

More
9 years 8 months ago #177528 by ssh
Replied by ssh on topic [K.5.0.RC5] topicMissingCategory Test Failed
For this specific error, the button to fix/correct the problem is not available

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

More
9 years 8 months ago #177529 by 810
Replied by 810 on topic [K.5.0.RC5] topicMissingCategory Test Failed
like the title says, the topic has a none existed category id. Likely you deleted a category.


For this issue, there is no fix. Except to show a modal with a category list. and then save it. But that feature need to be total rewritten, we have now only a count.

And for simple issue a fix.

this is the query:
Code:
$query->from("#__kunena_topics AS a")->leftJoin("#__kunena_categories AS c ON c.id=a.category_id")->where("c.id IS NULL");
The following user(s) said Thank You: ssh

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

More
9 years 8 months ago #177530 by ssh
Replied by ssh on topic [K.5.0.RC5] topicMissingCategory Test Failed
Done.
Thanks

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

More
9 years 8 months ago #177533 by ssh
Replied by ssh on topic [K.5.0.RC5] topicMissingCategory Test Failed
This topic can be moved to archive folder.

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

More
9 years 6 months ago #180456 by Gee
Replied by Gee on topic [K.5.0.RC5] topicMissingCategory Test Failed
If someone is also having this problem the usual sql query is
Code:
SELECT * from j3_kunena_topics a left Join j3_kunena_categories c ON (c.id=a.category_id) where c.id IS NULL

(replace j3 with your database id)

In my case it has been the "Welcome to Kunena" topic that I did not delete before deleting the category.

Thanks for sharing the joomla query.

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

Time to create page: 0.269 seconds