Hi,
We've been successfully using the filter component on a website for a few months now but the server was recently upgraded to MySQL 8 which has caused an issue with the filter to stop working. The guy who looks after our server investigated and said:
SELECT DISTINCT i., CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM #k2_items as i RIGHT JOIN #k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1,4,6) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,4,6) AND c.trash = 0 AND ( i.publish_up = ‘0000-00-00 00:00:00’ OR i.publish_up <= ‘2021-04-13 10:40:10’ ) AND ( i.publish_down = ‘0000-00-00 00:00:00’ OR i.publish_down >= ‘2021-04-13 10:40:10’ ) AND i.catid IN (224) AND (i.extra_fields REGEXP ‘{\“id\“:\“14\“,\“value\“:[{]\“26\“’) ORDER BY i.title ASC
that regex is invalid
We had a dev environment running MySQL 5.7 and the filter worked fine there but when we upgraded it to MySQL 8 as part of the test process, it then began producing the same error. Would you please be able to provide a patch for this so that it can continue working within MySQL 8?
Thanks,
Dave