Radicore Forum: RADICORE Installation Issues

Home » RADICORE » RADICORE Installation Issues » multibyte error (Fatal error when inserting non-latin characters)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multibyte error [message #7100]

Mon, 11 December 2017 06:54

barnabooth
Messages: 12
Registered: February 2011

Junior Member

I have been trying to figure out the following problem for several days now, but I am afraid I can't come any further than this. The problem is:

When I try to insert non-latin characters I get the following error message:

Fatal Error: MySQL: Incorrect string value: '\xD0\xAD\xD0\xB2\xD0\xB5...' for column 'new_value' at row 1 (# 256)
Error in line 1192 of file '/var/www/html/radicore/includes/dml.mysqli.class.inc' ...

As far as I understand this is a multibyte-error.

My database (mariaDB) is entirely set in utf8mb4_unicode_ci and when I access my db from phpMyAdmin for instance, I have no problem inserting non-latin characters. This -- I think -- excludes any issues with server or php.ini settings, and instead points to my radicore-setup. (And when they are inserted through phpMyAdmin they also shows up correctly in radicore).

The problem appeared after a reinstallation when I shifted from apache2 to FPM/FastCGI
Before I had php_value settings for utf8 in the .htaccess file, which is not possible with FPM. Instead I have tried to include

default_charset = "UTF-8"
mbstring.internal_encoding "UTF-8"

in a .user.ini file at radicore-root and my application root (also tried with "utf8mb4" without any success).

Is it possible that you (or someone else) could point me at the right direction where to look for a solution of this problem?

Report message to a moderator

Re: multibyte error [message #7101 is a reply to message #7100]

Mon, 11 December 2017 08:41

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Can you provide me with the multi-byte string which is causing this problem?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: multibyte error [message #7102 is a reply to message #7101]

Mon, 11 December 2017 08:42

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If you logon to my demo app at https://www.radicore.org/demo.php and visit page "Home-PROTO-Example System-List Option" you will see several entries that contain multi-byte characters. Can you create a new entry using the multi-byte characters which are causing this problem? If you can then it's not a framework issue, it is something to do with FPM/FastCGI which is outside of my control.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: multibyte error [message #7103 is a reply to message #7102]

Mon, 11 December 2017 09:07

barnabooth
Messages: 12
Registered: February 2011

Junior Member

Yes, I can (and did) create a new entry

Эверетт, Хью

which (for instance) does not function on my localhost installation.

Do I understand it correctly that there is no need for any manual utf-8 additions in the framework whatsoever (in .htaccess .user.ini or config-files in the include directory)?

If so, then there is probably something with fpm/fast cgi that I don't get, as the problem appeared after the shift from apache2.

Anyway, thank you for your quick response!

Report message to a moderator

Previous Topic:	Installation 2.0.7
Next Topic:	XSL-Function error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jun 20 04:54:31 EDT 2025

Total time taken to generate the page: 0.01267 seconds