Hi,
i have 1064 error with K2 2.6.9 and Joomla 3.4.4 and MySQL 5.1 , just after adding an item in K2 :

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 'DESC LIMIT 0,9' AT LINE 20 SQL=SELECT CONTENT.ID AS ID FROM Y3ES2_K2_ITEMS AS CONTENT WHERE CONTENT.PUBLISHED = 1 AND CONTENT.TRASH = 0 AND CONTENT.ACCESS IN (1,1) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2015-10-05 17:53:04' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-10-05 17:53:04' ) AND ( CONTENT.CATID = 4 ) ORDER BY CONTENT. DESC LIMIT 0,9;

read articles about ké errors in user page, bur don't know wich file in my case to modify ...

it happens after duplicating an item.

updated to dev release 2.7.0 trouble is the same.
I delete item :pb is the same
i create another item : pb is the same
i create another category : pb is the same

when i execute my request on phpMyadmin, it makes the same error.
it's the end " ORDER BY CONTENT. DESC LIMIT 0,9 " that hangs at the end of request... it misses a column !!!

it could be : ORDER BY CONTENT.CREATED DESC LIMIT 0,9;

please tell my colum name to add and wich file to modify please .

Hi,

This query is not part of K2. Look for any K2 related extensions and disable them one by one until you find which one is causing this.

It's News Show Pro GK5 that hangs the site !

Why after editing an item in k2 it broke this ??

Resolving :

0) Install new current version of NSP GK5 (re-install)
1) Open module in edit mode
2) Click Refresh button in your browser
3) Change data source to another from list
4) Change order of showing items
5) Save changes - check on front page
6) If okey, change data source back to option which you have at the beginning

Thanks for sharing.