×
Kunena 5.2.2 released (13 Jan 2021)

The Kunena team has announce the arrival of Kunena 5.2.2 [K 5.2.2] 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.2 and issues discovered during the development stages of K 5.2.2

× The error code HTTP 500 Internal Server Error is a general-purpose message this indicates a general error in a web application. Please note that there is no general solution for this general error. You should first read HTTP 500 Internal Server Error before posting in this category.

K 2.0 support will cease on 31 August 2013 and this section of the forum will be closed and archived after that time and no further questions will be answered about this version.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Important Crash when Pruning forum messages

More
7 years 9 months ago #1 by sandijs
500 - An error has occurred.

JDatabaseMySQLi::query: 1052 - Column 'category_id' in where clause is ambiguous SQL=UPDATE try1_kunena_categories AS c INNER JOIN ( SELECT t.category_id AS id, COUNT( * ) AS numTopics, SUM( t.posts ) AS numPosts, t2.id as last_topic_id FROM try1_kunena_topics AS t INNER JOIN (SELECT t.id, t.category_id, t.last_post_time FROM try1_kunena_topics AS t, (SELECT category_id , max(last_post_time) as last_post_time FROM `try1_kunena_topics` WHERE hold =0 AND moved_id =0 GROUP BY category_id) AS temp WHERE temp.last_post_time = t.last_post_time AND category_id IN (4) AND t.category_id=temp.category_id ) AS t2 ON t2.category_id=t.category_id WHERE t.hold =0 AND t.moved_id =0 AND category_id IN (4) GROUP BY t.category_id ) AS r ON r.id=c.id INNER JOIN try1_kunena_topics AS tt ON tt.id=r.last_topic_id SET c.numTopics = r.numTopics, c.numPosts = r.numPosts, c.last_topic_id=r.last_topic_id, c.last_post_id = tt.last_post_id, c.last_post_time = tt.last_post_time

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /var/www/html/doublesolutions.biz/esadesign/administrator/index.php:46
2 JComponentHelper::renderComponent() /var/www/html/doublesolutions.biz/esadesign/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/application/component/helper.php:351
4 require_once() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/application/component/helper.php:383
5 JController->execute() /var/www/html/doublesolutions.biz/esadesign/administrator/components/com_kunena/admin.kunena.php:81
6 KunenaAdminControllerTools->prune() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/application/component/controller.php:761
7 KunenaForumCategory->trash() /var/www/html/doublesolutions.biz/esadesign/administrator/components/com_kunena/controllers/tools.php:101
8 KunenaForumCategoryHelper::recount() /var/www/html/doublesolutions.biz/esadesign/administrator/components/com_kunena/libraries/forum/category/category.php:590
9 JDatabase->query() /var/www/html/doublesolutions.biz/esadesign/administrator/components/com_kunena/libraries/forum/category/helper.php:420
10 JDatabaseMySQLi->execute() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/database/database.php:1253
11 JError::raiseError() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/database/database/mysqli.php:396
12 JError::raise() /var/www/html/doublesolutions.biz/esadesign/libraries/joomla/error/error.php:251

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

More
7 years 9 months ago #2 by sandijs
To replicate the error, one must select for pruning all messages being not active for 0 days, all categories, all topics.

As a result, first message gets into the Trash, reamining messages stay intact, 500 error appears.

Next time you do that same, and next message gets into the Trash.

The idea was to test Forum functionality and then clean test messages before going live.

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.068 seconds