ForumJoin our community

if in the module TZ Categories Menu to change the category, then the module breaks web site

The Page You Are Looking for can’t Be Found
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 '9) GROUP BY a.id ORDER BY a.lft ASC' at line 8 SQL=SELECT a.*,tz.images,l.title AS language_title,ag.title AS access_level,ua.name AS author_name,(SELECT COUNT(*) FROM demo_content AS c WHERE c.catid = a.id) AS total FROM `demo_categories` AS a LEFT JOIN `demo_tz_portfolio_categories` AS tz ON tz.catid = a.id LEFT JOIN `demo_languages` AS l ON l.lang_code = a.language LEFT JOIN `demo_users` AS uc ON uc.id=a.checked_out LEFT JOIN `demo_viewlevels` AS ag ON ag.id = a.access LEFT JOIN `demo_users` AS ua ON ua.id = a.created_user_id WHERE a.extension = 'com_content' AND a.published = 1 AND a.id IN(,9) GROUP BY a.id ORDER BY a.lft ASC
Comment
There are no comments made yet.
pipp Accepted Answer Pending Moderation
  1. Wednesday, 24 May 2017
  2. -
  3. # 1
0
Votes
Undo
solved
Comment
There are no comments made yet.
Iva Accepted Answer Pending Moderation
  1. Wednesday, 24 May 2017
  2. -
  3. # 2
0
Votes
Undo
Hello,
Thanks for your feedback and so glad to hear that you have solved this problem.
If have any question related to our template, feel free contact us.

Thanks,
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!