id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 4231 manage.py loaddata problem if app name is Capitalised Mark Jarecki Russell Keith-Magee "System: Apache2.2.4, mod_python3.3.1, Python-2.5.1, postgresql-8.2.4, psycopg2-2.0.5.1, latest django version. Models: {{{ class VenueType(models.Model): venueTypeName = models.CharField(maxlength=200, db_index=True) venueTypeSlug = models.SlugField(prepopulate_from= ('venueTypeName',), db_index=True) class Admin: pass class Venue(models.Model): venueSlug = models.SlugField(prepopulate_from=('venueName',), unique=True, db_index=True) venueType = models.ManyToManyField(VenueType, filter_interface=models.HORIZONTAL) }}} Process: {{{ ./manage.py dumpdata --format=json Guide > guide.json [Clear database] ./manage.py syncdb ./manage.py loaddata guide.json }}} Error: {{{ Loading 'test' fixtures... Installing json fixture 'test' from absolute path. Installed 1 object(s) from 1 fixture(s) Traceback (most recent call last): File ""./manage.py"", line 11, in execute_manager(settings) File ""/opt/python/lib/python2.5/site-packages/django/core/ management.py"", line 1674, in execute_manager execute_from_command_line(action_mapping, argv) File ""/opt/python/lib/python2.5/site-packages/django/core/ management.py"", line 1588, in execute_from_command_line action_mapping[action](args[1:], int(options.verbosity)) File ""/opt/python/lib/python2.5/site-packages/django/core/ management.py"", line 1418, in load_data cursor.execute(line) File ""/opt/python/lib/python2.5/site-packages/django/db/backends/ util.py"", line 12, in execute return self.cursor.execute(sql, params) File ""/opt/python/lib/python2.5/site-packages/django/db/backends/ postgresql/base.py"", line 44, in execute return self.cursor.execute(sql, [smart_basestring(p, self.charset) for p in params]) psycopg.ProgrammingError: ERROR: relation ""guide_venuetype_id_seq"" does not exist SELECT setval('Guide_venuetype_id_seq', (SELECT max(""id"") FROM ""Guide_venuetype"")); }}} Test file: {{{ [{""pk"": ""1"", ""model"": ""Guide.venuetype"", ""fields"": {""venueTypeSlug"": ""stadium"", ""venueTypeName"": ""Stadium""}}] }}} ./manage.py sqlall Guide output: {{{ BEGIN; CREATE TABLE ""Guide_venuetype"" ( ""id"" serial NOT NULL PRIMARY KEY, ""venueTypeName"" varchar(200) NOT NULL, ""venueTypeSlug"" varchar(50) NOT NULL ); CREATE TABLE ""Guide_venue"" ( ""id"" serial NOT NULL PRIMARY KEY, ""venueName"" varchar(200) NOT NULL, ""venueSlug"" varchar(50) NOT NULL UNIQUE ); CREATE TABLE ""Guide_venue_venueType"" ( ""id"" serial NOT NULL PRIMARY KEY, ""venue_id"" integer NOT NULL REFERENCES ""Guide_venue"" (""id"") DEFERRABLE INITIALLY DEFERRED, ""venuetype_id"" integer NOT NULL REFERENCES ""Guide_venuetype"" (""id"") DEFERRABLE INITIALLY DEFERRED, UNIQUE (""venue_id"", ""venuetype_id"") ); CREATE INDEX ""Guide_venuetype_venueTypeName"" ON ""Guide_venuetype"" (""venueTypeName""); CREATE INDEX ""Guide_venuetype_venueTypeSlug"" ON ""Guide_venuetype"" (""venueTypeSlug""); CREATE INDEX ""Guide_venue_venueName"" ON ""Guide_venue"" (""venueName""); CREATE UNIQUE INDEX ""Guide_venue_venueSlug"" ON ""Guide_venue"" (""venueSlug""); COMMIT; }}} Link to Google Groups Django Users Discoussion: [http://groups.google.com/group/django-users/browse_thread/thread/56728d3bfd791639/3664b7e423ed8b43#3664b7e423ed8b43 Loaddata-issue] I hope this is enough information. " closed Core (Serialization) dev fixed loaddata Accepted 0 0 0 0 0 0