COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: k2 Tag)

  • Thorbjorn Waagstein
  • Thorbjorn Waagstein's Avatar
21 Oct 2015 21:16
Replied by Thorbjorn Waagstein on topic K2 is generating the wrong OG Tag

K2 is generating the wrong OG Tag

Category: English K2 Community

Thanks for the answer. I tried to deactivate all the social plugins I could find (including "follow-me"), but the problem persists. Next I updatex to Joomla 3.2.7, but there was no suggestion in Joomla Update update K2. There is a suggestion to update to Joomla 4.4, but I will have to make sure first that my provider has the right PHP version for that.
By the way, after the Joomla update, my page doesn't load (Not found message). I am waiting for my server administrator to look at that. But basically, the problem is not solved.
  • Oliver Widmann
  • Oliver Widmann's Avatar
21 Oct 2015 17:49 - 21 Oct 2015 17:51
Display article filtered by tag in another article was created by Oliver Widmann

Display article filtered by tag in another article

Category: English K2 Community

Hey everyone,

i really like customizing K2 for displaying articles in a beautiful way in Joomla.. But this time i have no idea to solve this:

I want to display the description and the image of an specific article in another article. The article should be filtered of the tag similar to the title of the article it's shown in.

In clear words:
{item-> load item2Descirption by (item2tag=itemTitle)}
{item-> load item2Image by (item2tag=itemTitle)}

I hope someone can help me - i'm not very good in PHP.
Thanks a lot! :)
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
21 Oct 2015 12:47
Replied by Krikor Boghossian on topic K2 is generating the wrong OG Tag

K2 is generating the wrong OG Tag

Category: English K2 Community

Hello,

There are a couple of issues with your site.
First please update to K2 and Joomla!'s latest version. This is a security precaution.

Furthermore K2 is generating the correct metatags. There are however three more sets of og: tags generated by a 3rd party extension.

It is really possible that these tags are being generated from the social sharing extension you are using.
  • APRU
  • APRU's Avatar
21 Oct 2015 04:32
Replied by APRU on topic Joomla K2 JCE Editor Issues

Joomla K2 JCE Editor Issues

Category: English K2 Community

Hi Krikor,

It works fine when I am on a PC. But does not work (on any browser) when I am using my Mac. Whenever I click the save buttons a hashtag appears at the end of the link and the page stops loading, hence therefore I cannot make changes as I am unable to save the article.
  • Thorbjorn Waagstein
  • Thorbjorn Waagstein's Avatar
21 Oct 2015 01:35
Replied by Thorbjorn Waagstein on topic K2 is generating the wrong OG Tag

K2 is generating the wrong OG Tag

Category: English K2 Community

I have the same problem on my website: www.waagstein.com. When I paste a link to an item on Facebook (e.g. waagstein.com/index.php?option=com_k2&view=item&id=106:grand-canal&Itemid=278&lang=en), the right text and image pop up, but a wrong title from another item is displayed. I tried the changes to the view.html.php (under the folder components/com_k2/views/item) as suggested here: www.itoctopus.com/k2-and-setting-the-wrong-open-graph-description-meta-tag, but that didn't change anything. Any suggestrions? (I am using the template NuBlog)
  • German Levi
  • German Levi's Avatar
20 Oct 2015 14:27
Replied by German Levi on topic materials on the tag the description field empty

materials on the tag the description field empty

Category: English K2 Community

Thanks for the support! All done. If anyone needs me, here in the file template-name/html/com_k2/default/tag.php insert code:
<?php
$meta_descr = $this->params->get('page_title');
$doc =& JFactory::getDocument();
$doc->setMetaData('description',$meta_descr);
?>
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
20 Oct 2015 14:07
Replied by Krikor Boghossian on topic materials on the tag the description field empty

materials on the tag the description field empty

Category: English K2 Community

This post will explain it better: www.joomlaworks.net/blog/item/194-k2-inheritance-sub-templating
  • German Levi
  • German Levi's Avatar
19 Oct 2015 23:22
Replied by German Levi on topic materials on the tag the description field empty

materials on the tag the description field empty

Category: English K2 Community

Thank You,Krikor. Do I understand correctly that this file tag.php located in/templates / name-template/com_k2/default ? However, I have each category has its own template and its tag.php! In some of them to write code? The structure of kataloga com_k2/1-cam_k2 cat/2-cat and so on...
  • Nick
  • Nick's Avatar
