I've been seeing some problems when a comment is edited then edited again by another account.
I've also seen some trouble when the comment is unpublished, edited and republished, though I haven't analyzed that scenario much.
What happens: When the second account edits the same comment, the comment_edited_data table ends up with two rows with the same CID, one for each UID that edited the comment.
Maybe that's normal, but the username that shows in the "Last edited by" line is still the first one, and--in my theme, the "Last edited by" line displays with an odd box around it.
When I tried to edit it again (using the 2nd user account, not a third one) I got this error...
user warning: Duplicate entry '17825-0' for key 1 query: UPDATE comment_edited_data SET cid = 17825, uid = 6, timestamp = 1283307604, type = 0 WHERE cid = 17825 in /home/acct/public_html/includes/common.inc on line 3477.
Comments
Comment #1
aharown07 commentedAlso.. .this might be another bug, but might not. Currently, if one account unpublishes a comment, say account x, other accounts with ability to see unpublished comments see "Last edited by x" on the unpublished comment.
Comment #2
aharown07 commentedThe "odd box around" the Last edited by line has something to do with the fact that it is printing in a css selector called
<fieldset>. Normally, the last ed. by line is just in a class called "last-edited"Don't know why that's happening though.
Comment #3
snufkin commented- I have fixed the unpublished comments triggering the update of the last edited message.
- I am not sure what your problem is with the theme, the messages are displayed in a theme('fieldset'). Please open a new issue and describe it in more detail if it is still relevant.
- The SQL error has been fixed.