XAMPP - MySql - This version of PCRE is compiled without UTF support at offset 0

mysql regex macos xampp pcre
ilSavo picture ilSavo · Mar 4, 2016 · Viewed 15.4k times · Source

I was trying to install a wordpress website on my computer (it's a Mac 10.11) but I got this error:

"This version of PCRE is compled without PCRE support at offset 0 from regexp"

And this problem is connected with this query:

DELETE FROM wp_options WHERE option_name REGEXP '^rss_[0-9a-f]{32}(_ts)?$'

I've already searched on Google about it, and even here, but everything I found didn't help me solving this problem. I also tried to reinstall XAMPP but everything it's still the same. And I've got the same problem even if I try to do a query containing a REGEXP from my phpMyAdmin panel.
A lot of solutions talks about recompiling apache or somthing similar, by using the compile command.

Can anybody help me with this problem?
Thanks in advance

Answer

azy777 picture azy777 · Nov 2, 2016

Faced this problem while setting up a php - mysql project with XAMPP. This worked for me.

Download PCRE from

ftp://ftp.csx.cam.ac.uk/pub/software/programming/pcre/

I downloaded ftp://ftp.csx.cam.ac.uk/pub/software/programming/pcre/pcre-8.38.zip

(If ftp does not work , use https://sourceforge.net/projects/pcre/files/pcre/8.40/ )

Extract the contents into a folder.

open terminal , cd to the extracted folder.

Run the following

$ ./configure --prefix=/Applications/XAMPP/xamppfiles --enable-utf8 --enable-unicode-properties

$ make

$ sudo make install

And then restart mysql.

Hope this helps.

Related questions

How to do a regular expression replace in MySQL?

I have a table with ~500k rows; varchar(255) UTF8 column filename contains a file name; I'm trying to strip out various strange characters out of the filename - thought I'd use a character class: [^a-zA-Z0-9()_ .\-] Now, is there …

Read More
How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I'm trying is this SELECT trecord FROM `tbl` WHERE (trecord LIKE 'ALA[d]%') And SELECT trecord …

Read More
MySQL SELECT LIKE or REGEXP to match multiple words in one record

The field table.name contains 'Stylus Photo 2100' and with the following query SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus 2100%' I get no results. Of course i would if i searched SELECT `name` FROM `table` WHERE `name` …

Read More