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 c.published = 1 and a.published = 1 GROUP BY a.id ORDER BY a.date_create' at line 1 SQL=SELECT adext.*, a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user FROM #__adsmanager_ads as a LEFT JOIN #__paidsystem_ads as adext ON a.id = adext.id INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE 1 AND c.id IN () AND c.published = 1 and a.published = 1 GROUP BY a.id ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 3

i debug that error after changing in code . But now i am getting a new error : the Root category doesn't contain any sub categories, let rootid empty or set rootid to a correct value .
The page url is : 198.1.95.93/~devlukeberarie/index.php?op...9&Itemid=187&lang=en

Now i am getting the following error again on category page :-
Page Url : 198.1.95.93/~devlukeberarie/index.php?op...9&Itemid=187&lang=en

Error :- 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 c.published = 1 and a.published = 1 GROUP BY a.id ORDER BY a.date_creat' at line 1 SQL=SELECT adext.*, a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user FROM #__adsmanager_ads as a LEFT JOIN #__paidsystem_ads as adext ON a.id = adext.id INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE 1 AND c.id IN () AND c.published = 1 and a.published = 1 GROUP BY a.id ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 3 .