Error when adding references lots of loading continues

error when adding references lots of loading continues

I have a problem when a submission to a journal has a lot of references, it cannot be sent continuously, but if there are only a few references, it can continue or be completed.

if you have a lot of references it will happen like this on the error log side

2024/10/08 08:28:17 [error] 1280212#0: *2298847 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Exception: DB Error: Incorrect string value: '\xC4\x87, N....' for column 'raw_citation' at row 1 Query: INSERT INTO citations
				(publication_id, raw_citation, seq)
				VALUES
				(?, ?, ?) in /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), 'INSERT INTO cit...')
#1 /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/citation/CitationDAO.inc.php(55): DAO->update('INSERT INTO cit...', Array)
#2 /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/citation/CitationDAO.inc.php(107): CitationDAO->insertObject(Object(Citation))
#3 /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/services/PKPPublicationService.inc.php(532): CitationDAO->importCitations(3367, 'Alhidayatullah,...')
#4 /www/wwwroot/jurnal.ummi.ac.id/lib/pkp/classes/submission/PKPSubmissionMetadataFormImplementation.inc.php(193): PKP\Services\PKPPublicationService->edit(Object(Publi" while reading response header from upstream, client: 103.10.60.194, server: jurnal.ummi.ac.id, request: "POST /index.php/jimat/submission/saveStep/3 HTTP/2.0", upstream: "fastcgi://unix:/tmp/php-cgi-72.sock:", host: "jurnal.ummi.ac.id", referrer: "https://jurnal.ummi.ac.id/index.php/jimat/submission/wizard/2?submissionId=3062"

Hi @Dennis_Saputra,

This is happening because the database is encountering what it thinks is an invalid character sequence; one of your references contains a special character it doesn’t like. Can you narrow down which reference is causing the problem?

Regards,
Alec Smecher
Public Knowledge Project Team

Thank you, it’s finished because the default citation database doesn’t use utf8.

This topic was automatically closed after 12 days. New replies are no longer allowed.