Dear All,

I hope someone can tell me whats goes wrong.
When i Save a new item i got the following error message

Error 1146 :
Table 'groenpo_jos1.joox_k2_tags_xref' doesn't exist SQL=SELECT tr.id, tr.itemID, tr.tagId, t.name FROM joox_k2_tags_xref AS tr INNER JOIN joox_k2_tags AS t ON t.id = tr.tagID WHERE t.published = 1 AND tr.itemID = 12

You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

I see there is some problem with de Dbase, but i doesn't know how to solve

Please tell me what to do.

Grtz From holland
Manfred vd Waarsenburg

Hello Claire,

Please look at this post www.joomlaworks.net/forum/k2-en/46565-k2-featured-at-tag-php

Sorry for the delay,

About the TAG module everything is clear to me!

Currently the page is managed from our client and they don't remember
exactly which filters are using.
I am sending you the results that give Joomla debug gives when you follow this steps:
Login -> Components -> K2 -> Items

prntscr.com/cl3eox
prntscr.com/cl3glq
prntscr.com/cl3fuw

Its so embarrassing for us to know that the cause of sending our site down is the
backend of k2. Hope your can give us some useful tips to fix this.

Here is the K2 configuration parameters in the database
drive.google.com/file/d/0B_7CphkekgxgeHFWWDZhMGh3dHM/view?usp=sharing

If you want some extra information regarding the site please feel free to ask.

hi Krikor

thanx for spending time for me

the site is www.energybattle.nu

i have recorded the settings for Joomla and K2 and put them under the line

regards,

Henri

---

Joomla 3.6.2
General settings
[Website]
Default Captcha Captcha-ReCaptcha
Default accesslevel Public
E-mailaddress feed e-mailaddress author
[SERVER]
E-mailsettings
Send Mail Yes
Disable Groupmail No
Mailer PHP mail
Extensions / Manage
Enabled: Captcha-ReCaptha

Components/K2
[Advanced tab]
Hide Import buttons NO
Google Search integration NO
Container ID to render
the Google search ----
Enable K2 User Profile YES
Select the default K2 user
Group for new registrations Organisatie
Profile edit redirect Uw profiel
Administration item search Simple (Title only)
Cookie domain ---
Enable anonymous system
statistics gathering YES
Tagging system Free tagging (with auto complete)
Lock tags NO
Allow item filtering by tag
(in the backend) NO
Tag normalization Disable
Tag character case unset
Additional character
replacements --
{Anti-spam Settings}
reCaptcha public key empty
reCaptcha private key empty
reCAPTCHA Theme clean
Use reCAPTCHA v2 YES
Enable reCaptcha on
registration form NO
Akismet API key empty
Enable
StopForumSpam.com
integration on the user
registration form NO
StopForumSpam.com API
key empty
Control K2 User Profile
display for users with no
items Disabled
{Performance}
Item counter next to the
category title in the
category manager YES

Display items from both
parent and children
categories when filtering
items by category YES

Disable ordering
compacting NO

Hi,

I have enabled the option for Enable Facebook meta tags to Yes in the SOcial tab in global configuration. And also selected the image size to small when a user shares the item link to Facebook. But when I am posting to facebook the article link it is not taking the article image but taking some other image.

In facebook debug tool, it shows that 'The 'og:image' property should be explicitly provided, even if a value can be inferred from other tags.'

In source code of the article page I can see the property 'og:image' being set but also one more meta tag of image is being set.

<meta property="og:image" content="websitename.com/media/k2/items/cache/39a27618f1dc54b80987c6706135e6b7_S.jpg" />
<meta name="image" content="websitename.com/media/k2/items/cache/39a27618f1dc54b80987c6706135e6b7_S.jpg" />

Let me know please what am I missing here

You can use a function like this
stackoverflow.com/questions/965235/how-can-i-truncate-a-string-to-the-first-20-words-in-php

alongside with strip_tags() php.net/manual/en/function.strip-tags.php in case the layout breaks.

This should be applied to the introtext of the overriden category_item.php file. You can find more on overrides here: getk2.org/documentation/tutorials/174-templating-with-k2-and-the-concepts-of-sub-templates

Hello,

