Jump to content

PrestaShop 1.7 - SQL Error


Recommended Posts

Hi all,


I have a error with PrestaShop 1.7


DriverException in AbstractMySQLDriver.php line 115:
An exception occurred while executing 'SELECT p0_.id_translation AS id_translation_0, p0_.`key` AS key_1, p0_.translation AS translation_2, p0_.domain AS domain_3, p0_.theme AS theme_4, p0_.id_lang AS id_lang_5 FROM ps_translation p0_ WHERE p0_.id_lang = ? AND p0_.theme IS NULL AND (p0_.domain REGEXP ?) = 1' with params [1, "AdminActions"]:
SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp
This error occurs when you activate the "_PS_MODE_DEV_". And I'm using the Mac OSX, PHP 5.6.19
Please help me!
Thank you!
Link to comment
Share on other sites

  • 3 weeks later...
  • 1 year later...
  • 1 month later...


This problem is solved by installing PCRE to your local system.

This error shows that UTF8 is not supported by your system

By following the links below will solve your problem:

  1. Download PCRE from this site: 
  2. Open Terminal and CD to the extracted PCRE folder
  3. You are now inside the PCRE folder
  4. Run this -> 
    ./configure --prefix=/Applications/XAMPP/xamppfiles --enable-utf8 --enable-unicode-properties
  5. After the first script, run this ->
  6. After the second script, run this -> 
    sudo make install

 7. wait till compiling is over and then copy newly created files to our library folder

8. run this - >

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

and this if  needed

sudo cp .libs/* /Applications/XAMPP/xamppfiles/bin

9. Restart XAMPP


Now, if we check 
/Applications/XAMPP/xamppfiles/bin/pcretest -C

we should see that UTF 8 is supported:
PCRE version 8.38 2015-11-23
Compiled with
  8-bit support
  UTF-8 support

  Unicode properties support
  No just-in-time compiler support
  Newline sequence is LF
  \R matches all Unicode newlines
  Internal link size = 2
  POSIX malloc threshold = 10
  Parentheses nest limit = 250
  Default match limit = 10000000
  Default recursion depth limit = 10000000
  Match recursion uses stack
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...