I need help on this error. I have done everything I can and researched the forum with no help.

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 'AND i.language IN ('en-GB','*') ORDER BY i.id DESC) as sub WHERE sub.id = LIMIT' at line 1 SQL=SELECT position FROM (SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, @num := @num + 1 AS position FROM #__k2_items i JOIN (SELECT @num := 0) n LEFT JOIN #__k2_categories as c ON c.id = i.catid WHERE i.published=1 AND i.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2016-04-06 14:39:32' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2016-04-06 14:39:32' ) AND i.access IN(1,1,2,3) AND c.published=1 AND c.trash = 0 AND c.access IN(1,1,2,3) AND i.catid = c.id AND i.catid = AND i.language IN ('en-GB','*') ORDER BY i.id DESC) as sub WHERE sub.id = LIMIT 1

Hello Jobe,

Where was this error raised?
Is it a module or a component view?

It happens when I hit the 'new item' button to create a new article. At the moment, a list of all the articles in the items home page on K2 have all disappeared. It happened when I upgraded.

You mean Joomla! to 3.5 or K2 to 2.7?
If my memory serves me right, you are using multiple 3rd party K2 components. Are these compatible with K2 2,7?

No, it happens when I want to create a new K2 Article. Only K2 application no 3rd party integrations. It happens only when I need to create a new K2 article.

Is this the site with the nuMuzik template?

Yes it is

It happens in component view

Can you temporarily upgrade all K2 related modules.
I recall you where using some sliders and similar content modules.