I'm using Joomla 2.5.24 & K2 2.6.8

I recently installed K2 and imported items from Joomla. Everything went well. However, recently when I try to view items in the back end, I am only able to see items in with no category selected in the filter. As soon as I filter to a category or subcategory the backend works but displays 0 items. I can only see items when I do not select a category.

It appears to show the correct Page Numbers (ie Page 1 of 4) as if the items were found, they're just not showing at all.

Happens in Chrome, FF and IE.

Any help would be appreciated.

Hello Paul,

Can you enable error reporting and paste any errors here?

Hi, thanks for your reply

Two errors found:


Warning: Invalid argument supplied for foreach() in /home/sstuwa/public_html/administrator/components/com_k2/views/items/view.html.php on line 77

Warning: Invalid argument supplied for foreach() in /home/sstuwa/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 118

@Paul Andrews

This indicates an SQL error. Enable system debugger to see the query that fails.

HI thanks for your support. This is what I see:

500 - An error has occurred.
JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name' at line 1 SQL=SELECT DISTINCT i.`id`,DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM sstuwa_k2_items as i LEFT JOIN sstuwa_k2_categories AS c ON c.id = i.catid LEFT JOIN sstuwa_viewlevels AS g ON g.id = i.access LEFT JOIN sstuwa_users AS u ON u.id = i.checked_out LEFT JOIN sstuwa_users AS v ON v.id = i.created_by LEFT JOIN sstuwa_users AS w ON w.id = i.modified_by LEFT JOIN sstuwa_k2_additional_categories AS ca ON ca.`itemID` = i.`id` WHERE i.trash=0 AND (i.catid IN (466,50,73,76,190,250,282,292,302,303,305,317,318,319,320,321,505) OR ca.`catid` IN (466,50,73,76,190,250,282,292,302,303,305,317,318,319,320,321,505)) ORDER BY i.id DESC LIMIT 0, 30

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /home/sstuwa/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/sstuwa/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/sstuwa/public_html/libraries/joomla/application/component/helper.php:348
4 require_once() /home/sstuwa/public_html/libraries/joomla/application/component/helper.php:380
5 JController->execute() /home/sstuwa/public_html/administrator/components/com_k2/k2.php:135
6 K2ControllerItems->display() /home/sstuwa/public_html/libraries/joomla/application/component/controller.php:761
7 K2Controller->display() /home/sstuwa/public_html/administrator/components/com_k2/controllers/items.php:21
8 JController->display() /home/sstuwa/public_html/administrator/components/com_k2/controllers/controller.php:32
9 K2ViewItems->display() /home/sstuwa/public_html/libraries/joomla/application/component/controller.php:722
10 K2ModelItems->getData() /home/sstuwa/public_html/administrator/components/com_k2/views/items/view.html.php:64
11 JDatabase->loadObjectList() /home/sstuwa/public_html/administrator/components/com_k2/models/items.php:128
12 JDatabaseMySQLi->execute() /home/sstuwa/public_html/libraries/joomla/database/database.php:1126
13 JError::raiseError() /home/sstuwa/public_html/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() /home/sstuwa/public_html/libraries/joomla/error/error.php:251

Have you modified any core K2 files? This query is not part of K2. Try to reinstall K2 ( don't uninstall first ). If that does not work search for any K2 related extensions installed.

All fixed.

I had previously tried reinstalling but no change.

I uninstalled Inceptive Multiple Categories then reinstalled K2 and then reinstalled Multiple Categories.

Must have been a bad install on that plugin.

Thank you very much for your help with this.

Make sure that you are using K2 Multiple Categories's latest version.
Also let the extension's developer know about this issue so might provide a solution.