I installed the template using quickstart today and the site was working fine until i started editing articles and menu items. After a few changes my site diplays this error.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 xhopy_content AS content LEFT JOIN xhopy_categories AS categories ON categories.id = content.catid LEFT JOIN xhopy_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN xhopy_users AS users ON users.id = content.created_by LEFT JOIN xhopy_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: 2014-12-08
Hello GEORGEP83,
We are sorry, but this problem is not related to the template, it seems you deleted some category in your admin panel or changed category name using special characters.
Regards, AS Team.
georgep83
POSTED: 2015-01-15
Hello,
I was trying to edit the breadcrumbs-row height and during my code edits it seems i edited something wrong with result, whenever i publish the breadcrumbs plugin the content is not displayed.
Is there a way to initialize the breadcrumbs module to default ?
AS Templates
POSTED: 2015-01-15
Hello GEORGEP83,
Yes, you can unpublish the old one and create a new, all module settings you can preview here:
http://www.astemplates.com/joomla-template-documentation/315-202-modules-configuration#breadcrumbs
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 installed the template using quickstart today and the site was working fine until i started editing articles and menu items. After a few changes my site diplays this error.
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 xhopy_content AS content LEFT JOIN xhopy_categories AS categories ON categories.id = content.catid LEFT JOIN xhopy_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN xhopy_users AS users ON users.id = content.created_by LEFT JOIN xhopy_content_rating AS content_rating ON content_rating.content_id = content.id WHERE AND categories.published = 1 ORDER BY content.created DESC
We are sorry, but this problem is not related to the template, it seems you deleted some category in your admin panel or changed category name using special characters.
Regards, AS Team.
I was trying to edit the breadcrumbs-row height and during my code edits it seems i edited something wrong with result, whenever i publish the breadcrumbs plugin the content is not displayed.
Is there a way to initialize the breadcrumbs module to default ?
Yes, you can unpublish the old one and create a new, all module settings you can preview here:
http://www.astemplates.com/joomla-template-documentation/315-202-modules-configuration#breadcrumbs
Regards, AS Team.