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
6649	Can't order by a ForeignKey relation	toomim	nobody	"I have a model Venue that is sorted by ""-pub_date"":

{{{
class Venue(models.Model):
    ....
    pub_date = models.DateField('Published date', help_text=""Only the year and month will be used"")
    class Admin: pass
    class Meta:
        ordering = (""-pub_date"",)
}}}

And a model PubAward that foreignkeys Venue, and sorts by Venue:

{{{
class PubAward(models.Model):
    ...
    venue = models.ForeignKey(Venue, blank=True)
    class Admin: pass
    class Meta:
        ordering = (""venue"",)
}}}

But when I open an admin page on PubAward, it tries to list all PubAwards and gives me the following error:

{{{
no such column: main_venue.-pub_date
}}}

Here's the full stack trace:


{{{
Environment:

Request Method: GET
Request URL: http://together.cs.washington.edu:8082/admin/main/pubaward/
Django Version: 0.97-pre-SVN-7149
Python Version: 2.4.4
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'dubweb.main',
 'django.contrib.admin']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware')


Traceback:
File ""/usr/lib/python2.4/site-packages/django/core/handlers/base.py"" in get_response
  82.                 response = callback(request, *callback_args, **callback_kwargs)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/decorators.py"" in _checklogin
  56.             return view_func(request, *args, **kwargs)
File ""/usr/lib/python2.4/site-packages/django/views/decorators/cache.py"" in _wrapped_view_func
  39.         response = view_func(request, *args, **kwargs)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in change_list
  776.         cl = ChangeList(request, model)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in __init__
  582.         self.get_results(request)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in get_results
  640.             result_list = list(self.query_set)
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in __iter__
  114.         return iter(self._get_data())
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in _get_data
  483.             self._result_cache = list(self.iterator())
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in iterator
  189.         cursor.execute(""SELECT "" + (self._distinct and ""DISTINCT "" or """") + "","".join(select) + sql, params)
File ""/usr/lib/python2.4/site-packages/django/db/backends/util.py"" in execute
  18.             return self.cursor.execute(sql, params)
File ""/usr/lib/python2.4/site-packages/django/db/backends/sqlite3/base.py"" in execute
  133.         return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /admin/main/pubaward/
Exception Value: no such column: main_venue.-pub_date
}}}

This also occurs without the hyphen in ""-pub_date""."		closed	Core (Other)	dev		invalid			Unreviewed	0	0	0	0	0	0