The most easy way would be to include a jQuery sorting script, www.sitepoint.com/top-5-jquery-filter-sort-plugins/

You would have to print the category as a CSS class and include a custom filtering menu. This can be done on your overrides.
getk2.org/documentation/tutorials/174-templating-with-k2-and-the-concepts-of-sub-templates

No, these are the module's settings.

Thanks, is that a menu item?

Hi,

How does it work exactly ?

*EDIT* solved it myself, stupid, forgot (since it was a while ago) that I myself, at the developer's instruction, renamed the original "onK2BeforeViewDisplay" function to "onK2BeforeViewDisplayCustom". This is why the map isn't shown at the top automatically, and I am allowed to call it when I want. In the meantime, I had to return the original PHP file, and I erased the change. In case anyone needs it, may not be the best, but is a quick solution to the problem. Thanks anyway if you wasted your time reading this :)

Hola,

I have a problem I believe Krikor or any of the crew can easily solve :)

I am using a 3rd party Google maps plugin. The developer helped me with a problem I had - my customized category view involved some Joomla modules in the "right" position, and the client insisted that the map had to be placed between two Joomla modules. This meant I was unable to use the regular "echo $this->item->event->K2.." call in the override, so the plugin developer came up with this piece of code I placed between two other plugin calls which loaded each module individually:


(of course, his plugin contains the aforementioned custom function)

Now, each K2 entry is associated with a Gmap set of coordinates, and when I use the Tag view, it properly shows all of the entries in the map. However, although I can customize the Tag view using override, I don't seem to be able to affect where the map (plugin) is displayed - it is automatically shown on top of the mainbody. Can I (and how?) also use the JDispatcher trigger in this view? To make things perfectly clear and simple: I would like to place the map just about anywhere I want :)

I am using K2 2.6.9, and as I don't intend to upgrade, due to some heavy core modifications I was forced to do for this project specifically, I don't mind making further code edits. Also, if it means anything, the Google map is the only K2 plugin I will be using in this project.

Please help this poor fellow once again, as you did so many times before :)

Hi all,

I'm using tags to display articles related to a certain subject (namely an artist as we're a music website), and would like to offer the ability to filter by catebory (reviews, interviews, videos, etc).

What shoud i do to do that?

I may not be hostile to modify the core query but unfortunately i don't know where it is located. I don't know k2 enough.

No, I don't use tags, user pages and K2's search listings.

Are we talking about these two files?

1.) components/com_k2/templates/default/item.php

2.) templates/jp-x2/html/com_k2/templates/default/item.php