19 Oct 2015 21:54 - 19 Oct 2015 22:24
Replied by Nick on topic Κ2 heavy load on large database, gateway timeouts

Κ2 heavy load on large database, gateway timeouts

Category: English K2 Community

The favicon doesn't change anything and if i place it in the root folder, it just takes a 200 status code instead of 404. But all those requests are not actual visits. Because in awstats and in google analytics those days we have approximately 300-400 visits. To be more specific yesterday in awstats we had 359 visits, and in google analytics 100 visits. Those differences are acceptable because they count the unique visitor in different time span. But in the access log i count over 70.000 unique IP's. Because i manage other websites also, and i am seeing similar statistics, in another website for yesterday we had 326 visits in awstats, and 84 visits in google analytics. In the access log we had only 15.000 unique IP's. The status codes with the favicon request are only a few, and the referrers are all articles from the originating website and only a few links from other ones. As we can see there is a huge difference here, as we had similar stats here in analytics and in awstats but in the access log there is almost 5 times the traffic. So that's why i suspect we need a bigger VPS with more RAM to handle this traffic. What do you want to know about the setup, i can send you a link to visit the website. In short the website occupies about 7.5Gb, and the SQL almost 2Gb. It has 10.000 articles in K2, 9 categories, 4000 tags, and 100 comments. As for the VPS it has 3 Cores, 1024Mb ram, 80GB HD and 350GB Bandwidth. In the subfolder it works, although and in here we have some timeouts, but very few. When i move it in root it simply cannot work, it floods with the requests and the whole VPS actually is unaccessible, not only the website.
  • benner
  • benner's Avatar
19 Oct 2015 21:06 - 19 Oct 2015 21:07
Replied by benner on topic Create table using items extra fields

Create table using items extra fields

Category: English K2 Community

So far i have done this:

1. I have created a new k2 template folder: com_k2/templates/table

