Hello, I had a section and some records in it, and when I deleted it I got a SQL error in my home page.
Error displaying the error page: 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 c.published = 1 AND c.level <= 2 AND c.lft BETWEEN AND ORDER BY c.lft A' at line 3 SQL=SELECT c.*, CONCAT(repeat('-- ', (c.level - 1)), c.title) as opt ,(SELECT count(id) FROM #__js_res_categories WHERE parent_id = c.id) as childs_num FROM #__js_res_categories AS c WHERE c.access IN (1,1,2,3,6) AND c.section_id = AND c.published = 1 AND c.level <= 2 AND c.lft BETWEEN AND ORDER BY c.lft ASC
Also When I delete a section all the records remains. I know I can delete them only from frontend so after section delete i can't do that because I can't reach them?
Hello, I had a section and some records in it, and when I deleted it I got a SQL error in my home page.
Error displaying the error page: 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 c.published = 1 AND c.level <= 2 AND c.lft BETWEEN AND ORDER BY c.lft A' at line 3 SQL=SELECT c.*, CONCAT(repeat('-- ', (c.level - 1)), c.title) as opt ,(SELECT count(id) FROM #__js_res_categories WHERE parent_id = c.id) as childs_num FROM #__js_res_categories AS c WHERE c.access IN (1,1,2,3,6) AND c.section_id = AND c.published = 1 AND c.level <= 2 AND c.lft BETWEEN AND ORDER BY c.lft ASC
Also When I delete a section all the records remains. I know I can delete them only from frontend so after section delete i can't do that because I can't reach them?