By Matthew Miller on Friday, 12 December 2014
Posted in Technical Issues
Replies 1
Likes 0
Views 1K
Votes 0
While trying to debug another issue on my website, I turned on debugging in Joomla, which I had never done before.

To my surprise, it prints out all MySQL queries and lists how many duplicates there are. I was astonished to see the same query running 19 times on each page load and the query was coming from the Komento code.

The query is:
SELECT COUNT('1') AS `total`
FROM `jos3_komento_comments`
WHERE `published` = '1';

I wasn't able to fine much else online with regards to this issue other than this one page:
https://code.google.com/p/getk2/issues/detail?id=540

Has this issue been investigated? It's certainly adding a lot of unnecessary overhead, isn't it?
Hello Matthew,

May I know where did you get this sql error? Perhaps, you can provide us your backend and FTP so we can have a better look here.
·
Friday, 12 December 2014 10:17
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post