I've created a new K2 category and was going to use it on a News Show Pro GK5 module, when I saved it I got the following error and I can't see my site. I disable the module Show Pro GK5 module, I've deleted the category but I still have this error:
0
SQL=SELECT content.id AS ID, cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count FROM mkynr_k2_items AS content LEFT JOIN mkynr_k2_categories AS cats ON cats.id = content.catid LEFT JOIN mkynr_users AS users ON users.id = content.created_by LEFT JOIN mkynr_k2_rating AS content_rating ON content.id = content_rating.itemID WHERE ORDER BY content.created DESC

Any help is much appreciated.

Miry

I've forgot to say that I am using Joomla 3.1.5 and K2 2.6.8. I had Additional Categories installed as well but I disabled it.

Hi. Turn on error reporting and system debugging to see where the error is coming from. However this query is not part of K2 so you need to find the extension that is generating it and update/disable/fix it. Also keep in mind that you need to update Joomla! installation to 3.2.2. Joomla! 3.1 is not supported any more by the Joomla! team.

Same problem here!! You can see it here www.4qk-creations.com/en in every category i get error 0 and also I cannot login to my control panel because i get this error:

SQL=SELECT i.*, v.name AS author, COUNT(comments.id) AS numOfComments FROM sl914_k2_items as i LEFT JOIN sl914_k2_categories AS c ON c.id = i.catid LEFT JOIN sl914_users AS v ON v.id = i.created_by RIGHT JOIN sl914_k2_comments comments ON comments.itemID = i.id WHERE i.trash = 0 AND c.trash = 0 GROUP BY i.id ORDER BY numOfComments DESC LIMIT 0, 10

PLEASE HELP!!

Hi Dimitris,
seems something feet "Comments" !

Try disable comments for categories or for the full website to see if it's ok, I've got this error fiew days and I remove all the comment stuff (I don't have this features on my site so ;) ) And the error goes !

Hey there!

Just tried that.. I disabled the comments for the whole website but still nothing :S

This is so weird!! Also if i try to access comments from the k2 panel I also get a similar error:

SQL=SELECT COUNT(*) FROM sl914_k2_comments AS c LEFT JOIN sl914_k2_items AS i ON c.itemID=i.id WHERE c.id>0 AND c.published=1

EDIT: I just found out that sl914_k2_comments is missing from my database!!! I will try it reimport it from an old one and see what happens... brb


EDIT 2: Yup!! THAT DIT IT!! although its pretty weird that a whole database table just disappeared... Anyway hope that helps everyone else :)