328615 - Watching the same user twice produces a SQL error

Status: VERIFIED DUPLICATE of bug 320866

(Bugzilla :: User Accounts, defect, P2)

Description

[timeless]

DBD::mysql::st execute failed: Duplicate entry '135075-25155' for key 1 [for Statement "INSERT INTO watch (watched, watcher) 
         main::SaveEmail() called at /opt/webtools/bugzilla/userprefs.cgi line 426                                            
                                                                                                                              
   For help, please send mail to the webmaster ([e-mail]), giving this error message and the time and date of    
   the error.                                                                                                                 

steps: try to add the world to a world of watchees. you're bound to get duplicates.

expected results: who cares if i try to watch someone twice? i can only possibly watch them once, so just make sure i'm watching that user and move on!

This is a blocker. There's no way i'm going to try to convince an SSL bugzilla to give me a usable list so i can sort to exclude things i'm already watching for including another huge list.

Comment 1

[Max Kanat-Alexander]

Yeah, we definitely know about this. I thought there was already a bug filed for it, but I guess not.

This should be a pretty easy fix, just unique-ifiying the array before we run the INSERT calls.

Comment 2

[Max Kanat-Alexander]

You know, I actually can't reproduce this on landfill, no matter what I do. And the code for this page is identical all the way back to 2.20.

Perhaps this page is customized on bmo or something?

Comment 3

[Frédéric Buclin]

*** This bug has been marked as a duplicate of 320866 ***

Comment 4

[timeless]

grumble. bmo needs an update.

Comment 5

[timeless]

*** Bug 328689 has been marked as a duplicate of this bug. ***

Comment 6

[Frédéric Buclin]

*** Bug 328689 has been marked as a duplicate of this bug. ***