MySQL error in file: /engine/modules/show.short.php at line 69

Error Number: 3685

The Error returned was:
Illegal argument to a regular expression.

SQL query:

SELECT id, short_story, xfields, title, category, alt_name, news_read FROM dle_post LEFT JOIN dle_post_extras e ON (id=e.news_id) where category = '4' AND cities regexp '[[:<:]](918)[[:>:]]' AND approve AND allow_main=1 ORDER BY abs(REGEXP_SUBSTR(SUBSTRING_INDEX( SUBSTRING_INDEX( xfields, 'percentmin|', -1 ), '||', 1 ), '[0-9\.\,]+')) = 0,abs(REGEXP_SUBSTR(SUBSTRING_INDEX( SUBSTRING_INDEX( xfields, 'percentmin|', -1 ), '||', 1 ), '[0-9\.\,]+')) asc, sorting DESC, date+0 DESC LIMIT 0,200