I updated to version 6.x-1.2 (before i was passed by version 6.x-1.2-rc1) and now, when a try to check a new "subscribed" editing a ticket, I receive the follow message:

user warning: Duplicate entry '12' for key 'PRIMARY' query: INSERT INTO support_ticket (nid, message_id, state, priority, client, assigned) VALUES(12, '', 1, 4, 1, 4) in G:\xampp\htdocs\intranet\sites\all\modules\support\support.module on line 637.

Other updates are allowed, but adding "subscribed". I guess the code should be "UPDATE support_ticket ..." instead of "INSERT INTO support_ticket", should not?

Please, help me.

Thanks.

Luciano Gomes

Comments

jeremy’s picture

jeremy commented
Status: Active » Postponed (maintainer needs more info)

The line before that in the code does do an UPDATE, and the INSERT only happens if the UPDATE fails. I don't see any valid reason that the UPDATE would fail that would then result in the INSERT causing this error.

What database are you using? What OS?

Does this affect all tickets, or just one specific ticket?

Is there anything non-standard about your installation?

jeremy’s picture

jeremy commented
Status: Postponed (maintainer needs more info) » Fixed

No further feedback, closing ticket.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

rsevero’s picture

rsevero commented
Status: Closed (fixed) » Closed (duplicate)

I believe this is a duplicate of #708880: Duplicate entry '3' for key 'PRIMARY' query: INSERT INTO support_ticket.