Any time, a logged-in user navigates to the main page of our site, where the JaNewsFeatured module is active, we get an 1064 database error page (screenshoot attached)
If the JA News Featured module is disabled, than there is no bug and everything works fine.
A similar error was reported in the K2 forum here: https://www.joomlaworks.net/forum/k2-en/46431-error-1064-database-error-in-k2-table
The bug in the mod_janews_featured/helpers/adapter/k2.php file was already fixed by Joomlart.
In the K2.php file there are the row that are being referred to, but we can not fix the error:
93 $query = "SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.name as cattitle, c.params AS categoryparams";
94 $query .= "\n FROM #k2_items as i LEFT JOIN #k2_categories c ON c.id = i.catid";
95 $query .= "\n WHERE i.published = 1 AND i.featured=1 AND i.access <= {$aid} AND i.trash = 0 AND c.published = 1 AND c.access <= {$aid} AND c.trash = 0";
Since we has not modified any files except css, it seems to be a bug. Please, have a look at it.
Thank you!