- Posts: 66
- Thank you received: 3
Kunena 7.0.3 Released
The Kunena team has announce the arrival of Kunena 7.0.3 [K 7.0.3] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.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 7.0
This category may also contain a few topics relating to K 1.6 that may have been moved here possibly by mistake.
The topics in this category are for historical interest only. Owing to the structural differences between K 1.6 and K 1.7, these ideas in these topics will not work with later versions and, for that reason, the topics are locked.
Question Euro Templates - Free K1.6 Templates
No valid database connection Can't find FULLTEXT index matching the column list SQL=SELECT id, subject, name, time as zaman, catid, userid, MATCH(t1.message) AGAINST...
This error is on bottom of the page before " Powered by Kunena :: Foro Viajeros"
So far the template seems to work but what is that error which I get! Please help!
EDIT: I fixed it by completely removing the following lines at bootom of view.php (seems like there's missing php end after php foreach??):
<!-- F: List Actions Bottom -->
<?php
$id = $this->thread;
$catid = $this->catid;
$this->db->setQuery("SELECT a.*, b.* FROM #__kunena_messages AS a LEFT JOIN #__kunena_messages_text AS b ON a.id=b.mesid WHERE a.id='{$id}' AND a.hold='0'");
$this_message = $this->db->loadObject();
$this->db->setQuery("SELECT * FROM #__kunena_categories WHERE id='{$catid}'");
$objCatInfo = $this->db->loadObject();
$percent=5; //similarity percentage, increase for sensitive matching. for example 10 is 10% match, 50 is 50% match, 100 is one o one
$topics_only=1; //set 1 if you wanna show only topics, set 0 to show relative messages directly
$limit = 5; //set number of relative messages
$parent = ($topics_only == 1) ? " AND parent=0 " : "";
$query=("SELECT id, subject, name, time as zaman, catid, userid, MATCH(t1.message) AGAINST('".addslashes($this_message->subject)."') as oran1, MATCH(t2.subject) AGAINST('".addslashes($this_message->subject)."') as oran2 FROM
#__kunena_messages_text as t1 INNER JOIN #__kunena_messages as t2 ON t2.id = t1.mesid
WHERE (MATCH(t1.message) AGAINST('".addslashes($this_message->subject)."') > $percent OR MATCH(t2.subject) AGAINST('".addslashes($this_message->subject)."') > $percent) AND t2.thread <>" . $this_message->thread . $parent . " ORDER BY oran2 DESC, oran1 DESC LIMIT $limit;");
$sim_message = $this->db->setQuery($query);
$sim_message = $this->db->loadObjectList();;
if (count($sim_message)> 0)
{
echo '<div class= "kblock"><div class= "kheader"><h2><span>Related Posts</span></h2></div><div class= "klist-bottom"';?>
<?php foreach ($sim_message as $sonuc) {
if ($sonuc->oran1 > $sonuc->oran2)
{
$oran = $sonuc->oran1;
}
else {
$oran=$sonuc->oran2;
}
echo "<span><b><a rel=\"follow\" title=\"".$sonuc->subject."\" href=\"".CKunenaLink::GetThreadPageURL('view', $sonuc->catid, $sonuc->id, $page, $this->limit)."\">".$sonuc->subject."</a></b></span><br>";
}
echo "</div></div>";
}
?>
EDIT2: I also had to adjust css-value of #knamepasslost to "margin-left: 230px" becuase it was misplaced...
Please Log in or Create an account to join the conversation.
The problems you get aren´t normal becouse i tested the templates in different hostings and joomla templates.
WordPress Development and Kunena templates.
Please Log in or Create an account to join the conversation.
By the way! Please add text-shadow to "#Kunena h1,h2 {....text-shadow:black 0.2em 0.1em 0.2em;}
It looks really better with text-shadow for euro blue!
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
I'm sure is your template who don´t let Kunena Template load, or try to download the last release.
WordPress Development and Kunena templates.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.