Ticket #1485107 (closed Bugs: duplicate)
Postgres DB Error constraint violation
| Reported by: | master | Owned by: | |
|---|---|---|---|
| Priority: | 1 - Highest | Milestone: | 0.2-alpha |
| Component: | Database | Version: | 0.1.1 |
| Severity: | major | Keywords: | DB Postgresql constraint violation |
| Cc: |
Description
I am using Postgresql as the DB encoded UTF-8 with roundcube v0.1.1. I sometimes getting the following error.
It seems there is a character in the string that is causing a problem. It might be related to UTF-8 encoding.
[06-Jun-2008 14:00:55 +1000] DB Error: DB Error: constraint violation Query: INSERT INTO messages (user_id, del, cache_key, created, idx, uid, subject, "from", "to", cc, date, size, headers, structure) VALUES ('47', 0, 'INBOX.msg', now(), '31', '99', 'FW: stuff I think is funny', 'Chantal Malaponte <CMalaponte@…>', 'Andrew Rowlands <Andrew_Rowlands@…>, Lynden Watson <lswatson@…>', , '2008-06-06 13:37:44', 3835080, 'O:14:"iilBasicHeader":29:{s:2:"id";s:2:"31";s:3:"uid";s:2:"99";s:7:"subject";s:26:"FW: stuff I think is funn in /var/www/localhost/htdocs/roundcubemail-0.1.1/program/include/rcube_db.inc on line 530
