id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 521,Multilevel foreign key ordering causes error in Admin changeview,andreas,Adrian Holovaty,"Ordering by a foreign key of a model which is itself ordered by another foreign key causes a ""column does not exist""-error in Admin changeview. Code: {{{ class ParentClass(meta.Model): somevar = meta.CharField(maxlength=100) def __repr__(self): return self.somevar class META: admin = meta.Admin(list_display = ('somevar')) ordering = ['somevar'] class FirstChild(meta.Model): theparent = meta.ForeignKey(ParentClass) myvar = meta.CharField(maxlength=100) def __repr__(self): return self.myvar class META: admin = meta.Admin(list_display = ('myvar', 'theparent')) ordering = ['theparent'] class ChildsChild(meta.Model): firstchild = meta.ForeignKey(FirstChild) myownvar = meta.CharField(maxlength=100) def __repr__(self): return self.myownvar class META: admin = meta.Admin(list_display = ('myownvar', 'firstchild')) ordering = ['firstchild'] }}} Error when viewing Admin changeview of ChildsChild: {{{ There's been an error: Traceback (most recent call last): File ""C:\Programme\Python24\lib\site-packages\django\core\handlers\base.py"", line 64, in get_response response = callback(request, **param_dict) File ""C:\Programme\Python24\lib\site-packages\django\views\admin\main.py"", line 183, in change_list result_list = lookup_mod.get_list(**lookup_params) File ""C:\Programme\Python24\lib\site-packages\django\utils\functional.py"", line 3, in _curried return args[0](*(args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File ""C:\Programme\Python24\lib\site-packages\django\core\meta\__init__.py"", line 1123, in function_get_list return list(function_get_iterator(opts, klass, **kwargs)) File ""C:\Programme\Python24\lib\site-packages\django\core\meta\__init__.py"", line 1106, in function_get_iterator cursor.execute(""SELECT "" + (kwargs.get('distinct') and ""DISTINCT "" or """") + "","".join(select) + sql, params) File ""C:\Programme\Python24\lib\site-packages\django\core\db\base.py"", line 10, in execute result = self.cursor.execute(sql, params) ProgrammingError: ERROR: column myproject_firstchilds.theparent does not exist }}} ",enhancement,closed,Metasystem,,blocker,fixed,,,Unreviewed,0,0,0,0,0,0