2. In com_k2/templates/table/category_item.php I have this (I have added the code after <!-- extrafields columns -->):
<?php /** * @version 2.6.x * @package K2 * @author JoomlaWorks https://www.joomlaworks.net * @copyright Copyright (c) 2006 - 2014 JoomlaWorks Ltd. All rights reserved. * @license GNU/GPL license: http://www.gnu.org/copyleft/gpl.html */ // no direct access defined('_JEXEC') or die; // Define default image size (do not change) K2HelperUtilities::setDefaultImage($this->item, 'itemlist', $this->params); ?> <!-- Start K2 Item Layout --> <div class="catItemView group<?php echo ucfirst($this->item->itemGroup); ?><?php echo ($this->item->featured) ? ' catItemIsFeatured' : ''; ?><?php if($this->item->params->get('pageclass_sfx')) echo ' '.$this->item->params->get('pageclass_sfx'); ?>"> <!-- Plugins: BeforeDisplay --> <?php echo $this->item->event->BeforeDisplay; ?> <!-- K2 Plugins: K2BeforeDisplay --> <?php echo $this->item->event->K2BeforeDisplay; ?> <div class="catItemHeader"> <?php if($this->item->params->get('catItemDateCreated')): ?> <!-- Date created --> <span class="catItemDateCreated"> <?php echo JHTML::_('date', $this->item->created , JText::_('K2_DATE_FORMAT_LC2')); ?> </span> <?php endif; ?> <?php if($this->item->params->get('catItemTitle')): ?> <!-- Item title --> <h3 class="catItemTitle"> <?php if(isset($this->item->editLink)): ?> <!-- Item edit link --> <span class="catItemEditLink"> <a class="modal" rel="{handler:'iframe',size:{x:990,y:550}}" href="<?php echo $this->item->editLink; ?>"> <?php echo JText::_('K2_EDIT_ITEM'); ?> </a> </span> <?php endif; ?> <?php if ($this->item->params->get('catItemTitleLinked')): ?> <a href="<?php echo $this->item->link; ?>"> <?php echo $this->item->title; ?> </a> <?php else: ?> <?php echo $this->item->title; ?> <?php endif; ?> <?php if($this->item->params->get('catItemFeaturedNotice') && $this->item->featured): ?> <!-- Featured flag --> <span> <sup> <?php echo JText::_('K2_FEATURED'); ?> </sup> </span> <?php endif; ?> </h3> <?php endif; ?> <?php if($this->item->params->get('catItemAuthor')): ?> <!-- Item Author --> <span class="catItemAuthor"> <?php echo K2HelperUtilities::writtenBy($this->item->author->profile->gender); ?> <?php if(isset($this->item->author->link) && $this->item->author->link): ?> <a rel="author" href="<?php echo $this->item->author->link; ?>"><?php echo $this->item->author->name; ?></a> <?php else: ?> <?php echo $this->item->author->name; ?> <?php endif; ?> </span> <?php endif; ?> </div> <!-- Plugins: AfterDisplayTitle --> <?php echo $this->item->event->AfterDisplayTitle; ?> <!-- K2 Plugins: K2AfterDisplayTitle --> <?php echo $this->item->event->K2AfterDisplayTitle; ?> <?php if($this->item->params->get('catItemRating')): ?> <!-- Item Rating --> <div class="catItemRatingBlock"> <span><?php echo JText::_('K2_RATE_THIS_ITEM'); ?></span> <div class="itemRatingForm"> <ul class="itemRatingList"> <li class="itemCurrentRating" id="itemCurrentRating<?php echo $this->item->id; ?>" style="width:<?php echo $this->item->votingPercentage; ?>%;"></li> <li><a href="#" data-id="<?php echo $this->item->id; ?>" title="<?php echo JText::_('K2_1_STAR_OUT_OF_5'); ?>" class="one-star">1</a></li> <li><a href="#" data-id="<?php echo $this->item->id; ?>" title="<?php echo JText::_('K2_2_STARS_OUT_OF_5'); ?>" class="two-stars">2</a></li> <li><a href="#" data-id="<?php echo $this->item->id; ?>" title="<?php echo JText::_('K2_3_STARS_OUT_OF_5'); ?>" class="three-stars">3</a></li> <li><a href="#" data-id="<?php echo $this->item->id; ?>" title="<?php echo JText::_('K2_4_STARS_OUT_OF_5'); ?>" class="four-stars">4</a></li> <li><a href="#" data-id="<?php echo $this->item->id; ?>" title="<?php echo JText::_('K2_5_STARS_OUT_OF_5'); ?>" class="five-stars">5</a></li> </ul> <div id="itemRatingLog<?php echo $this->item->id; ?>" class="itemRatingLog"><?php echo $this->item->numOfvotes; ?></div> <div class="clr"></div> </div> <div class="clr"></div> </div> <?php endif; ?> <div class="catItemBody"> <!-- Plugins: BeforeDisplayContent --> <?php echo $this->item->event->BeforeDisplayContent; ?> <!-- K2 Plugins: K2BeforeDisplayContent --> <?php echo $this->item->event->K2BeforeDisplayContent; ?> <?php if($this->item->params->get('catItemImage') && !empty($this->item->image)): ?> <!-- Item Image --> <div class="catItemImageBlock"> <span class="catItemImage"> <a href="<?php echo $this->item->link; ?>" title="<?php if(!empty($this->item->image_caption)) echo K2HelperUtilities::cleanHtml($this->item->image_caption); else echo K2HelperUtilities::cleanHtml($this->item->title); ?>"> <img src="<?php echo $this->item->image; ?>" alt="<?php if(!empty($this->item->image_caption)) echo K2HelperUtilities::cleanHtml($this->item->image_caption); else echo K2HelperUtilities::cleanHtml($this->item->title); ?>" style="width:<?php echo $this->item->imageWidth; ?>px; height:auto;" /> </a> </span> <div class="clr"></div> </div> <?php endif; ?> <?php if($this->item->params->get('catItemIntroText')): ?> <!-- Item introtext --> <div class="catItemIntroText"> <?php echo $this->item->introtext; ?> </div> <?php endif; ?> <div class="clr"></div> <?php if($this->item->params->get('catItemExtraFields') && count($this->item->extra_fields)): ?> <!-- Item extra fields --> <div class="catItemExtraFields"> <h4><?php echo JText::_('K2_ADDITIONAL_INFO'); ?></h4> <ul> <?php foreach ($this->item->extra_fields as $key=>$extraField): ?> <?php if($extraField->value != ''): ?> <li class="<?php echo ($key%2) ? "odd" : "even"; ?> type<?php echo ucfirst($extraField->type); ?> group<?php echo $extraField->group; ?>"> <?php if($extraField->type == 'header'): ?> <h4 class="catItemExtraFieldsHeader"><?php echo $extraField->name; ?></h4> <?php else: ?> <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span> <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span> <?php endif; ?> </li> <?php endif; ?> <?php endforeach; ?> </ul> <div class="clr"></div> </div> <?php endif; ?> <!-- Plugins: AfterDisplayContent --> <?php echo $this->item->event->AfterDisplayContent; ?> <!-- K2 Plugins: K2AfterDisplayContent --> <?php echo $this->item->event->K2AfterDisplayContent; ?> <div class="clr"></div> </div> <?php if( $this->item->params->get('catItemHits') || $this->item->params->get('catItemCategory') || $this->item->params->get('catItemTags') || $this->item->params->get('catItemAttachments') ): ?> <div class="catItemLinks"> <?php if($this->item->params->get('catItemHits')): ?> <!-- Item Hits --> <div class="catItemHitsBlock"> <span class="catItemHits"> <?php echo JText::_('K2_READ'); ?> <b><?php echo $this->item->hits; ?></b> <?php echo JText::_('K2_TIMES'); ?> </span> </div> <?php endif; ?> <?php if($this->item->params->get('catItemCategory')): ?> <!-- Item category name --> <div class="catItemCategory"> <span><?php echo JText::_('K2_PUBLISHED_IN'); ?></span> <a href="<?php echo $this->item->category->link; ?>"><?php echo $this->item->category->name; ?></a> </div> <?php endif; ?> <?php if($this->item->params->get('catItemTags') && count($this->item->tags)): ?> <!-- Item tags --> <div class="catItemTagsBlock"> <span><?php echo JText::_('K2_TAGGED_UNDER'); ?></span> <ul class="catItemTags"> <?php foreach ($this->item->tags as $tag): ?> <li><a href="<?php echo $tag->link; ?>"><?php echo $tag->name; ?></a></li> <?php endforeach; ?> </ul> <div class="clr"></div> </div> <?php endif; ?> <?php if($this->item->params->get('catItemAttachments') && count($this->item->attachments)): ?> <!-- Item attachments --> <div class="catItemAttachmentsBlock"> <span><?php echo JText::_('K2_DOWNLOAD_ATTACHMENTS'); ?></span> <ul class="catItemAttachments"> <?php foreach ($this->item->attachments as $attachment): ?> <li> <a title="<?php echo K2HelperUtilities::cleanHtml($attachment->titleAttribute); ?>" href="<?php echo $attachment->link; ?>"> <?php echo $attachment->title ; ?> </a> <?php if($this->item->params->get('catItemAttachmentsCounter')): ?> <span>(<?php echo $attachment->hits; ?> <?php echo ($attachment->hits==1) ? JText::_('K2_DOWNLOAD') : JText::_('K2_DOWNLOADS'); ?>)</span> <?php endif; ?> </li> <?php endforeach; ?> </ul> </div> <?php endif; ?> <div class="clr"></div> </div> <?php endif; ?> <div class="clr"></div> <?php if($this->item->params->get('catItemVideo') && !empty($this->item->video)): ?> <!-- Item video --> <div class="catItemVideoBlock"> <h3><?php echo JText::_('K2_RELATED_VIDEO'); ?></h3> <?php if($this->item->videoType=='embedded'): ?> <div class="catItemVideoEmbedded"> <?php echo $this->item->video; ?> </div> <?php else: ?> <span class="catItemVideo"><?php echo $this->item->video; ?></span> <?php endif; ?> </div> <?php endif; ?> <?php if($this->item->params->get('catItemImageGallery') && !empty($this->item->gallery)): ?> <!-- Item image gallery --> <div class="catItemImageGallery"> <h4><?php echo JText::_('K2_IMAGE_GALLERY'); ?></h4> <?php echo $this->item->gallery; ?> </div> <?php endif; ?> <div class="clr"></div> <?php if($this->item->params->get('catItemCommentsAnchor') && ( ($this->item->params->get('comments') == '2' && !$this->user->guest) || ($this->item->params->get('comments') == '1')) ): ?> <!-- Anchor link to comments below --> <div class="catItemCommentsLink"> <?php if(!empty($this->item->event->K2CommentsCounter)): ?> <!-- K2 Plugins: K2CommentsCounter --> <?php echo $this->item->event->K2CommentsCounter; ?> <?php else: ?> <?php if($this->item->numOfComments > 0): ?> <a href="<?php echo $this->item->link; ?>#itemCommentsAnchor"> <?php echo $this->item->numOfComments; ?> <?php echo ($this->item->numOfComments>1) ? JText::_('K2_COMMENTS') : JText::_('K2_COMMENT'); ?> </a> <?php else: ?> <a href="<?php echo $this->item->link; ?>#itemCommentsAnchor"> <?php echo JText::_('K2_BE_THE_FIRST_TO_COMMENT'); ?> </a> <?php endif; ?> <?php endif; ?> </div> <?php endif; ?> <?php if ($this->item->params->get('catItemReadMore')): ?> <!-- Item "read more..." link --> <div class="catItemReadMore"> <a class="k2ReadMore" href="<?php echo $this->item->link; ?>"> <?php echo JText::_('K2_READ_MORE'); ?> </a> </div> <?php endif; ?> <div class="clr"></div> <?php if($this->item->params->get('catItemDateModified')): ?> <!-- Item date modified --> <?php if($this->item->modified != $this->nullDate && $this->item->modified != $this->item->created ): ?> <span class="catItemDateModified"> <?php echo JText::_('K2_LAST_MODIFIED_ON'); ?> <?php echo JHTML::_('date', $this->item->modified, JText::_('K2_DATE_FORMAT_LC2')); ?> </span> <?php endif; ?> <?php endif; ?> <!-- Plugins: AfterDisplay --> <?php echo $this->item->event->AfterDisplay; ?> <!-- K2 Plugins: K2AfterDisplay --> <?php echo $this->item->event->K2AfterDisplay; ?> <div class="clr"></div> </div> <!-- End K2 Item Layout --> <!-- extrafields columns --> <div class="extrafieldscolumns"> <ul> <li><?php echo $this->item->extraFields->headquarter->value ;?></li> <li><?php echo $this->item->extraFields->founded->value ;?></li> <li><?php echo $this->item->extraFields->minimum-deposit->value ;?></li> </ul> </div> <!-- END extrafields columns -->


