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.