Hi - getting this error message from index page on
allwebs,com.au. Any ideas?
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 categories.published = 1 ORDER BY content.created DESC' at line 28 SQL=SELECT categories.title AS cat, content.id AS ID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, categories.id AS CID FROM #__content AS content LEFT JOIN #__categories AS categories ON categories.id = content.catid LEFT JOIN #__content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN #__users AS users ON users.id = content.created_by LEFT JOIN #__content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC
AS Templates
POSTED: 2016-08-26
Hello EGDOTCOM,
Try to disable/unpublish one by one all published modules on your front-page, including all articles. Also you can try to repair your data base tables.
Get an access to all 94 items designed and developed by AS Designing team plus all the future items
which will be released over the course of your club subscription.
Price starting from $59.00
allwebs,com.au. Any ideas?
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 categories.published = 1 ORDER BY content.created DESC' at line 28 SQL=SELECT categories.title AS cat, content.id AS ID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, categories.id AS CID FROM #__content AS content LEFT JOIN #__categories AS categories ON categories.id = content.catid LEFT JOIN #__content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN #__users AS users ON users.id = content.created_by LEFT JOIN #__content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC
Try to disable/unpublish one by one all published modules on your front-page, including all articles. Also you can try to repair your data base tables.
Regards, AS Team.
Appreciated.