Cannot submit article using QuickSubmit plugin, if the abstract has special characters

Psek · September 2, 2021, 2:29pm

I am using OJS 3.3.0-7.

While using quick submit plugin, when the abstract contain greek letters or symbols, it is giving the error and cannot submit the article for publication.

I tried removing the those special characters, then it works.

How to make it work with special characters like 𝜛

Config.php details:

;;;;;;;;;;;;;;;;;;;;;;;;;
; Localization Settings ;
;;;;;;;;;;;;;;;;;;;;;;;;;

[i18n]

; Default locale
locale = en_US

; Client output/input character set
client_charset = utf-8

; Database connection character set
; Must be set to “Off” if not supported by the database server
; If enabled, must be the same character set as “client_charset”
; (although the actual name may differ slightly depending on the server)
connection_charset = utf8

Here is the error log:

[01-Sep-2021 16:57:14 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9D\x9C\x9B (…’ for column ‘setting_value’ at row 1 in /home/resaim/journals/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /home/resaim/journals/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /home/resaim/journals/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/resaim/journals/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘insert into pu...', Array) #3 /home/resaim/journals/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into pu…’, Array, Object(Closure))
#4 /home/resaim/journals/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/ in /home/resaim/journals/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

Thanks in advance

jnugent · September 2, 2021, 2:47pm

Hi @Psek

OJS definitely supports extended character sets. You should verify that the tables in your database are actually utf8, and not latin1, and that your server’s connection character set and collations are also utf8. If you’re mixing the two then the results will be unpredictable.

Jason

Psek · September 2, 2021, 4:00pm

Hi @jnugent

Here is the modifications i have made in the Cpanel>phpmyadmin

Using WHM>Phpmyadmin, the following changes are made

I have also tried with utf8_general_ci, Restarted the server also. But still i cannot insert the special characters.

Any suggestions

Regards,

P. Sek

hilongo · September 3, 2021, 12:29pm

Hello @Psek … It seems you checked the database and the server collations … but did you check the tables collations and character sets? They may have mixed collations independently of the general setting.