Can't add new post blog, I have some error ?
scada-josh opened this issue · 2 comments
An exception occurred while executing 'SELECT id FROM pk_system_role WHERE (id = ?) OR (permissions REGEXP '(^|,)(blog: manage all posts|blog: manage own posts)($|,)')' with params [3]: SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp
Came up against this myself when trying out pagekit for a bilingual web site cms. It is not directly a pagekit problem. The error means (as it indicates!) that the PCRE (Perl Compatible Regular Expressions) has been compiled without UTF8 support. There are instructions for a fix here. https://www.coditty.com/code/pcre-error-when-using-regxp-in-mysql-xampp.
I wish everything would just default to UTF, kind surprising when it doesn't these days.
Be aware that there is a newer version - PCRE2 which defaults to compiling with unicode but there is some question around compatibility with Apache. The instructions from coditty using the older version worked fine. Note that they apply to XAMPP but could easily be adapted to other env.