COMMUNITY FORUM

K2 pagination doesn't show (hint: it's related to Falang)

JoomlaWorks
Offline
Admin

5 years 3 months ago #174543 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

@Bouey Thanks for joining us. Really appreciate it.

This is actually the recommend MySQL/MariaDB way for paginated data. Instead of doing 2 queries for the same thing, we only run a one for everything and second one which basically grabs the count from the first one. Since this is highly tied to performance (as K2 is used in some very large projects), I cannot revert any changes.

Additionally, since I'm leaning towards decoupling third-party integrations from K2 (to make development more flexible to be honest), I'd like to explore the possibility of having some else support Falang in K2, as a plugin. If it's technically possible on your side, would you be interested in that?

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Pablo Torres LLamas
Offline
New Member

5 years 3 months ago #174552 by Pablo Torres LLamas

Replied by Pablo Torres LLamas on topic K2 pagination doesn't show (hint: it's related to Falang)

Using falang and having the same problem. I hope @Bouey can find a solution. Thank you.

Please Log in or Create an account to join the conversation.

Bouey
Offline
New Member

5 years 3 months ago #174553 by Bouey

Replied by Bouey on topic K2 pagination doesn't show (hint: it's related to Falang)

Yes i'm still on a solution.
@Fotis the SQL_CALC_FOUND_ROWS is a nice system but for performance a select count(*) is better

Se here some test:
www.percona.com/blog/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/

Stéphane

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 3 months ago #174555 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Stéphane, the link from Percona is very old. If you skim through the more recent comments, you'll see that users report different results.

And this is from the MySQL manual:
"If you are using SELECT SQL_CALC_FOUND_ROWS, MySQL must calculate how many rows are in the full result set. However, this is faster than running the query again without LIMIT, because the result set need not be sent to the client."

Since I happen to manage some of the highest traffic Joomla sites worldwide (dozens of millions of page views per month each), this change did wonders to performance. So it's been measured in production.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Vitaliy
Offline
New Member

5 years 3 months ago #174584 by Vitaliy

Replied by Vitaliy on topic K2 pagination doesn't show (hint: it's related to Falang)

Good day. The problem was solved by installing the old version of K2 2.9.0 on top of K2 2.10.2. And Yes, the problem is a conflict between the new version 2.10.2 and the faLang component.

Please Log in or Create an account to join the conversation.

Bouey
Offline
New Member

5 years 2 months ago - 5 years 2 months ago #174586 by Bouey

Replied by Bouey on topic K2 pagination doesn't show (hint: it's related to Falang)

Hi,

i have a solution but need a small change in k2 file components/com_k2/models/itemlist.php line 338

<?php

if (count($rows)) {
    //sbou
    $falang_driver = Joomla\CMS\Plugin\PluginHelper::getPlugin('system', 'falangdriver');
    if (!empty($falang_driver)) {
        $db->setQuery($query, $limitstart, $limit);
        $db->loadResult(false);
        $db->setQuery('SELECT FOUND_ROWS();');
        $this->getTotal = $db->loadResult(false);

        return $rows;
    }
    //sbou

    $db->setQuery('SELECT FOUND_ROWS();');
    $this->getTotal = $db->loadResult();
}

if the falang driver is enabled the query is resend without asking for translation (probably use mysql cache) and the getTotal is set correctly

Last edit: 5 years 2 months ago by JoomlaWorks.

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 2 months ago - 5 years 2 months ago #174593 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Stéphane, according to your site, Falang supports both Joomla 2.5 and 3.x. So I changed "Joomla\CMS\Plugin\PluginHelper" to "JPluginHelper" just in case.

Your changes have been merged: github.com/getk2/k2/commit/2127cf6f2ef8ad9a668ad2f7382f8c393d9fcdc8

By the way, since I had not committed the original code for either Joomfish or Falang myself, searching the K2's codebase for Falang I only found references in the itemlist.php model (the file you also edited). Have you had a look overall?

===

For anyone who wishes to try the updated version, please install K2 v2.10.3 (dev) from: getk2.org/downloads/?f=K2_Development_Release.zip

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Last edit: 5 years 2 months ago by JoomlaWorks.

