andrzej-bieniek
commented
13 years ago 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.
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: test@test.com 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