«SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'parentheses not balanced' from regexp, query was: SELECT main_table.* FROM shippingrate AS main_table <…>»

[dmitrii-fediuk]

SELECT `main_table`.* 
FROM `shippingrate` AS `main_table` 
WHERE 
	(((`country` LIKE 'CH') OR (`country` = '0') OR (`country` = ''))) 
	AND (((`state` LIKE '') OR (`state` = '0') OR (`state` = ''))) 
	AND (((`city` LIKE 'Zürich') OR (`city` = ''))) 
	AND (`num_zip_from` <= 46 OR `zip_from` = "") 
	AND (`num_zip_to` >= 46 OR `zip_to` = "") 
	AND (((((`zip_from` REGEXP '^([0-9]+') OR (`zip_from` = ''))))) 
	AND (`price_from` <= 8.1) 
	AND (`price_to` >= 8.1) 
	AND (`weight_from` <= 0.02)
	AND (`weight_to` >= 0.02) 
	AND (`qty_from` <= 2) 
	AND (`qty_to` >= 2) 
	AND (((`shipping_type` = '139') OR (`shipping_type` = '') OR (`shipping_type` = '0'))) 
	AND (`method_id` IN(1)) 
ORDER BY num_zip_from DESC, num_zip_to DESC

It could be related to #40