ProgrammingError('column credentials_postcode location does not exist\nLINE 1

[postcode]

We get the same error over and over again.

/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py IN execute

52. return self.cursor.execute(query, args)

Local vars
Varialbe Value
query    'Select "credentials_postcode"."id", "credentials_postcode". 'site_id", "credentials_postcode"."code", "credentials_postcode"."latiture","credentials_postcode"."logitude", "credentials_postcode".location". "credentials_postcode"."service", "credentials_postcode"."date_added", "credentials_postcode". "date_modified" FROM "credentials_postcode WHERE UPPER ("credentials_postcode"."code"::text) = UPPER(%s)'

self <django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x3d1d510>
args (u'9901AT',)
e
ProgrammingError('column credentials_postcode.location does not exist\nLINE 1:..."."latitude", "credentials_postcode"."longitude", "credentia...\n^\',)

Postcode means zippcode. What do we need to do?

Thanks in advance,
Regards

[Rabbit]

It's saying that there is no credentials_pos tcode location field.

It may be because your use of single and double quotes is inconsistent, I would check that first.

[postcode]

Thanks I will check that first.