JA K2 Filter - Issues with the itemlist.php file

saguaros

Thanks for the info.

K2 has not updated for PHP 8 and Joomla 4 for a long time so we could not update our JA K2 filter component either. Recently, K2 released a new version which supports PHP 8, we're aware of this and will check with dev team for update plan. For now, it's not ready for PHP 8 yet, pls switch to use PHP 7.x instead.

Regard

ssdev001

saguaros

Hey Saguaros, thanks for getting back to me.

Forgot to mention we are running Joomla 3.10.11 on the site. I see for K2, a little while back for another client on their site they couldn't save K2 articles (screen would go white) when running PHP 8.0. But then installed the K2 dev version and that fortunately resolved the error.

In this case though with the K2 filter module the hosting provider we are using for site has removed all PHP version prior to PHP 8.0, we can't run any PHP 7.x versions. Is there anything we can do in the meanwhile to try it resolved? The filter module is quite a core part of the client's site.

Thanks.

saguaros

Our team will test and update with new version of K2 first. I will update here when having news.

ssdev001

saguaros

Hey Saguaros, ok thanks.

vangogh

Hi, ssdev001

I just replaced some old files to the latest update (bugs fix and php8x compatible)
modules/mod_jak2filter/elements/template.php
components/com_jak2filter/models/itemlist.php
You kindly check again and response to us.

Regards,

ja-k2-filter.zip

18kB

ssdev001

vangogh

Thank you, I tried replacing those files with the new version. While I can now open the JA K2 filter component page in the backend, when I try open the module page I am getting the error:

0 implode(): Argument #2 ($array) must be of type ?array, string given
/modules/mod_jak2filter/elements/prek2extrafield.php:289

I also tried creating a new JA K2 module and I got the same error. Also tried reindexing just in case but didn't affect the error.

vangogh

Hi, ssdev001

You kindly re-install the latest mod-ja-k2filter. It will fix the issue.

Regards,

mod-jak2filter.zip

599kB

ssdev001

vangogh

Thanks, have re-installed the mod package. In the backend I can now access the module, however, on the frontend when a search / filter is done I am getting two different errors (and have tried doing the re-indexing in the backend component but didn't change anything).

If I try filter using one of the dropdown fields I get this error:

0 Attempt to modify property "query" on null

Call stack

Function Location

1 () JROOT/components/com_jak2filter/views/itemlist/view.html.php:383
2 JAK2FilterViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
3 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_jak2filter/controllers/controller.php:20
4 JAK2FilterController->display() JROOT/components/com_jak2filter/controllers/itemlist.php:51
5 JAK2FilterControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
6 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jak2filter/jak2filter.php:40
7 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
8 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
9 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
10 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
11 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225

12 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

If I try use the search field and enter some text to search with I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND a.value LIKE '%"alias":"location"%'' at line 5

Call stack

Function Location

1 () JROOT/libraries/joomla/database/driver/mysqli.php:668
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
3 JDatabaseDriver->loadResult() JROOT/components/com_jak2filter/models/itemlist.php:2175
4 JAKeywordSearch->DetectMultiLevelField() JROOT/components/com_jak2filter/models/itemlist.php:2154
5 JAKeywordSearch->build() JROOT/components/com_jak2filter/models/itemlist.php:1659
6 JAK2FilterModelItemlist->prepareSearch() JROOT/components/com_jak2filter/models/itemlist.php:244
7 JAK2FilterModelItemlist->getData() JROOT/components/com_jak2filter/views/itemlist/view.html.php:106
8 JAK2FilterViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_jak2filter/controllers/controller.php:20
10 JAK2FilterController->display() JROOT/components/com_jak2filter/controllers/itemlist.php:51
11 JAK2FilterControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
12 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jak2filter/jak2filter.php:40
13 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
14 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
15 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
16 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
17 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225

18 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

Thanks

vangogh

Hi, ssdev001
I am going to carefully debug by backing up your site and test on my local server.
So you kindly wait the solution.
Regards,

vangogh

Hi, ssdev001

After debugging, I figured out the issue and directly fixed for you. All files changed in a compressed file below.
You kindly check and response to us.

com-k2-filter.zip

23kB

Regards,

jakramer

I'm seeing the same issue with php8. Is the above zip file a general fix for all installations that I can safely use?

saguaros

jakramer You can backup your site first and give it a try.

jakramer

Yep, there's always that... good news, no exception on the front end. bad news, lost the filtering capability that we had and I'm getting the following error in the backend:

An error has occurred.
0 count(): Argument #1 ($value) must be of type Countable|array, null given

jakramer

The updated code seems to work with PHP 7.4.33 but not 8.0.28. The goal was to get it working with 8.0.28.

jakramer

Specifically, on the frontend, it displays "LOADING" which never completes.

saguaros

Could you share the credentials of your site such as: URL + super admin + FTP account and the URL of that page so we can check?