syncdb error

[andrzej-bieniek]

python manage syncdb fails,

E.g. with sqlite3:

~/radio_www/pydj$ python manage.py syncdb
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table playlist_artist
Creating table playlist_album
Creating table playlist_rating
Creating table playlist_userprofile_favourites
Creating table playlist_userprofile
Creating table playlist_editnote
Creating table playlist_fieldedit
Creating table playlist_songedit
Creating table playlist_songreport
Creating table playlist_song
Creating table playlist_songdir
Creating table playlist_emoticon
Creating table playlist_comment
Creating table playlist_playlistentry
Creating table playlist_removedentry
Creating table playlist_oldplaylistentry
Creating table playlist_settings
Creating table playlist_series
Creating table playlist_show
Creating table playlist_oldshow
Creating table playlist_showrating
Creating table playlist_showcomment
Creating table playlist_showminute
Creating table forum_category
Creating table forum_forum_groups
Creating table forum_forum
Creating table forum_thread
Creating table forum_post
Creating table forum_subscription
Creating table forum_lastread

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (Leave blank to use 'andi'): test
E-mail address: [email protected]
Password:
Password (again):
Superuser created successfully.
Traceback (most recent call last):
File "manage.py", line 11, in
execute_manager(settings)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/init.py", line 438, in execute_manager
utility.execute()
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/init.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv
self.execute(_args, *_options.dict)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute
output = self.handle(_args, *_options)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle
return self.handle_noargs(**options)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 109, in handle_noargs
emit_post_sync_signal(created_models, verbosity, interactive, db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/core/management/sql.py", line 190, in emit_post_sync_signal
interactive=interactive, db=db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 172, in send
response = receiver(signal=self, sender=sender, **named)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/contrib/auth/management/init.py", line 51, in create_permissions
content_type=ctype
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/manager.py", line 138, in create
return self.get_query_set().create(**kwargs)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/query.py", line 360, in create
obj.save(force_insert=True, using=self.db)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save
self.save_base(using=using, force_insert=force_insert, force_update=force_update)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/base.py", line 553, in save_base
result = manager._insert(values, return_id=update_pk, using=using)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/manager.py", line 195, in _insert
return insert_query(self.model, values, **kwargs)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/query.py", line 1436, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql
cursor = super(SQLInsertCompiler, self).execute_sql(None)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
cursor.execute(sql, params)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute
return self.cursor.execute(sql, params)
File "/home/andi/radio_www/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 234, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.IntegrityError: columns content_type_id, codename are not unique

[andrzej-bieniek]

Interesting that, second and third "python manage syncdb" calls also fail with the same error, but fourth call success (see below):

~/radio_www/pydj$ python manage.py syncdb
Creating tables ...
Installing custom SQL ...
Installing indexes ...
No fixtures found.

Web page seems to running ok despite the previous failures.