«SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'repetition-operator operand invalid' from regexp <…>» at vendor/magento/framework/Webapi/ErrorProcessor.php:208

[dmitrii-fediuk]

query was:

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 '') OR (`city` = '')))
	AND (`num_zip_from` <= 8247 OR `zip_from` = "")
	AND (`num_zip_to` >= 8247 OR `zip_to` = "")
	AND (((((`zip_from` REGEXP '^*[0-9]+') OR (`zip_from` = '')))))
	AND (`price_from` <= 24.95)
	AND (`price_to` >= 24.95)
	AND (`weight_from` <= 0.27)
	AND (`weight_to` >= 0.27)
	AND (`qty_from` <= 6)
	AND (`qty_to` >= 6)
	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

[dmitrii-fediuk]

I have implemented a logging in vendor/magento/framework/Webapi/ErrorProcessor.php.