Closed
Bug 24803
Opened 25 years ago
Closed 25 years ago
Duplicate profiles entries exist!
Categories
(Bugzilla :: Bugzilla-General, defect, P2)
Tracking
()
RESOLVED
FIXED
Bugzilla old
People
(Reporter: terry, Assigned: terry)
Details
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•25 years ago
|
Status: NEW → ASSIGNED
Priority: P3 → P2
Assignee | ||
Comment 1•25 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
Closed: 25 years ago
Resolution: --- → FIXED
Comment 2•24 years ago
|
||
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.
Comment 3•23 years ago
|
||
Moving to Bugzilla product
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Target Milestone: --- → Bugzilla old
Version: other → unspecified
Updated•12 years ago
|
QA Contact: matty_is_a_geek → default-qa
You need to log in
before you can comment on or make changes to this bug.
Description
•