SQL Error

[RandallFlagg]

I upgraded from 9.8 to 9.9.

Now I notice that when I go to a category I get in the about pligg and in the top of the page this 2 warnings.

Warning: 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 'OR `link_category` = OR `link_category` = )' at line 1 in /home/flashmag/public_html/ohad/dvartora/he/libs/db.php on line 233

Warning: 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 'OR `link_category` = OR `link_category` = ) ORDER BY link_date DESC, link_id' at line 1 in /home/flashmag/public_html/ohad/dvartora/he/libs/db.php on line 233

any suggestions?

[manya1011]

Originally Posted by RandallFlagg

I upgraded from 9.8 to 9.9.

Now I notice that when I go to a category I get in the about pligg and in the top of the page this 2 warnings.

Warning: 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 'OR `link_category` = OR `link_category` = )' at line 1 in /home/flashmag/public_html/ohad/dvartora/he/libs/db.php on line 233

Warning: 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 'OR `link_category` = OR `link_category` = ) ORDER BY link_date DESC, link_id' at line 1 in /home/flashmag/public_html/ohad/dvartora/he/libs/db.php on line 233

any suggestions?

go to SVN and get the updated libs.dbtree.php

and it should be fixed