×
Kunena 5.1.14 Released - Security release (13 Aug 2019)

The Kunena team is proud to announce the arrival of Kunena 5.1.14 [K5.1.14] which is now available for download as a native Joomla extension for Joomla 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.14. This update fixed 1 security issue.

Solved [K.5.0.RC5] topicMissingCategory Test Failed

More
3 years 1 month ago #1 by ssh
How can I know or find the topic causing this error?

Attachments:

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

More
3 years 1 month ago #2 by ssh
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
3 years 1 month ago #3 by 810
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:
$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
3 years 1 month ago #4 by ssh
Done.
Thanks
Attachments:

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

More
3 years 1 month ago #5 by ssh
This topic can be moved to archive folder.

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

More
2 years 11 months ago #6 by Gee
If someone is also having this problem the usual sql query is
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.

More
2 years 11 months ago #7 by 810
On the next version, you can fix all issues.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.125 seconds