Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

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
13 years 3 weeks ago - 13 years 3 weeks 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: 13 years 3 weeks ago by astrogoal.

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

More
13 years 3 weeks ago #2 by sozzled
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
13 years 3 weeks ago - 13 years 3 weeks ago #3 by astrogoal
are you sure? Why not a kunena bug? I think so. I fixed simple by phpmyadmin....
Last edit: 13 years 3 weeks ago by astrogoal.

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

More
13 years 3 weeks ago - 13 years 3 weeks 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: 13 years 3 weeks ago by astrogoal.

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

Time to create page: 0.505 seconds