Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » multibyte error (Fatal error when inserting non-latin characters)
multibyte error [message #7100] Mon, 11 December 2017 06:54 Go to next message
barnabooth is currently offline  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?
Re: multibyte error [message #7101 is a reply to message #7100] Mon, 11 December 2017 08:41 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
Senior Member
Can you provide me with the multi-byte string which is causing this problem?

Re: multibyte error [message #7102 is a reply to message #7101] Mon, 11 December 2017 08:42 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
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.


Re: multibyte error [message #7103 is a reply to message #7102] Mon, 11 December 2017 09:07 Go to previous message
barnabooth is currently offline  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!
Previous Topic: Installation 2.0.7
Next Topic: XSL-Function error
Goto Forum:
  


Current Time: Thu Mar 28 19:17:29 EDT 2024

Total time taken to generate the page: 0.01037 seconds