Bug fixed for compatiblity with MySQL 4. If you are using a version of MySQL prior to version 5 you need this correction since in SQL queries version 4 processes NOT before IN rather than IN before NOT as in version 5 under which this contribution was tested. The solution is simply to put parenthesis around the IN operators wherever used in a query to make sure they are processed first regardless of the version of MySQL.

Complete corrected instructions attached. If you've already installed version 1.3 the only changes are that the SQL queries are changed from

and (not p2c.categories_id in (" . implode(',', $hiddencats) . "))

to

and (not (p2c.categories_id in (" . implode(',', $hiddencats) . ")))

in eleven files (one place each in ten files and twice in index.php).

More...