×
Kunena 5.1.10 Released - Security release (03 Mar 2019)

The Kunena team has announce the arrival of Kunena 5.1.10 [K 5.1.10] which is now available for download as a native Joomla extension for J! 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. This is a security release.

Solved [K.5.0.RC5] topicMissingCategory Test Failed

More
2 years 8 months 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
2 years 8 months 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
2 years 8 months 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
2 years 8 months ago #4 by ssh
Done.
Thanks
Attachments:

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

More
2 years 8 months 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 6 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 6 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.111 seconds