Problem installing fixtures

Hi All,

I am new to Django and would appreciate some help with the problem I am facing. I am setting up a new server as the previous host machine went missing! I have a JSON file from dumpdata on the now missing server and am trying to load this data to the newly set up server. However, I seem to be getting the following issues after running python manage.py loaddata.

 

Traceback (most recent call last):
  File "/home/wst12/Documents/ipad-app-server/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 353, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 345, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 348, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 399, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/loaddata.py", line 60, in handle
    self.loaddata(fixture_labels)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/loaddata.py", line 106, in loaddata
    connection.check_constraints(table_names=table_names)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql/base.py", line 223, in check_constraints
    self.cursor().execute('SET CONSTRAINTS ALL IMMEDIATE')
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 62, in execute
    return self.cursor.execute(sql)
django.db.utils.IntegrityError: Problem installing fixtures: insert or update on table "auth_permission" violates foreign key constraint "auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id"
DETAIL:  Key (content_type_id)=(27) is not present in table "django_content_type".

At first, I was led to believe, after some Googling, that it was cache related. I tried to clear content type cache but the problem still persists. I hope someone could help me out. Thank you!

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dbd79e57-cf1f-48de-b04c-4d5dfd841160%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.