0013596: Error "Character not in repertoir" when fileing message (PGSQL) #6725

Closed
Gloirin opened this Issue Jun 9, 2018 · 1 comment

Comments

Projects
None yet
1 participant
@Gloirin

Gloirin commented Jun 9, 2018

Reported by apvit on 31 Oct 2017 09:02

Version: 2017.08.8 Community Edition

Error message:

2018-01-11T08:31:50+00:00 NOTICE (5): Felamimail_Controller_Cache_Message::_addMessageToCache::918 failed to add message to cache: SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe5, query was: INSERT INTO "t20_felamimail_cache_message" ("account_id", "messageuid", "folder_id", "received", "size", "timestamp", "body_content_type", "content_type", "subject", "sent", "from_email", "from_name", "text_partid", "html_partid", "has_attachment", "id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1, 2, 0, ?)

same here in Mailfiler

Fehler beim Speichern von Nachrichten
SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc2, query was: INSERT INTO "t20_notes" ("note_type_id", "note", "record_id", "record_model", "record_backend", "id", "created_by", "creation_time", "last_modified_by", "last_modified_time", "is_deleted", "deleted_time", "deleted_by", "seq") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Log:
41787 eb - 2017-10-31T07:38:08+00:00 ERR (3): Tinebase_Exception::log::104 Zend_Db_Statement_Exception -> SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc2, query was: INSERT INTO "t20_notes" ("note_type_id", "note", "record_id", "record_model", "record_backend", "id", "created_by", "creation_time", "last_modified_by", "last_modified_time", "is_deleted", "deleted_time", "deleted_by", "seq") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
41787 eb - 2017-10-31T07:38:08+00:00 WARN (4): Tinebase_Server_Json::_handleException::368 Zend_Db_Statement_Exception -> SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc2, query was: INSERT INTO "t20_notes" ("note_type_id", "note", "record_id", "record_model", "record_backend", "id", "created_by", "creation_time", "last_modified_by", "last_modified_time", "is_deleted", "deleted_time", "deleted_by", "seq") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
41787 eb - 2017-10-31T07:38:08+00:00 ERR (3): Tinebase_Exception::log::104 Zend_Db_Statement_Exception -> SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xc2, query was: INSERT INTO "t20_notes" ("note_type_id", "note", "record_id", "record_model", "record_backend", "id", "created_by", "creation_time", "last_modified_by", "last_modified_time", "is_deleted", "deleted_time", "deleted_by", "seq") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Server: Debian 8
Database: PSQL

This error seems to be a general problem with PSQL-Database. Log shows many errors like this when trying to cache messages in Felamimail.

Example from Log:
a1219 jürgen - 2017-10-31T08:15:53+00:00 NOTICE (5): Felamimail_Controller_Cache_Message::_addMessageToCache::918 failed to add message to cache: SQLSTATE[22021]: Character not in repertoire: 7 FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe5, query was: INSERT INTO "t20_felamimail_cache_message" ("account_id", "messageuid", "folder_id", "received", "size", "timestamp", "body_content_type", "content_type", "subject", "sent", "from_email", "from_name", "text_partid", "html_partid", "has_attachment", "id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1, 2, 0, ?)

If necessary, I can provide the respective mail, that causes the error.

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 11, 2018

Comment posted by pschuele on 1 Mar 2018 16:31

pgsql support will be dropped soon.

Gloirin commented Jun 11, 2018

Comment posted by pschuele on 1 Mar 2018 16:31

pgsql support will be dropped soon.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment