Bug in filter module?

[JWB +]

Notice: Query failed: 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 ') ORDER BY rand() LIMIT 5' at line 1 SQL: SELECT id, title, price FROM class_listings WHERE display = 'Y' AND expiration > NOW() AND featured = 'Y' AND id IN () ORDER BY rand() LIMIT 5 in /home/***/public_html/includes/classes/database/mysql.php on line 144

I think there is some thing wrong with the home.tpl

It seems that the error comes when you filter a state - from where there exists no listings. If I choose a filter where there is a listing the error disappears.

The error also disappears when I deactivate the filter module in the admin panel - or as a user in the menu.

[seymourjames +]

An official solution will be posted here.

I know John sent you a fix but it is not working for me on our demo site whereas the unfixed version does seem to work fine. We will get to the bottom of it.

[seymourjames +]

A fix is now available. Open modules/custom_plugins/plugins/function.css_listings_horizontal.php

Replace:

PHP Code:

unset($row);
$results->freeResult();
$lFilter = ' AND id IN (' . implode(',', $pIds) . ') '; 


with

PHP Code:

unset($row);
$results->freeResult();
if (empty($pIds)) {
    return '<div class="alert">' . MOD_LANG_NO_LISTINGS . '</div>';
}
$lFilter = ' AND id IN (' . implode(',', $pIds) . ') '; 


[JWB +]

Thank you. I can confirm the fix fixes the issue... :-)