3. I have added the following paragraph at the end of the k2 .css file:

/* extrafields columns */

.extrafieldscolumns ul { width: 100%; margin:0;padding:0; /* CSS Reset */ max-width: 1000px; /* restrict the width */ margin: auto; /* center it */}.extrafieldscolumns li { width: 20%; float:left; /* IMPORTANT */ list-style-type: none; display:inline; /* IMPORTANT */}

/* END extrafields columns */




4. I have then selected the new created template ("table") in the K2 category for which I want to use the table.


The result looks like this:

K2 item 1
Headquarter: New York
Date Created: 1980
Minimum Deposit: 5000

K2 item 2
Headquarter Berlin
Date Created 1958
Minimum Deposit 3000

K2 item 3
Headquarter London
Date Created 1973
Minimum Deposit 3500



Instead of this:


Headquarter I Date Created I Minimum Deposit
K2 item 1 New York 1980 5000
K2 item 2 Berlin 1958 3000
K2 item 2 London 1973 3500
  • brokie
  • brokie's Avatar
19 Oct 2015 21:06
Problems whit Additional Categories was created by brokie

Problems whit Additional Categories

Category: English K2 Community

I have a complicated problem with the module K2 Joomla.

Currently I am an old 1.5 site to update to Joomla 3.4. All 600 articles from the old site are neatly along migrated to 3.4 and K2 also runs on the latest version.

