×
Kunena 5.1.9 Released (15 Feb 2019)

The Kunena team has announce the arrival of Kunena 5.1.9 [K 5.1.9] 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 maintenance release.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Question kunena table crash.............

More
7 years 10 months ago - 7 years 10 months ago #1 by astrogoal
I had this bad issue... my kunena 1.6.3 on joomla 1.5.22 stops work. It says to set debug mode on and i have this message...

Could i repair my kunena_message table by phpmyadmin? How? Why happens? I'm very sad :(


500 - JDatabaseMySQL::query: 1194 - Table 'xxx_kunena_messages' is marked as crashed and should be repaired SQL=SELECT c.*, m.id AS mesid, m.thread, m.catid, t.subject AS topicsubject, m.subject, m.name AS mname, u.id AS userid, u.username, u.name AS uname, (SELECT COUNT(*) FROM xxx_kunena_messages AS mm WHERE m.thread=mm.thread) AS msgcount, (SELECT COUNT(DISTINCT thread) FROM xxx_kunena_messages AS mmm WHERE c.id=mmm.catid AND mmm.hold='0' AND mmm.time>'1300907940' AND mmm.thread NOT IN (0)) AS new FROM xxx_kunena_categories AS c LEFT JOIN xxx_kunena_messages AS m ON c.id_last_msg=m.id LEFT JOIN xxx_kunena_messages AS t ON m.thread=t.id LEFT JOIN dar_users AS u ON u.id=m.userid WHERE c.parent IN (16,89,81,82) AND c.published='1' AND c.id IN(16,4,70,5,6,7,8,9,10,11,12,13,14,15,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,39,36,37,38,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,71,81,75,76,77,78,79,80,82,87,88,89) ORDER BY ordering, name
Last edit: 7 years 10 months ago by astrogoal.

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

  • sozzled
  • Visitor
7 years 10 months ago #2 by sozzled
Replied by sozzled on topic kunena table crash.............
Repairing corrupted, broken or defective database tables is not something that falls within the scope of the free support that we offer here. There are commercial services that may be able to help you do this (for a fee, of course). This is a web management issue. This is not a Kunena issue, sorry.

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

More
7 years 10 months ago - 7 years 10 months ago #3 by astrogoal
are you sure? Why not a kunena bug? I think so. I fixed simple by phpmyadmin....
Last edit: 7 years 10 months ago by astrogoal.

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

More
7 years 10 months ago - 7 years 10 months ago #4 by astrogoal
my impression for this sql error is that if a user send a message while server is down (sever goes down, but user has opened a form before) it probably brokes the kunena message table!!! joomla table are without this issues tipical for component.
Last edit: 7 years 10 months ago by astrogoal.

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