Opened 10 years ago

Closed 10 years ago

#877 closed defect (duplicate)

ordering by primary key in admin with oneToOne relations is done over the wrong table

Reported by: anonymous Owned by: adrian
Component: contrib.admin Version: master
Severity: normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:


If I use the admin application to browse for a relation that shares the primary key with another via an OneToOne fields, I take an error.
In my example, Person shares the primary key with Party, and browsing Person I take:

OperationalError at /admin/parties/persons/
(1109, "Unknown table 'parties_parties' in order clause")

It seems that the Sql related is

['parties_persons.party_id',..., 'parties_persons.last_modified']
' FROM parties_persons ORDER BY DESC'

and I can see that the order by is done on the "father" table.

Of course, if I force a different order field with ordering = -dob?, for example, it's all o.k.

Change History (2)

comment:1 Changed 10 years ago by bruce@…

This is the same as ticket:930 I think, which has a patch attached.

comment:2 Changed 10 years ago by jkocherhans

  • Resolution set to duplicate
  • Status changed from new to closed

Duplicate of #1245

Note: See TracTickets for help on using tickets.
Back to Top