By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,777 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,777 IT Pros & Developers. It's quick & easy.

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

P: 2
We get the same error over and over again.

Expand|Select|Wrap|Line Numbers
  1. /usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py IN execute
  2.  
  3. 52. return self.cursor.execute(query, args)
  4.  
  5. Local vars
  6. Varialbe Value
  7. 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)'
  8.  
  9. self <django.db.backends.postgresql_psycopg2.base.CursorWrapper object at 0x3d1d510>
  10. args (u'9901AT',)
  11. e
  12. 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
Apr 25 '13 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,366
It's saying that there is no credentials_postcode location field.

It may be because your use of single and double quotes is inconsistent, I would check that first.
Apr 25 '13 #2

P: 2
Thanks I will check that first.
Apr 29 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.