Hi i am out of ideas what triggers the messages below on my homeserver
any subject with special cahrs like "Schlösser" or "Rückmeldung" is not
inserted and triggers that error while i (thanks god) can't reproduce
that on our production servers ('\xF6sser' should have been 'Schlösser'
one time LMTP and the second line is IMAP-append to sent-folder)
my homeserver and production are using the same source tarball version of the
following components and the only difference is Fedora 19 vs. 20 - strange
* Linux 3.13.7
* dbmail-3.1.13
* mariadb-server-5.5.36
* libzdb-3.0
* gmime-2.6.20
* libevent-2.0.21
Mar 29 13:04:21 srv-rhsoft dbmail/lmtpd[29833]: Error:[message]
_header_value_get_id(+1615): SQLException:
Incorrect string value: '\xF6sser' for column 'sortfield' at row 1
Mar 29 13:04:21 srv-rhsoft dbmail/imap4d[29817]: Error:[message]
_header_value_get_id(+1615): SQLException:
Incorrect string value: '\xF6sser' for column 'sortfield' at row 1
____________________________________
CREATE TABLE `dbmail_headervalue` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`hash` varchar(255) NOT NULL,
`headervalue` text NOT NULL,
`sortfield` varchar(255) DEFAULT NULL,
`datefield` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `hash` (`hash`),
KEY `headervalue` (`headervalue`(255)),
KEY `sortfield` (`sortfield`),
KEY `datefield` (`datefield`),
KEY `hash_headervalue` (`hash`,`headervalue`(255))
) ENGINE=InnoDB AUTO_INCREMENT=82254 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
