SQL Syntax Error

[joexp1]

Hello,

I just installed the directory script and I am receiving the following error when I try to view my directory. Has anybody encountered this? If so, what did I do wrong and how do I go about fixing this. I'm sure it's something simple. Here is the error:

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

Thank you in advance.

Regards,

[Greg]

Hi Joe

First of all, make sure that your MySQL version is 4.0 or above (click on the "SERVER INFO" button at the top menu of script admin panel).

[joexp1]

Hi Greg,

Thank you for replying.

I'm running version 3.23.58. It looks like I will have to upgrade.

Thank you for all your help Greg.

Regards,

[Greg]

You're welcome Joe. :) Good luck.