Hi,

We have developed a website featuring real estate, tourism, education and business services including some news portal stuffs. Our main news tool is of course K2 since it is the only CCK extension that fits our needs and also that have all required features.

Our current website configuration:

Joomla 1.5.25 (We cannot move to Joomla 2.5 since we are using some other component that are not yet compatible with Joomla 2.5).
K2 2.5.5
Jomsocial 2.4.3 etc.

The website was developed with an older version of K2, that is, K2 2.5.4 but after we update to the new version of k2 2.5.5, we start having some issue with the website, not such big issue but some page load stuffs and while browsing the web, we saw some forum that advised us to run Joomla in debug mode to see what might be the issue and when we did so, our home page just disappear with an error 500 with the following detailed error:

JDatabaseMySQL::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 ') GROUP BY comments.itemID' at line 11 SQL=SELECT content.id AS id, COUNT(comments.itemID) AS count FROM xxxx_k2_items AS content LEFT JOIN xxxx_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;

We have replaced the default commenting system of K2 with the JComments plugin plg_k2jcomments_v1.1.

The xxxx replace our current website database prefix, we remove it since it might be of security concern, our team is not composed of experienced developer and we are even quite unaware about database stuffs and php issue and we sincerely hope that we might get some help from the community to help us to solve this issue.

Our website is already productive, therefore, we would like to sort out this issue as soon as possible, therefore, please, someone, help us with it.

The site looks good, like it is based on world news template. Can you provide a link to the page that gives an error?

I too have the same problem please kindly help me out to resolve this