You cannot display galleries at the description of category -if that is what you are trying to do because of joomla settings.However in a category list the plugin works.

Hi Katia,

How can i display the {gallery} tag in k2 categories listing? Apparently, i only able to display in item listing but not categories listing. Your help is highly appreciated

Hi All,

How can i display the {gallery} tag in k2 categories listing? Apparently, i only able to display in item listing but not categories listing. Your help is highly appreciated

Okay guys I have figured out a way to do it for myself without buying plugins but with some K2 Hacking

First K2 renders the page in through this

view.html.php
In directory
/components/com_k2/views/item

You can probably do this as an Override View but I didn't bother
TEMPLATE_NAME/code/COMPONENT_NAME/views/VIEW_NAME/VIEW_NAME(.FORMAT).php


The HEAD content is already rendered to the page, this can be done by Joomla or a lot of people will be using something like ACE SEF or other things which will take over the META content. There is really no point in trying to custom mod those plugins, its easier to just ask K2 to add the meta items after its loaded because this is the only time variables are really available to K2 unless you want to do a lot of work to pull data right out of the dbase or setup custom variables to pass data across Joomla.

If you scroll down you will see a section for Facebook Images

// Load Facebook meta tag -> item
$facebookImage = 'image'.$params->get('facebookImage','Small');
$document->setMetaData("image",substr(JURI::root(),0,-1).str_replace(JURI::root(true),'',$item->$facebookImage));

This doesn't seem to DO anything but at least you have an area to mod to do what you want.
What I wanted was a WORKING facebook image from K2 images

So I added this command under this section of code

$document->setMetaData('og:image', 'xYOUSITEROOTx'.$item->$facebookImage);

As $facebookImage was already defined for me.

You could then try to add more Facebook Open Graph meta content here if you like. You would have to get the variables you want to use and its not the same as if your ON the page. For example

$facebookImage = 'image'.$params->get('facebookImage','Small');

You dont need to do the title as facebook defaults to the page title anyways

Thanks Krikor!
I'm actually modifying the code within the default.php template inside mod_k2_content/templ/myCustomTemplate

When I put in:
$this->item->params->get('catItemTags') // If the tags are enabled
echo count($this->item->tags) // the count

It throws the following error:
Fatal error: Using $this when not in object context in C:\xampp\htdocs\joomla25\modules\mod_k2_content\tmpl\unique\default.php on line 20

If I just put in:
echo $params->get('catItemTags'); // it doesn't return anything

Not sure how to create the reference to the tags outside of the item object...

Will keep trying things.

Thanks!

Yes, this is what I do.
Now I have tried to empty all K2 tables, and import form Joomla again.

Here following the PARAMS field for Category A in table k2_categories

{"inheritFrom":"0","theme":"","num_leading_items":"2","num_leading_columns":"1","leadingImgSize":"Large","num_primary_items":"4","num_primary_columns":"2","primaryImgSize":"Medium","num_secondary_items":"4","num_secondary_columns":"1","secondaryImgSize":"Small","num_links":"4","num_links_columns":"1","linksImgSize":"XSmall","catCatalogMode":"0","catFeaturedItems":"1","catOrdering":"","catPagination":"2","catPaginationResults":"1","catTitle":"1","catTitleItemCounter":"1","catDescription":"1","catImage":"1","catFeedLink":"1","catFeedIcon":"1","subCategories":"1","subCatColumns":"2","subCatOrdering":"","subCatTitle":"1","subCatTitleItemCounter":"1","subCatDescription":"1","subCatImage":"1","itemImageXS":"","itemImageS":"","itemImageM":"","itemImageL":"","itemImageXL":"","catItemTitle":"0","catItemTitleLinked":"0","catItemFeaturedNotice":"0","catItemAuthor":"1","catItemDateCreated":"1","catItemRating":"0","catItemImage":"1","catItemIntroText":"1","catItemIntroTextWordLimit":"","catItemExtraFields":"0","catItemHits":"0","catItemCategory":"1","catItemTags":"1","catItemAttachments":"0","catItemAttachmentsCounter":"0","catItemVideo":"0","catItemVideoWidth":"","catItemVideoHeight":"","catItemAudioWidth":"","catItemAudioHeight":"","catItemVideoAutoPlay":"0","catItemImageGallery":"0","catItemDateModified":"0","catItemReadMore":"1","catItemCommentsAnchor":"1","catItemK2Plugins":"1","itemDateCreated":"0","itemTitle":"0","itemFeaturedNotice":"1","itemAuthor":"1","itemFontResizer":"1","itemPrintButton":"1","itemEmailButton":"1","itemSocialButton":"1","itemVideoAnchor":"1","itemImageGalleryAnchor":"1","itemCommentsAnchor":"1","itemRating":"1","itemImage":"1","itemImgSize":"Large","itemImageMainCaption":"1","itemImageMainCredits":"1","itemIntroText":"1","itemFullText":"1","itemExtraFields":"1","itemDateModified":"1","itemHits":"1","itemCategory":"1","itemTags":"1","itemAttachments":"1","itemAttachmentsCounter":"1","itemVideo":"1","itemVideoWidth":"","itemVideoHeight":"","itemAudioWidth":"","itemAudioHeight":"","itemVideoAutoPlay":"0","itemVideoCaption":"1","itemVideoCredits":"1","itemImageGallery":"1","itemNavigation":"1","itemComments":"1","itemTwitterButton":"1","itemFacebookButton":"1","itemGooglePlusOneButton":"1","itemAuthorBlock":"1","itemAuthorImage":"1","itemAuthorDescription":"1","itemAuthorURL":"1","itemAuthorEmail":"0","itemAuthorLatest":"1","itemAuthorLatestLimit":"5","itemRelated":"1","itemRelatedLimit":"5","itemRelatedTitle":"1","itemRelatedCategory":"0","itemRelatedImageSize":"0","itemRelatedIntrotext":"0","itemRelatedFulltext":"0","itemRelatedAuthor":"0","itemRelatedMedia":"0","itemRelatedImageGallery":"0","itemK2Plugins":"1","catMetaDesc":"","catMetaKey":"","catMetaRobots":"","catMetaAuthor":""}

