PDA

View Full Version : You have an error in your SQL syntax


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

Dave Baker
01-28-2007, 04:11 PM
Hello Abul,
It's very difficult to specify the problem in your directory by mySql errors. Please create ticket www.esyndicat.com/support/desk/ with your ftp/database credentials and description of problem.