Are you moving the content of your old database to a new one ? Sorry, if I answer the obvious, but when you move, it seems that the IDs of your content type has change.
And the DATABASE point you an error "violates foreign key constraint" auth permission has a generic relation were a content_type_id = 27 cant be found on content_type table. let me know if its not enought. --------------------------------------------------------------------- Cadu Leite G+: google.com/+CarlosLeite twitter: @cadu_leite site: http://people.python.org.br/ On Wed, Feb 10, 2016 at 7:07 PM, WST <weishengt...@gmail.com> wrote: > > Hi All, > > I am new to Django and am taking over a project which uses a Django > server. Unfortunately, the host machine used in the previous development > cycle went missing and I had to set up a new server. I am now having > problems loading data onto the database. I have a JSON file from dumpdata > on the now missing server. I am facing the error seen below: > > 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. However, clearing content type cache did not solve this problem. I > would be grateful if someone could assist me with this. 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+unsubscr...@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/412ca825-1d16-408f-8960-5d3731a0e765%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/412ca825-1d16-408f-8960-5d3731a0e765%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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+unsubscr...@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/CAEM6-QJGCk-PoT%3DMDhBrHwczThadn%2BTSihJYW5qQOQ-KOmEpOA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