Many articles have been assigned to multiple categories and also all get along tags.

In the structure in which categories listed himself no items. But articles from other categories are also assigned to this.

So I installed the plugin "Additional Categories for K2" and all adjustment equalized as they are set in the old 1.5 site. For both categories for the menu.
However, I do not see any articles which are assigned to a second (blank) category.

I know there are dozens of possible settings, but like all such as are in the 1.5 site, why I see nothing.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
15 Oct 2015 16:44
Replied by Krikor Boghossian on topic Install K2 3.0 on a live website

Install K2 3.0 on a live website

Category: English K2 Community

The front-end is not yet finalised, so if you do not know your way around coding. (No need to be a guru, simple Joomla! HTML/PHP stuff) you might not want to install v3 into a production site.

Furthermore it is important to test it on a dev/ staging environment to see how 3rd party extension play with it.
  • Kelsey Brookes
  • Kelsey Brookes's Avatar
15 Oct 2015 04:47
Replied by Kelsey Brookes on topic K2 Tools & Smart Search

K2 Tools & Smart Search

Category: English K2 Community

I know, I just dislike how overblown most of the search modules are on the JED.

The advantage of the K2 search is that its module is simple and fast - the disadvantage is that the search results are a bit ordinary. Combine it with smart search and you have the best of both worlds. I think I'll have to get that built :)

