The Kunena team has announce the arrival of Kunena 6.4.13 [6.4.13] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.0 Hint: This version is primarily intended to facilitate an upgrade if Joomla was first updated to version 6.1 before Kunena was up to dated.
A couple of small edits to the listcat.php file and everything is working as expected for me. Here is what I did:
Changed line 270 from this: $database->setQuery("SELECT DISTINCT thread from #__fb_messages where catid=$singlerow->id and hold=0 and moved=0 and time>$prevCheck group by thread");
To This:
$database->setQuery("SELECT DISTINCT thread FROM #__fb_messages WHERE catid='$singlerow->id' AND hold=0 AND moved=0 and time>'$prevCheck' GROUP BY thread");
AND, Changed line 466 from this:
$database->setQuery("SELECT thread from #__fb_messages where catid=$forumparent->id and hold=0 and time>$prevCheck group by thread");
To This: $database->setQuery("SELECT thread FROM #__fb_messages WHERE catid='$forumparent->id' AND hold=0 AND time>'$prevCheck' GROUP BY thread");
THANK YOU djackso1!!!! I'VE BEEN SEARCHING THE FORUMS AND WAITING FOR HELP FOR ABOUT 1 WEEK NOW ON THIS PROBLEM! EVERYTHING SEEMS TO WORK GOOD FOR ME NOW!
