×
Kunena 5.1.5 Released - Security Release (14 Oct 2018)

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

× 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 6 months ago - 7 years 6 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 6 months ago by astrogoal.

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

  • sozzled
  • Visitor
7 years 6 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 6 months ago - 7 years 6 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 6 months ago by astrogoal.

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

More
7 years 6 months ago - 7 years 6 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 6 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 add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.081 seconds