And Google. Decent results, but not for my clients - we're a brand agency and do work for other brand agencies, so being able to maintain complete control over style is important.

Thanks anyway :)
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
14 Oct 2015 15:26
Replied by Krikor Boghossian on topic Κ2 heavy load on large database, gateway timeouts

Κ2 heavy load on large database, gateway timeouts

Category: English K2 Community

The issue in the post you saw was located in the mod_k2_tools module (tag cloud). Are you using this module?

Also changing from Apache to Nginx was a really good move, since Nginx can handle way more more concurrent requests and sessions.

In your position since throwing money into larger and larger VPSs' is not a solution I would enable caching and use a CDN.
I have heard excellent things about fastly. Maxcdn and cloudflare are also reliable CDNs.
  • Kelsey Brookes
  • Kelsey Brookes's Avatar
14 Oct 2015 07:58
K2 Tools & Smart Search was created by Kelsey Brookes

K2 Tools & Smart Search

Category: English K2 Community

I'm having some issues with K2 search using mod_k2_tools.

The search results aren't great because they're unweighted with regards to the search-target title/content/tags and because the search is a straight 'or' search.

I.e., if I do a search on "The Guide To Rebranding" on a site I'm building with Smart Search I get two very very good results.

Using K2 Tools, I get almost every page on the site because the search is "or" for every word.

Is there a way of using Smart Search with K2 Tools so I can use K2 Tools to specify the search categories?

Or is there a way of creating a filter map for K2 within Smart Search so I can just use that instead?
  • Nick
  • Nick's Avatar
13 Oct 2015 19:05
Κ2 heavy load on large database, gateway timeouts was created by Nick

Κ2 heavy load on large database, gateway timeouts

Category: English K2 Community

Hello to all the community

Since sometime (about 2 years ago) i built a joomla website based mainly on K2 for all the articles. The site is based mainly in news and political content and it has high activity, since there are posted at about 10-15 articles a day. At about 2-3 months ago some problems appeared in the stability of the site, since at frequent times the server was unable to handle the load and we was facing "503 temporary service unavailable" problems. In the beginning we thought these problems was due to high visitor count, since we had at about 4-5.000 unique visitors a day. But at about 2-3 weeks ago the problem worsen so much that the web host forced to disable the database since it was making huge database queries and it was affecting the nearby servers and almost the whole network. Initially we was at a shared hosting.

They told us that due to very high activity we should move better to a VPS in order to handle the high load of visitors (about 7-8000 unique visitors a day) and that the database (almost 2gigabytes) was very huge to work properly. So at last we moved to a VPS. But after the migration nothing changed, the same problem appeared and in the new server. Initially we thought that the resources wasn't enough, so we upgraded temporarily, actually they doubled the RAM of the server, but again the same problem was persisting. From the host they told me that the problem was the SQL server and the database was making large queries that was unable to complete so it was overloading, the same time HDD activity was at about 50-60Mb/s and the server was unable to make anything else so the website was always down and unavailable. Here you can see the activity from the server:

File Attachment:


I told them to send me the large query that made the problem and it is the following:

SELECT a.*, cc.name AS cattitle, cc.id AS categoryid, cc.alias AS categoryalias, cc.params AS categoryparams, u.username as username, u.name as realname FROM xxkw9_k2_items a LEFT JOIN xxkw9_k2_categories cc ON cc.id=a.catid
LEFT JOIN xxkw9_users AS u ON u.id = a.created_by WHERE a.published =1 AND a.trash = 0 AND cc.trash = 0 AND cc.published = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-10-10 19:53:56' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-10-10 19:53:56' ) AND cc.id IN (8,9,10,11,12,13,14,17,15,21)

I forgot to mention that we have about 10.000 items in K2 articles and almost 4 to 5.000 tags. After those facts i forced to move the site in a subfolder, and magically there it was functioning properly and fairly fast. When i was moving the site in the root folder, we had the same problems with the overload. I even disabled all the plugins and the modules in the frontpage and i left only the articles. But nothing changed.
From other similar cases i read that maybe the tags was the problem, because i saw a large query with tags, you can see it here:

