SQL error when selecting article category

Support forum dedicated to free and advanced Joomla content presentation module with various layout options and data sources support.
GK User
Sat Mar 30, 2013 9:05 am
I get an SQL error when selecting a articles category exept by "uncategorized" and when i select them all...

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 'ORDER BY content.created DESC' at line 28 SQL=SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid FROM l8wid_content AS content LEFT JOIN l8wid_categories AS categories ON categories.id = content.catid LEFT JOIN l8wid_users AS users ON users.id = content.created_by LEFT JOIN l8wid_content_rating AS content_rating ON content_rating.content_id = content.id WHERE ORDER BY content.created DESC
User avatar
Senior Boarder

GK User
Sat Mar 30, 2013 9:14 am
Hi, I suggest:

1) to repair database with phpMyAdmin: http://kb.siteground.com/how_to_repair_ ... _database/
2) Go to Extension Manager -> Database [TAB] -> FIX BUTTON
User avatar
Platinum Boarder

GK User
Sat Mar 30, 2013 9:19 am
No, doesnt work....
User avatar
Senior Boarder

GK User
Sat Mar 30, 2013 10:29 am
Update your module to new/current version.
User avatar
Platinum Boarder

GK User
Sat Mar 30, 2013 2:21 pm
Allready did still nothing...
User avatar
Senior Boarder


cron