I have recently discovered that Django admin is generating errors when trying to sort a table on certain fields: in particular, those fields that are ForeignKey linked to a separate table, each of which has a 'name' field. Selecting any of these columns for a sort generates this error:
OperationalError at /admin/myapp/mytable/ (1060, "Duplicate column name 'name'") A full stack trace is shown below. I am working with MySQL 5.5 and Django 1.6.3. Has anyone else encountered this error? Is this a known bug and/or is there a workaround? Thanks Derek Stack Trace: Traceback: File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 139. response = response.render() File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/response.py" in render 105. self.content = self.rendered_content File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/response.py" in rendered_content 82. content = template.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 140. return self._render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in _render 134. return self.nodelist.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 840. bit = self.render_node(node, context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render_node 854. return node.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/loader_tags.py" in render 123. return compiled_parent._render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in _render 134. return self.nodelist.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 840. bit = self.render_node(node, context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render_node 854. return node.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/loader_tags.py" in render 123. return compiled_parent._render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in _render 134. return self.nodelist.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 840. bit = self.render_node(node, context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render_node 854. return node.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/loader_tags.py" in render 62. result = block.nodelist.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 840. bit = self.render_node(node, context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render_node 854. return node.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/loader_tags.py" in render 62. result = block.nodelist.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 840. bit = self.render_node(node, context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render_node 854. return node.render(context) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/template/base.py" in render 1196. _dict = func(*resolved_args, **resolved_kwargs) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/contrib/admin/templatetags/admin_list.py" in date_hierarchy 312. last=models.Max(field_name)) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/models/query.py" in aggregate 278. return query.get_aggregation(using=self.db) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/models/sql/query.py" in get_aggregation 356. result = query.get_compiler(using).execute_sql(SINGLE) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql 786. cursor.execute(sql, params) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 69. return super(CursorDebugWrapper, self).execute(sql, params) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 53. return self.cursor.execute(sql, params) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/utils.py" in __exit__ 99. six.reraise(dj_exc_type, dj_exc_value, traceback) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 53. return self.cursor.execute(sql, params) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py" in execute 124. return self.cursor.execute(query, args) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/MySQLdb/cursors.py" in execute 201. self.errorhandler(self, exc, value) File "/home/derek/.virtualenvs/demo/local/lib/python2.7/site-packages/MySQLdb/connections.py" in defaulterrorhandler 36. raise errorclass, errorvalue -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAF1Wu3OiP%2BBC2WW5u6GjWukGu%3D%2BuZVBy4e5NniBQQctYaRW7YQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
