How to solve this error ?

[iulian00]

I have installed Esyndicat and now i have a problem and i don't know how to solve it .

This is what i get when i try to access my webdirectory :

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/itareaor/public_html/webdirectory/classes/DirDb.php on line 113
SELECT t4.*, COUNT(DISTINCTROW t3.`id`) num_links FROM `iuli_related` t1 LEFT JOIN `iuli_flat_structure` t2 ON t1.`id_related` = t2.`id_parent` LEFT JOIN `iuli_links` t3 ON t2.`id_category` = t3.`id_category` AND t3.`status` = 'active' LEFT JOIN `iuli_categories` t4 ON t1.`id_related` = t4.`id` WHERE t1.`id_category` = '0' AND t4.`status` = 'active' GROUP BY t1.`id` ORDER BY `order`
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

webdirectory.itarea.org is my webdirectory's address.

[Vasily B.]

Hi,
You should contact your hosting and ask them to add the following line in their mysql configuration file. Usually it is called my.cnf

SET SQL_BIG_SELECTS=1

[iulian00]

I contacted them and they told me that they can't do that. Is there any other way that i can fix this problem?

[Vasily B.]

Yes, you can change your hosting then I do not see any reasons why not to increase a number of examined rows in mysql configuration