Hello,

I have an issue with K2 Items and Categories not displaying in Firefox or Safari. I am using:
Clean install of Joomla 2.5.6
K2: 2.5.7


I have tried the following to correct the issue but they have not worked:

1. Checked tables in
2. Cleared Joomla's cache
3. Cleared Firefox cache
4. Repaired database tables from within Joomla
5. Repaired tables from MyPHP
6. Tried disabling 'Smart Search - K2' in the plugins

The only way I can get my Items and Categories to show is if I restart Firefox, but this only works for a short time. I believe this is a bug and needs to be fixed. Has anyone got any ideas on how to fix this up?

I use K2 for all of my websites so this is pretty important for me.

Many thanks,
Neil.

Okay, this is always the way. I have found an answer to this issue as soon as I posted my issue :)

I found the original answer here: code.google.com/p/getk2/issues/detail?id=149

In short it appears that there is an issue with the K2 language files. I did notice that this issue only started to happen after I had installed AceShop so who knows - I'm not a PHP expert. That said the following solution works for me.

Correcting the Item display issue
Open
administrator/components/com_k2/models/items.php

Find:
$query .= " AND i.language = ".$db->Quote($language);

Replace with:
//$query .= " AND i.language = ".$db->Quote($language);

Correcting the Category display issue
Open
administrator/components/com_k2/models/categories.php

Find:
$query .= " AND c.language = ".$db->Quote($language);

Replace with:
//$query .= " AND c.language = ".$db->Quote($language);

Once you have made the changes to the files above and replaced them back on your server you should be able to see the Items and Category listings in your K2 Dashboard.

Thanks,
Neil.