Hi, really enjoying K2 and our first time using it for a client, although I have come across a few bugs which have been reported on this forum and seem to have remained unanswered , both for almost a year.
This particular one is mentioned in several bug posts and all remain unanswered. I cannot add to the posts as they are locked so have had to start a new one.
My question is, will this be fixed any time soon, is it deemed as not necessary or just missed.
Our client has 500 tags and is finding the random nature drives them mad. I agree with them that it does not help in grouping the tags to see if someone has already added it or added it with a capital or lowercase (both would in k2 produce a new tag and so split the key word in to two) resulting in articles being incorrectly tagged
There was a post and solution for this 11 months ago but no one responded to the chap and we are using latest k2 so its not been adopted. If Joomla works does not think it a bug then fine, I will patch it on mine, just would prefer to know one way or other so I don't do the changes and find its just been fixed and brought in to the code.
Kind regards
Phil
Previous post with solution
Hello All,
In K2 Item display the tags list is displayed by id rather than Alphabetically. Not sure if this is a "bug" but the SQL code in models/item.php getItemTags, line 694, should be:
$query="SELECT `id`, `name` 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`";
Also in the administration area change the following functions in models/item.php...
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
This particular one is mentioned in several bug posts and all remain unanswered. I cannot add to the posts as they are locked so have had to start a new one.
My question is, will this be fixed any time soon, is it deemed as not necessary or just missed.
Our client has 500 tags and is finding the random nature drives them mad. I agree with them that it does not help in grouping the tags to see if someone has already added it or added it with a capital or lowercase (both would in k2 produce a new tag and so split the key word in to two) resulting in articles being incorrectly tagged
There was a post and solution for this 11 months ago but no one responded to the chap and we are using latest k2 so its not been adopted. If Joomla works does not think it a bug then fine, I will patch it on mine, just would prefer to know one way or other so I don't do the changes and find its just been fixed and brought in to the code.
Kind regards
Phil
Previous post with solution
Hello All,
In K2 Item display the tags list is displayed by id rather than Alphabetically. Not sure if this is a "bug" but the SQL code in models/item.php getItemTags, line 694, should be:
$query="SELECT `id`, `name` 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`";
Also in the administration area change the following functions in models/item.php...
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