trac-post-commit-hook error when both re: and fixes: keywords included

[mferrier@…]

When a commit message includes both the "re: " and "fixes: " on the same ticket numbers (e.g. "re: #100 fixes: #100"), the trac-post-commit-hook script fails with the following message:

Unexpected error while processing ticket ID 8: columns ticket, time, field are not unique

The script appears to be trying to insert two rows in ticket_change with the same key field values.

[cboos]

I tried to have a look at that, and I've seen that a lot of changes I've recently made have horribly broken that script...

[cboos]

Please try out r3486. It works fine for me.

[mferrier@…]

Can I use this with my 0.9.5-stable installation?

[cboos]

No way. It contains changes that are specific to the 0.10 api/data model. However, it should be possible to downgrade it. I'll have a try.

[mferrier@…]

No biggie if you can't, it's not a big deal to just not re: and close: in the same commit message. I'll upgrade to 0.10 when it's stable.

[cboos]

He, I guess we had a collision... I was about to say:

I ported the above fix to 0.9-stable in r3487. Can you please test it?

[mferrier@…]

Works great, thanks for your help.

[eblot]

anonymous: do not change the status of a ticket without a reason/description.