Help! getting a error in your SQL syntax near

[garpman]

:sos:
Hello , I installed and everything said it was a-ok, the admin section works fine, but when I try to view my page, I get this error at top:

SELECT COUNT(`id`) FROM `dir_links` WHERE `id_category` = '0'
You have an error in your SQL syntax near '(SELECT t1.*, COUNT(DISTINCTROW t3.`id`) num_links, '0' `crossed` FROM `dir_cate' at line 1

Thanks in advance for your help:)

[Greg]

Check if your MySQL version is 4.0 or above. Here is a one of the ways: login to your admin panel, and click "SERVER INFO" link at the top of the page.

[garpman]

Thx having my server look into it now, it is a new server for me and they are using Plesk which I am unfamilar with and at this point dun like very much, I will keep you posted, once they get back to me:)

[Vincent Wright]

Definitely, you use an old version of MySQL (I suspect it is MySQL 3.23.58 while eSyndiCat requires 4.0 or above).