My MENU item is type CategoryBlogList, and link to Category A.
Articles are displayed as follows: Title=YES, ... (just like set in Joomla default option for Articles.
And now, if I set Display Title=NO in Joomla default option for Articles, the Title is no more displayed.

Any setting missing? Anything to do in Joomla?
Thank you.

The hosting company said that there are querries creating that blocked all the database connection.

Particularly they said

That is the query that your developer needs to review.
That is what is causing the lock

3025410 680368_briefing 10.187.248.40:53345 680368_briefingnews Query 15
Sending data SELECT COUNT(*) FROM ere_k2_items as i LEFT JOIN
ere_k2_categories c ON c.id = i.catid LEFT JOIN ere_k2_tags_xref tags_xref
ON tags_xref.itemID = i.id LEFT JOIN ere_k2_tags tags ON tags.id =
tags_xref.tagID WHERE i.published = 1 AND i.access <= 0 AND

i.trash = 0 AND c.published = 1 AND c.access <= 0 AND c.trash = 0 AND (
i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-05
09:53:29' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down
>= '2013-06-05 09:53:29' ) AND (tags.name) = '???????????'


This is probably the culprit
SELECT DISTINCT\n\t\t\t\tcats.title AS cat, \n\t\t\t\tusers.name AS
author,\n\t\t\t\tusers.email AS author_email,\n\t\t\t\tcats.section AS SID,
\n\t\t\t\tcontent.title AS title, \n\t\t\t\tcontent.introtext AS text,
\n\t\t\t\tcontent.created AS date, \n\t\t\t\tcontent.publish_up AS
date_publish,\n\t\t\t content.images AS images, \n\t\t\t\tcontent.id AS
IID,\n\t\t\t\tcontent.hits AS hits,\n\t\t\t\tcontent_rating.rating_sum AS
rating_sum,\n\t\t\t\tcontent_rating.rating_count AS
rating_count,\n\t\t\t\tCASE WHEN CHAR_LENGTH(content.alias)
\n\t\t\t\t\tTHEN CONCAT_WS(":", content.id, content.alias)
\n\t\t\t\t\t\tELSE content.id END as ID, \n\t\t\t\tCASE WHEN
CHAR_LENGTH(cats.alias) \n\t\t\t\t\tTHEN CONCAT_WS(":", cats.id,
cats.alias) \n\t\t\t\t\t\tELSE cats.id END as CID \t\t\t\t\t\n\t\t\tFROM
\n\t\t\t\tjos_content AS content \n\t\t\t\tLEFT JOIN
\n\t\t\t\t\tjos_categories AS categories \n\t\t\t\t\tON categories.id =
content.catid \n\t\t\t\t\n\t\t\t\tLEFT JOIN \n\t\t\t\t\tjos_sections AS
sections \n\t\t\t\t\tON sections.id = content.sectionid \n\t\t\t\tLEFT JOIN
\n\t\t\t\t\tjos_users AS users \n\t\t\t\t\tON users.id =
content.created_by\n\t\t\t\tLEFT JOIN \n\t\t\t\t\tjos_content_frontpage AS
frontpage \n\t\t\t\t\tON content.id = frontpage.content_id
\t\t\t\n\t\t\t\tLEFT JOIN \n\t\t\t\t\tjos_categories AS cats
\n\t\t\t\t\tON content.catid = cats.id \t\n\t\t\t\tLEFT JOIN
\n\t\t\t\t\tjos_content_rating AS content_rating \n\t\t\t\t\tON
content_rating.content_id = content.id\n\t\t\tWHERE \n\t\t\t\tcontent.state
= 1 \n\t\t\t\t\tAND categories.access <= 0 \n\t\t\t\t\tAND content.access
<= 0 \n\t\t\t\t \tAND categories.published = 1 \n\t\t\t\t\tAND (
content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <=
'2013-06-05 10:03:53' )\n\t\t\t\t\tAND ( content.publish_down = '0000-00-00
00:00:00' OR content.publish_down >= '2013-06-05 10:03:53' )\n\t\t\t\tAND (
content.catid = 91 OR content.catid = 94 OR content.catid = 99 OR
content.catid = 100 OR content.catid = 101 OR content.catid = 104 OR
content.catid = 106 OR content.catid = 107 OR content.catid = 108 OR
content.catid = 109 OR content.catid = 110 OR content.catid = 112 OR
content.catid = 113 OR content.catid = 115 OR content.catid = 116 OR
content.catid = 117 OR content.catid = 118 OR content.catid = 119 OR
content.catid = 126 OR content.catid = 130 OR content.catid = 133 OR
content.catid = 140 OR content.catid = 141 OR content.catid = 144 OR
content.catid = 188 OR content.catid = 190 OR content.catid = 195 OR
content.catid = 197 OR content.catid = 198 OR content.catid = 201 OR
content.catid = 202 OR content.catid = 203 OR content.catid = 208 OR
content.catid = 209 OR content.catid = 210 OR content.catid = 211 OR
content.catid = 212 OR content.catid = 213 OR content.catid = 214 OR
content.catid = 215 OR content.catid = 216 OR content.catid = 217 OR
content.catid = 218 OR content.catid = 219 OR content.catid = 220 OR
content.catid = 221 OR content.catid = 222 OR content.catid = 226 OR
content.catid = 232 OR content.catid = 233 OR content.catid = 234 OR
content.catid 235 OR content.catid = 236 OR content.catid = 237 OR
content.catid = 238 OR content.catid = 239 OR content.catid = 240 OR
content.catid = 241 OR content.catid = 242 OR content.catid = 244 OR
content.catid = 266 OR content.catid = 267 OR content.catid = 269 OR
content.catid = 270 OR content.catid = 271 OR content.catid = 272 OR
content.catid = 273 OR content.catid = 274 OR content.catid = 275 OR
content.catid = 276 OR content.catid = 277 OR content.catid = 278 OR
content.catid = 282 OR content.catid = 283 OR content.catid = 284 OR
content.catid = 285 OR content.catid = 286 OR content.catid = 287 OR
content.catid = 288 OR content.catid = 289 OR content.catid = 290 OR
content.catid = 291 OR content.catid = 302 OR content.catid = 331 )
\n\t\t\t\t \n\t\t\t\t\n\t\t\tORDER BY \n\t\t\t\t content.created DESC
\n\t\t\tLIMIT\n\t\t\t\t0,4

The issue is going to come up again.
I had you in chat yesterday with the same problem.
We need to resolve this in your database or prevent the database from
affecting the cluster.

The admin asked if you could disable the tracking plugin.
He believes that is what is locking the tables.

I would recommend running an optimize on the database.

More info from the admin to give to the client developer
SELECT COUNT(*) FROM ere_k2_items as i LEFT JOIN ere_k2_categories c
ON c.id= i.catid LEFT JOIN ere_k2_tags_xref tags_xref ON
tags_xref.itemID =
i.id LEFT JOIN ere_k2_tags tags ON tags.id = tags_xref.tagID WHERE
i.published = 1 AND i.access <= 0 AND i.trash = 0 AND c.published = 1 AND
c.access <= 0 AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR
i.publish_up <= '2013-06-05 10:35:16' ) AND ( i.publish_down = '0000-00-00
00:00:00' OR i.p
That is also getting locked.
it's searching for values of tags.name that = '???????????'
it's always returning an empty set
Probably searching for foreign characters. You may have an issue with
character set that needs to be reviewed.

And last recommendation.
the ere_k2_tags table is myisam and has a fulltext index on the name column
the problem is.... the name of the tags is so short, a fulltext index isn't
needed. It should be changed to InnoDB

if you can not login into myadmin, you probably have too many connections
to the database

You need to fix the problems with your code.
If you can not access the tools to repair your site, take it offline until
you can correct the problem.
This is going to continue until the problems are corrected
If the admin finds the database affecting the cluster he will limit the
amount of connections until you repair the database
and the code connecting to it.



Please help me get rid of this situation.

I am despaired

Hi sicop,

too bad you didn't receive the solution. It's not that difficult, really. Although my solution is not a nice one one and I'd hope there is (or someday will be) a better one.

I simply hid the title in the module and then added this to
\templates\joostrap\html\mod_k2_content\Default\default.php

Mine is a News category, and I copied the URL from a link that I created in an article. If I now change anything about the category, the link will break, of course ... Also, the <a> tags should not be around the <h3> tags, but in my case it's necessary to avoid difficulties with the styling.

Hello Brian,

echo $params->get(xxx) will always return 0 or 1 because it is just boolean (check).

For the comments you will have to use a category_item.php override ( assuming your menu item is a K2 categories one.)

You will notice that this template part uses $this->item instead of $item so you will need the variables
Displaying 3421 - 3440 out of 6582 results.

1. Forum
3. Search