Abul Kashem
01-28-2007, 03:50 PM
Hi
I have recently updated one of my directories and change host .
When I log in admin area and click browse categories I can see the following error.
Error: 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 'ORDER BY t1.`title`)' at line 1
(SELECT t2.`id_link`, t1.`id`, t1.`title` FROM `dir_categories` t1 LEFT JOIN `dir_link_categories` t2 ON t1.`id` = t2.`id_category` WHERE `id_link` = ORDER BY t1.`title`)
Would you please guide me how can I solve this problem
thanks in advance
I have recently updated one of my directories and change host .
When I log in admin area and click browse categories I can see the following error.
Error: 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 'ORDER BY t1.`title`)' at line 1
(SELECT t2.`id_link`, t1.`id`, t1.`title` FROM `dir_categories` t1 LEFT JOIN `dir_link_categories` t2 ON t1.`id` = t2.`id_category` WHERE `id_link` = ORDER BY t1.`title`)
Would you please guide me how can I solve this problem
thanks in advance