Duplicate profiles entries exist!

RESOLVED FIXED in Bugzilla old

Status

()

Bugzilla
Bugzilla-General
P2
normal
RESOLVED FIXED
19 years ago
5 years ago

People

(Reporter: Terry Weissman, Assigned: Terry Weissman)

Tracking

unspecified
Bugzilla old
x86
Linux

Details

(Assignee)

Description

19 years ago
In the bugzilla.mozilla.org installation, this query comes up with 52 rows:


select p1.userid from profiles as p1, profiles as p2 where p1.userid !=
p2.userid and p1.login_name = p2.login_name;

This is bad.  I need to figure out a good way to fix it.

I also need to change the tables so that it can't happen again...
(Assignee)

Updated

19 years ago
Status: NEW → ASSIGNED
Priority: P3 → P2
(Assignee)

Comment 1

19 years ago
OK, fixed.  For the record, these are the duplicates I had:

mysql> select  p1.userid, p2.userid, p1.login_name from profiles as p1, profiles
as p2 where p1.userid < p2.userid and p1.login_name = p2.login_name order by
p1.login_name;
+--------+--------+---------------------------------+
| userid | userid | login_name                      |
+--------+--------+---------------------------------+
|   1501 |   1502 | ahmed@totalsports.net           |
|   5566 |  10251 | ben@netscape.com                |
|   1524 |   1525 | clussier@emba.uvm.edu           |
|   1151 |   1152 | dcrs6000@pacbell.net            |
|    955 |    956 | e9126180@student.tuwien.ac.at   |
|   2018 |   2019 | futloy@iname.com                |
|   2720 |   2737 | GurraB@bigfoot.com              |
|   1700 |   1701 | henrik_@rocketmail.com          |
|   1203 |   1204 | jmauro@ukans.edu                |
|   1203 |   1205 | jmauro@ukans.edu                |
|   1204 |   1205 | jmauro@ukans.edu                |
|   1992 |   1993 | lee@spydernet.net               |
|   3421 |   3422 | mattl@dwp.net                   |
|   1460 |   1461 | mlewinsk@newton.kamsc.k12.mi.us |
|    590 |    591 | motch@inquo.net                 |
|   9819 |   9820 | msovani@yahoo.com               |
|   9819 |   9821 | msovani@yahoo.com               |
|   9820 |   9821 | msovani@yahoo.com               |
|      1 |   6304 | nobody@mozilla.org              |
|   1439 |   1440 | owenguy@world.std.com           |
|   2556 |   2557 | shassard@angio.com              |
|   1142 |   1143 | skylar@nwlink.com               |
|   2278 |   2279 | stoecker@mindrevolution.com     |
|   2836 |   2837 | sxpert@altavista.net            |
|    928 |    929 | todd.graham@sbaonline.sba.gov   |
|   1493 |   1494 | trondam@ifi.uio.no              |
+--------+--------+---------------------------------+
26 rows in set (7.32 sec)
Status: ASSIGNED → RESOLVED
Last Resolved: 19 years ago
Resolution: --- → FIXED
Terry, it would help verification if you could tell me how this happened and
what you fixed.  I can verify this won't work through editusers.cgi or "open a
new bugzilla account", but was wondering if there was anything else.
Moving to Bugzilla product
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Target Milestone: --- → Bugzilla old
Version: other → unspecified
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.