PrestaShop 1.7 - SQL Error

[Mr.Zero]

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!

[Selwyn Orren]

Yup I have the same issue on my XAMPP Installation in Linux. However only when trying to access modules.

 

Please help

 

P.S. I found a solution here:

http://www.mzan.com/article/35986243-error-when-using-regexp-in-mysql.shtml

Edited November 28, 2016 by Selwyn Orren (see edit history)

[cuongnp]

Hello,

 

 I got the same error with version 1.7.0.2

 

I follow the guide on stackoverflow, http://stackoverflow.com/questions/35801425/xampp-mysql-this-version-of-pcre-is-compiled-without-utf-support-at-offset-0?answertab=votes#tab-top

 

I work well for me,

 

Hope this helps

[bharath.acapecomrin]

Where will insert the pcre folder?

Please explain me in detail...

[xpertidea.com]

Hello Guys i get a solution to solve this problem.
Just need to delete : app->Resources->translations->en-US folder

 

en-US will be changed with your shop language code. Also you can delete all folders without default folder

[bharath.acapecomrin]

I solved this, installed pcre in your local system through terminal.

Then restart your system.

Working fine ....

 

Thanks

 

 

[Steve Joms]

Hello,

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: 
   https://sourceforge.net/projects/pcre/files/pcre/8.38/
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 ->

   make

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