Please Log in or Create an account to join the conversation.

Bouey
Offline
New Member

5 years 2 months ago #174596 by Bouey

Replied by Bouey on topic K2 pagination doesn't show (hint: it's related to Falang)

Hi Fotis, it's seem only this change is enought .

i will look deeper monday.

Stéphane

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 2 months ago #174597 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Thank you Stéphane.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Geraldo de Oliveira
Offline
New Member

5 years 1 month ago #174991 by Geraldo de Oliveira

Replied by Geraldo de Oliveira on topic K2 pagination doesn't show (hint: it's related to Falang)

Hi Stéphane,
Any news about this? I'm still not seeing the pagination once the plugin is enabled.
Thanks...

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 1 month ago #174992 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Alberto you need to use K2 v2.10.3 (dev) for now: getk2.org/downloads/?f=K2_Development_Release.zip

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Geraldo de Oliveira
Offline
New Member

5 years 1 month ago #175051 by Geraldo de Oliveira

Replied by Geraldo de Oliveira on topic K2 pagination doesn't show (hint: it's related to Falang)

I've tried to install the dev version but the item layout page breaks :(
Anyway, I'll wait for the stable 10.3 to upgrade. Now it's kinda of an emergency.

EDIT: Even with the fix from @Bouey it doesn't work so I've figured it out it's due to the K2 Multi Categories override located at /plugins/system/k2multiplecategories/overrides/site/components/com_k2/models/itemlist.php
I'll contact the developer once again to check this thread.

Thanks again.

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 1 month ago #175052 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Is that the Web357 plugin?

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Geraldo de Oliveira
Offline
New Member

5 years 1 month ago #175067 by Geraldo de Oliveira

Replied by Geraldo de Oliveira on topic K2 pagination doesn't show (hint: it's related to Falang)

Yes, it is Fotis

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 1 month ago #175078 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

You may have to inform Web357 then on a possible fix/tweak for their K2 plugin. If so, ask them to test against v2.10.3 (dev) which can be downloaded from: getk2.org/downloads/?f=K2_Development_Release.zip

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Fundceri
Offline
New Member

5 years 2 days ago #175441 by Fundceri

Replied by Fundceri on topic K2 pagination doesn't show (hint: it's related to Falang)

Hello,
same problem here with Falang.
Couldn't make work the patch given by the developer. Is there any new about him?

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

5 years 2 days ago #175449 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

@Fundceri Aren't you using K2 v2.10.3 (dev) already? If not, get it from: getk2.org/downloads/?f=K2_Development_Release.zip

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Bibliosalut
Offline
New Member

4 years 10 months ago #176206 by Bibliosalut

Replied by Bibliosalut on topic K2 pagination doesn't show (hint: it's related to Falang)

Hello, I have the same problem. I spoke to the web357 developers and they told me that it was a problem with the falang component, I spoke to the falang developer and he redirected me to this page and I have been looking at the answers and it seems that it can be fixed if you install K2 v2.10.3 (dev). I checked what version I have and it was the same but I reinstalled it in case it was fixed but it still doesn't work and I would like to know what the problem is.

A Greeting

Please Log in or Create an account to join the conversation.

JoomlaWorks
Offline
Admin

4 years 10 months ago #176215 by JoomlaWorks

Replied by JoomlaWorks on topic K2 pagination doesn't show (hint: it's related to Falang)

Try getk2.org/downloads/?f=K2_Development_Release.zip which is now K2 v2.10.4 (dev).

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

Bibliosalut
Offline
New Member

4 years 10 months ago #176225 by Bibliosalut

Replied by Bibliosalut on topic K2 pagination doesn't show (hint: it's related to Falang)

Hello.
I have already installed K2 v2.10.4 (dev) and there is no change, it looks exactly the same. I tried to change the protostar template and it doesn't work either. The only way to set the page is to disable the falang plugin but by doing that you won't be able to translate the web anymore.

A Greeting

Please Log in or Create an account to join the conversation.