sql problem

[davyRoegiers]

Hi, I just installed esyndicate 1.5
And whenever I want to browse the categories i get the following error:

SELECT COUNT(`id`) FROM `es_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 `es_categ' at line 1

the same error occurs when I click on directory home.
I reinstalled several times, tried with and without categories in my database.
My host is running mysql 3.23.58

Does anyone now, what it is that could cause this problem?
thx.

[Greg]

Hi, I just installed esyndicate 1.5
And whenever I want to browse the categories i get the following error:

SELECT COUNT(`id`) FROM `es_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 `es_categ' at line 1

the same error occurs when I click on directory home.
I reinstalled several times, tried with and without categories in my database.
My host is running mysql 3.23.58

Does anyone now, what it is that could cause this problem?
thx.

You need to have "MySQL 4.0 or above" http://www.esyndicat.com/product.html

[davyRoegiers]

Thx, I must have been sleeping with my eyes open. I tried it on another host, with a more recent version of mysql and indeed it runs very smooth there.