[Tickets #8900] DB Error: constraint violation - attributes

Fri Mar 5 10:21:16 UTC 2010

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8900
------------------------------------------------------------------------------
  Ticket             | 8900
  Created By         | webmaster at mairie-meyzieu.fr
  Summary            | DB Error: constraint violation - attributes
  Queue              | Whups
  Version            | 1.0.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------

webmaster at mairie-meyzieu.fr (2010-03-05 05:21) wrote:

Hi,
Whups send an error messages to users when they post a ticket.

-> In horde log, I have this :
Mar 05 10:34:21 HORDE [error] [whups] DB Error: constraint violation:  
INSERT INTO whups_attributes(ticket_id, attribute_id, attribute_value)  
VALUES ('111', 4, '5') [nativecode=1062 ** Duplicate entry '4' for key  
1] [pid 3785 on line 2679 of  
"/var/www/html/webmail/whups/lib/Driver/sql.php"]

-> In the ticket, no attribute is registred, ever in db but a line  
appears in the ticket's history : attribute &#8658; 5