I've installed the quick start installation package. It works wonderful.
I want modified a lot of content content the last days, but now I suddenly get the following notice:
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 er6xe_content AS content LEFT JOIN er6xe_categories AS categories ON categories.id = content.catid LEFT JOIN er6xe_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN er6xe_users AS users ON users.id = content.created_by LEFT JOIN er6xe_content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC
The beez3 and the protostar template are still working, 00AS2064 doesn't.
What should I do?
Kind regards
AS Templates
POSTED: 2014-10-05
Hello KAJAFITI,
We are sorry, it is not related to the template, try to run this query in your SQL admin and find the error, as well you can check your server log, maybe you will find some info.
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
I've installed the quick start installation package. It works wonderful.
I want modified a lot of content content the last days, but now I suddenly get the following notice:
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 er6xe_content AS content LEFT JOIN er6xe_categories AS categories ON categories.id = content.catid LEFT JOIN er6xe_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN er6xe_users AS users ON users.id = content.created_by LEFT JOIN er6xe_content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC
The beez3 and the protostar template are still working, 00AS2064 doesn't.
What should I do?
Kind regards
We are sorry, it is not related to the template, try to run this query in your SQL admin and find the error, as well you can check your server log, maybe you will find some info.
Regards, AS Team.