Closed Bug 843394 Opened 11 years ago Closed 10 years ago

Conflict in schema for AMO user data

Categories

(addons.mozilla.org Graveyard :: Code Quality, defect)

Product:
addons.mozilla.org Graveyard
Component:
Code Quality
Platform:
Other
All
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: ashort, Unassigned)

References

Details

Inspecting the database for account info surrounding http://sentry.dmz.phx1.mozilla.com/addons/group/2196/events/203955/ reveals the following:

In 'auth_user', username is declared as "varchar(255) NOT NULL". 
In 'users', username is declared as "varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL".

As a result, the django user table is case-insensitive on usernames and the zamboni user table is case sensitive, leading to a situation where there are two entries in users for one in auth_user, leading to the given traceback.
Component: Administration → Code Quality
Blocks: 878867
wow, 22,271 more rows in users than auth_user.
fixed as part of 558514
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.