[No bug]extra opening in includes\modules\pages\advanced_search_result\header_php.php

[Design75]

In includes\modules\pages\advanced_search_result\header_php.php on line245 there is an opening bracket in the code, but it isn't closed.

$where_str = " WHERE (p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id "; 

It doesn't give any errors, at least not experienced by me, but I found it during troubleshooting some custom code.
This bracket has been there at least since ZC 1.38, but could be on earlier versions to.
My guess is it is not necessary to use the bracket and it could be removed from the code.

[Ajeh]

I believe if you look further in the code you will see how the $where_str is still being built and the lines of:

    $where_str .= ")";

[Design75]

You're right. Soooo many bracket's. Imust have counted the opening and closing brackets a dozen times and still miss one.

[Ajeh]

Not a problem ... that can be a confusing file in there ...