Newbie: Operational Error 1060 Duplicate column name
I'm fairly new to django and I'm trying to restart an old database.
When I run the command run manage.py syncdb
I get the following error:
>run manage.py syncdb
Creating table slide_taxonomyphylum
ERROR: An unexpected error occured while tokenizing input
The following traceback may be be corrupted or invalid
The error message is: ('EOF in multi-line statement', (72,0))
ERROR: Internal Python error in the inspect module
Below is the traceback from this internal error
Traceback (most recent call last):
File "/usr/lib/pymodules/python2.6/IPython/ultraTB.py", line
667, in text
locals, formatvalue=var_rep))
File "/usr/lib/python2.6/inspect.py", line 875, in
formatargvalues
specs.append(strseq(args[i], convert, join))
File "/usr/lib/python2.6/inspect.py", line 830, in strseq
return convert(objects)
File "/usr/lib/python2.6/inspect.py", line 872, in convert
return formatarg(name) + formatvalue(locals[name])
KeyError: 'connection'
Not sure what this means. Help is greatly appreciate. I looked on
google for some help but didn't find much.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
Re: Newbie: Operational Error 1060 Duplicate column name
It was a IPython internal error. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Re: Newbie: Operational Error 1060 Duplicate column name
I delete the database and installed a new one with no tables at all. Using regular Python I ran the script manage.py with subcommand syncdb It created the first 4 tables then hit an error. Here is the traceback for the error. Traceback (most recent call last): File "manage.py", line 32, in execute_manager(settings) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ __init__.py", line 438, in execute_manager utility.execute() File "/usr/local/lib/python2.6/dist-packages/django/core/management/ __init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 218, in execute output = self.handle(*args, **options) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 347, in handle return self.handle_noargs(**options) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ commands/syncdb.py", line 95, in handle_noargs cursor.execute(statement) File "/usr/local/lib/python2.6/dist-packages/django/db/backends/ mysql/base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute self.errorhandler(self, exc, value) File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1060, "Duplicate column name 'taxonomy_kingdom_id'") Does this mean that when it tries to create the table slide_taxonomykingdom there is already a column with "id" and its trying to make another one? -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Re: Newbie: Operational Error 1060 Duplicate column name
I deleted the database and installed a new one with no tables at all. Using regular Python I ran the script manage.py with subcommand syncdb. It created the first 4 tables then hit an error. Here is the traceback for the error. Traceback (most recent call last): File "manage.py", line 32, in execute_manager(settings) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ __init__.py", line 438, in execute_manager utility.execute() File "/usr/local/lib/python2.6/dist-packages/django/core/management/ __init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 218, in execute output = self.handle(*args, **options) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ base.py", line 347, in handle return self.handle_noargs(**options) File "/usr/local/lib/python2.6/dist-packages/django/core/management/ commands/syncdb.py", line 95, in handle_noargs cursor.execute(statement) File "/usr/local/lib/python2.6/dist-packages/django/db/backends/ mysql/base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in executeself.errorhandler(self, exc, value) File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35,in default errorhandler raise errorclass, errorvalue OperationalError: (1060, "Duplicate column name 'taxonomy_kingdom_id'") Does this mean that when it tries to create the table slide_taxonomykingdom there is already a column with "id" and its trying to make another one? Here is the Python code that creates the two associated tables: class TaxonomyKingdom(models.Model): name = models.CharField(max_length=100, unique=True) superior=0 def __unicode__(self): return '%s' % (self.name) class TaxonomyPhylum(models.Model): name = models.CharField(max_length=100, unique=True) superior=taxonomy_kingdom = models.ForeignKey(TaxonomyKingdom, null=True, blank=True) def __unicode__(self): return '%s' % (self.name) -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Re: Newbie: Operational Error 1060 Duplicate column name
I want the foreign key to be called taxonomy_kingdom. So would I do something like this? taxonomy_kingdom = models.ForeignKey(TaxonomyKingdom, null=True, blank=True) superior=taxonomy_kingdom On Thu, Sep 23, 2010 at 10:18 PM, Karen Tracey wrote: > On Thu, Sep 23, 2010 at 1:03 PM, Howard Wolf wrote: > >> class TaxonomyPhylum(models.Model): >>name = models.CharField(max_length=100, unique=True) >>superior=taxonomy_kingdom = models.ForeignKey(TaxonomyKingdom, >> null=True, blank=True) >> > > Do you want that ForeignKey field to be named superior or taxonomy_kingdom? > Right now you've got 2 equal signs in there, and somehow that is causing > Django to try to create two columns with the 2nd name (taxonomy_kingdom_id). > > Karen > -- > http://tracey.org/kmt/ > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- Howard Wolf, wolf18 Computer Science, University of Illinois, Urbana-Champaign https://hwrdwlf18.homelinux.com -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