codepaste.net/r55o6r

So i read here that with a minor change in the code, we can disable the IDs from querying the database. Here is the post:

www.joomlaworks.net/forum/k2-en/42833-k2-tags-causing-slow-mysql-queries

So i disabled the IDs but again nothing changed, i saw some small improvements but the initial problem persisted. By the way here are the queries at a whole, through the debug system of joomla:

codepaste.net/q4ffiw
codepaste.net/r55o6r
codepaste.net/5rojbi

You can spot that there are a large number of queries that they are repeated 3,4 or 5 times and i don't know the reason.

As a temporary measure, as i told you early i moved the website in a subfolder, and through htaccess i redirected all the traffic there with this code:

RewriteEngine On
RewriteRule ^(/)?$ subfolder [L]

In the beginning it seems it was working, but again we had the same problem. So i made a single php page with a redirection to the subfolder:

<?php
Header( "HTTP/1.1 301 Moved Permanently" );
Header( "Location: www.example.com/subfolder" );
?>

This time things was better, the website was working, but again at frequent manner we had again the overload and the site was unavailable. Here is the past 12 hours from today:

File Attachment:


In the blue peaks the whole server is unavailable and no one can see the website.
At the peak load the CPU was also very high, here are some numbers

Last 1 minute 20.95
Last 5 minutes 31.52
Last 15 minutes 28.09

In order for the server to work seamlessly these numbers must be under 5.00
From the technical stuff of the host they did some changes, i.e they changed the server from Apache to Nginx, but they couldn't do much more, they told me that the problem is the large database, only one table is about 1 Gigabyte and the database as a whole nearly 2, and the problem was in K2 so i must look there.

Please guys help me, for about a week or so i am dealing with this problem and i can't find a permanent solution, only temporary fixes but the problem is here, and you can imagine the visitors that see all these problems, all the past weeks. When there is an overload i am forcing to restart the VPS in order to calm down from the queries. Some people told me to delete the tags and see what is happening and if the database shrinks. But this isn't a good solution since the guy that manage the webpage, needs them.

If you can propose anything i would be glad.
Thanks in advance...
  • Mohamed Abdelaziz
  • Mohamed Abdelaziz's Avatar
13 Oct 2015 10:12
Replied by Mohamed Abdelaziz on topic Extra Field within Item Fulltext

Extra Field within Item Fulltext

Category: English K2 Community

Hi Joe,

In my plugin AutoMeta for K2 I'm replacing the strings like {ef_FieldAlias} with the field value in the meta keywords and description tags.

If you need something like this, but with the FullText instead of the meta tags, I think this can be done with a little modification to this plugin, let me know if this is what you want.
  • Andrew Voronov
  • Andrew Voronov's Avatar
07 Oct 2015 12:28 - 07 Oct 2015 12:46
Replied by Andrew Voronov on topic K2 tag filtering doesn't work with SEF

K2 tag filtering doesn't work with SEF

Category: English K2 Community

How to create menu item for the list of all K2 tags? I think it will solve the issue.
Using menu I can create menu item only for one K2 tag.

I just found that K2 search module also doesn't work. When I try to search it send me to 404 page with url "/en/search.html?searchword=money" (search word was "money", I turned on Advanced K2 SEF settings)
  • Andrew Voronov
  • Andrew Voronov's Avatar
07 Oct 2015 12:18 - 07 Oct 2015 12:25
Replied by Andrew Voronov on topic K2 tag filtering doesn't work with SEF

K2 tag filtering doesn't work with SEF

Category: English K2 Community

I added menu item for K2 tag "Android" with url "mytags", and when I click to the menu item - tag filtering by tag "Android" works. Tag filtering also works for tag "Android" in category list, but it works only for tag "Android" (as I created menu item) and url for such tag is "/en/mytags.html" (the same url as for menu item). May be it can help to solve issue?

Also I created menu item for the list of tag (joomla component tags) and when I filtering by joomla item tag I got such url "/en/menu-item-url/13-blog.html". As you may see url contains id for the tag. Why K2 doesn't contain ID for K2 tags?
Displaying 1601 - 1620 out of 6582 results.
  1. Forum
  3. Search

Powered by Kunena Forum