Searchanise and Filter Box


I’m having an issue with Searchanise and the Filter Box causing a database mysql join crash

Using 3.04 ultimate edition, if i turn searchanise off it works correctly,

Anyone else experience the same?

[color=#000000][font=Courier]Database error:[/font][/color][color=#333333][font=Arial, Tahoma, Helvetica, sans-serif][size=3] 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 ‘BY dispatch’ at line 1 [/size][/font][/color]b[/b]

[color=#000000][font=Courier]Invalid query:[/font][/color][color=#333333][font=Arial, Tahoma, Helvetica, sans-serif][size=3] SELECT dispatch, status, snapping_id FROM cscart_bm_locations INNER JOIN cscart_bm_containers ON cscart_bm_containers.location_id = cscart_bm_locations.location_id INNER JOIN cscart_bm_grids ON cscart_bm_containers.container_id = cscart_bm_grids.container_id INNER JOIN cscart_bm_snapping ON cscart_bm_grids.grid_id = cscart_bm_snapping.grid_id INNER JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id WHERE cscart_bm_blocks.type = ‘product_filters’ AND cscart_bm_locations.company_id = 2GROUP BY dispatch[/size][/font][/color]

[color=#333333][font=Arial, Tahoma, Helvetica, sans-serif][size=3]Stephen[/size][/font][/color]

Hello Stephen,

Thank you for your message.

I am sorry to hear that you have experienced this issue. It seems that it is caused by a well-known bug in the current CS-Cart version. Please replace the following part of code:

. "WHERE ?:bm_blocks.type = ?s ?p"

with this one:

. "WHERE ?:bm_blocks.type = ?s ?p "

in the block.php file located in the core/classes/bm directory of your CS-Cart installation and let me know the result.

Thank you.

Pavel Zyukin

CS-Cart Support team