Also...
John Wicks said:Suggest changing the com_k2/models/item.php file around line 690 for v2.2.Add an Order By clause to the SQL in the getItemTags function...$query="SELECT * FROM #__k2_tags as tags WHERE tags.published=1 AND tags.id IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID}) order by `name`";
In the models/index.php change the following code...
function getAvailableTags($itemID = NULL) {
$db = &JFactory::getDBO();
$query = "SELECT * FROM #__k2_tags as tags";
if (!is_null($itemID))
$query .= " WHERE tags.id NOT IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID})";
$query .= " ORDER BY `name`";
$db->setQuery($query);
$rows = $db->loadObjectList();
return $rows;
}
function getCurrentTags($itemID) {
$db = &JFactory::getDBO();
$query = "SELECT * FROM #__k2_tags as tags WHERE tags.id IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID}) ORDER BY `name`";
$db->setQuery($query);
$rows = $db->loadObjectList();
return $rows;
}
Jw