6.0.0-beta1
7/25/25

[#8900] DB Error: constraint violation - attributes
Summary DB Error: constraint violation - attributes
Queue Whups
Queue Version 1.0.1
Type Bug
State No Feedback
Priority 2. Medium
Owners
Requester webmaster (at) mairie-meyzieu (dot) fr
Created 03/05/2010 (5621 days ago)
Due
Updated 04/06/2010 (5589 days ago)
Assigned 03/17/2010 (5609 days ago)
Resolved 04/05/2010 (5590 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
04/06/2010 07:29:29 AM webmaster (at) mairie-meyzieu (dot) fr Comment #3 Reply to this comment
Hi, all is right without the primary key.

A big thanks for the tips.
04/05/2010 01:11:24 PM Jan Schneider State ⇒ No Feedback
 
03/17/2010 04:10:01 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
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"]
There is no key for the whups_attributes table created in the sql scripts.
03/05/2010 10:21:15 AM webmaster (at) mairie-meyzieu (dot) fr Comment #1
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Whups
Summary ⇒ DB Error: constraint violation - attributes
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
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 ⇒ 5

Saved Queries