Your browser (Internet Explorer 6) is out of date. It has known security flaws and may not display all features of this and other websites. Learn how to update your browser.
X

SOLVED: SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'this version of PCRE is compiled without UTF support

I ran into this problem while trying to create a product. I use XAMPP on my Mac. When I hit the save button, it gives this error.

`SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp, query was: SELECT MAX(ABS(CAST(SUBSTRING(`value`, 5, LENGTH(`value`) - 4) AS SIGNED))) FROM `catalog_product_entity_url_key`

This error is as a result of this version of PCRE is compiled without UTF support at offset 0. Run the below code from your terminal to be sure this is the issue

/Applications/XAMPP/xamppfiles/bin/pcretest -C

the output should look like this:

Fixing this is easy...here is how

1. Download PCRE from this site: https://sourceforge.net/projects/pcre/files/pcre/8.38/

2. Extract the folder and execute this command

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


make

sudo make install

3. Wait till compiling is over and then copy newly created library into your lib folder

$sudo cp .libs/* /Applications/XAMPP/xamppfiles/lib

// if needed execute this line as well
$sudo cp .libs/* /Applications/XAMPP/xamppfiles/bin

4. Check the UTF support again

Please retart your XAMPP Server.

Hope this helps someone.


comments powered by Disqus