This is for the item.php file.
You will have to adapt it for the category_item.php file as well and the tag.php, user.php and generic.php (if you are using tags, user pages and K2's search listings.)

Hello again
Seems that the slow query issue persist in my website.

The site went down again and the reply of siteground was that slow queries are the fault.
I am providing their result, the first 3 one appears in administrator/index.php?option=com_k2&view=items
the next three are generated from the tags module.

Could someone helps me at least fixing the query generated in backend?!

=== Databases Info ====================================================================
Database Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size

---

---

---

---

---

---

---

---

newsbomb_site 96 0 9 85 4021 9.982 390.2 MB


=== TOP 10 of 4021 (total) Slow Queries for the past 24 hours ==========

1. Executed 2h 52m 51s ago for 23.016417 sec on Database --> newsbomb_site
Date: 2016-09-13 05:54:28 Query_time: 23.016417 Rows_examined: 282137: Rows_sent 20 Lock_time: 0.000120
SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM site_k2_items as i LEFT JOIN site_k2_categories AS c ON c.id = i.catid LEFT JOIN site_viewlevels AS g ON g.id = i.access LEFT JOIN site_users AS u ON u.id = i.checked_out LEFT JOIN site_users AS v ON v.id = i.created_by LEFT JOIN site_users AS w ON w.id = i.modified_by WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 20;

---

2. Executed 3h 7m 44s ago for 18.48233 sec on Database --> newsbomb_site
Date: 2016-09-13 05:39:35 Query_time: 18.482330 Rows_examined: 282124: Rows_sent 20 Lock_time: 0.000138
SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM site_k2_items as i LEFT JOIN site_k2_categories AS c ON c.id = i.catid LEFT JOIN site_viewlevels AS g ON g.id = i.access LEFT JOIN site_users AS u ON u.id = i.checked_out LEFT JOIN site_users AS v ON v.id = i.created_by LEFT JOIN site_users AS w ON w.id = i.modified_by WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 20;

---

3. Executed 5h 1m 37s ago for 10.898614 sec on Database --> newsbomb_site
Date: 2016-09-13 03:45:42 Query_time: 10.898614 Rows_examined: 282036: Rows_sent 20 Lock_time: 0.000118
SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM site_k2_items as i LEFT JOIN site_k2_categories AS c ON c.id = i.catid LEFT JOIN site_viewlevels AS g ON g.id = i.access LEFT JOIN site_users AS u ON u.id = i.checked_out LEFT JOIN site_users AS v ON v.id = i.created_by LEFT JOIN site_users AS w ON w.id = i.modified_by WHERE i.trash=0 ORDER BY i.id DESC LIMIT 0, 20;

---

4. Executed 2h 53m 2s ago for 10.598193 sec on Database --> newsbomb_site
Date: 2016-09-13 05:54:17 Query_time: 10.598193 Rows_examined: 68722: Rows_sent 53571 Lock_time: 0.020998
SELECT tag.name, tag.id FROM site_k2_tags as tag LEFT JOIN site_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN (800,829,853,859,984,884,885,.......... LOTS OF IDS HERE ............,14203,47971) AND tag.published = 1;

---

5. Executed 2h 53m 2s ago for 10.588164 sec on Database --> newsbomb_site
Date: 2016-09-13 05:54:17 Query_time: 10.588164 Rows_examined: 68722: Rows_sent 53571 Lock_time: 0.018641
SELECT tag.name, tag.id FROM site_k2_tags as tag LEFT JOIN site_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN (800,829,853,859,984,884,885,.......... LOTS OF IDS HERE ............,14203,47971) AND tag.published = 1;

---

6. Executed 2h 53m 2s ago for 10.561908 sec on Database --> newsbomb_site
Date: 2016-09-13 05:54:17 Query_time: 10.561908 Rows_examined: 68722: Rows_sent 53571 Lock_time: 0.016645
SELECT tag.name, tag.id FROM site_k2_tags as tag LEFT JOIN site_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN (800,829,853,859,984,884,885,.......... LOTS OF IDS HERE ............,14203,47971) AND tag.published = 1;

---

It's a bit broader than that - but thank you, because I can definitely see how that would reduce some of the overhead.

For example, this is a site I built a while ago for a professional speaker management company, the example being a profile page for a speaker:

odemanagement.com/speakers/michael-mcqueen.html

Each speaker has their own category with their own name and a single article for their profile (with a bunch of extra fields for twitter, main video, PDF downloads and other widgets).

Each speaker category has subcategories for testimonials, topics and products (discover me), which get pulled into the page.

We use tagging extensively throughout the site, so couldn't use it here without it conflicting.

So I have a pattern of

Speaker Name (category)
|
–– Testimonials
–– Topics
–– Products

All the client has to do to is to create articles that are saved to the category (and make use of extra fields) and the profile pages are easily kept up to date with new content.

It's a technique I use a lot throughout my sites, but it necessitates creeping moduleitis, but with a split-content module that could target specifically-named subcategories it could be reduced to just one.

Hi, there.

I'm trying to render the K2 SIG Pro outside the K2 item, like in a category or in a module. But I have no luck with that.

Usually, when I use the command it only give me the ID of the gallery inside the tags that call the render.

I really want to make a page in my website so users can check the latest galleries in one place, without having to enter in each item to check the galleries.

Is there a way to that?

Maybe, this could be an interesting feature for a future release of SIG Pro.

Thanks in advance!

Are you talking about offering a:

K2 Item Module
Add item content (title, tags, and extra fields) in any module position throughout a K2 page.

If so, would it ship with the K2 package, so in essence, users would receive three K2 module types:

mod_k2_tools
mod_k2_content
mod_k2_item

Krikor, you are THE MAN!!!

Thank you soooooo muchhhh - I just tested it (title, tag, and extra field) and it works perfectly.

This is how I feel right now...