473,414 Members | 2,030 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

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

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
2 2620
Rabbit
12,516 Expert Mod 8TB
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
Thanks I will check that first.
Apr 29 '13 #3

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

Similar topics

1
by: Lukelrc | last post by:
Hi, I have a form containing (among other things) date fields for which i have a date validation script. What i need to happen is when the user presses the submit button the date validation...
2
by: Michael | last post by:
I have to do a data migration for a client. The following conversion is required. Task: - MOVEMENT table with 7,000,000 records, each has a location code - Location code has changed; I have a...
5
by: David Webb | last post by:
The problem started when the Working Folder for a project was somehow set to the folder of another project. I set the correct working folder in VSS and deleted the .vbproj files that had been...
8
by: Phil Powell | last post by:
if (document.location.href.indexOf('?') >= 0) document.location.href = document.location.href.substring(0, document.location.href.indexOf('?')); if (document.location.href.indexOf('#') >= 0) {...
19
by: Darren | last post by:
I have a page that opens a popup window and within the window, some databse info is submitted and the window closes. It then refreshes the original window using window.opener.location.reload(). ...
0
by: Dirk Försterling | last post by:
Hi all, a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following the instructions in the INSTALL file, including dump and restore. All this worked fine without any error (message). ...
1
by: Frans | last post by:
When opening a .Net solution in Visual Studio 2003, a message appears asking to set the location of the working copy of the WebUI project. Whatever I try, the path is not accepted. The message that...
1
by: DBC User | last post by:
Hi, I have a program sitting in the network, when I double click the program, first thing I want to do is find the application execution path. I am using the following code Assembly...
2
by: whethergirl | last post by:
I have a Main report in my database with two Subreports ("Level" and "Quality"). Each (sub)report is based on a different query, but all queries include the same field ("Location") from the same...
2
by: Richard Ballin | last post by:
Hello All, I am taking a class using Visual Studio C++ Express 2010 and on one of the first projects i need to use the Math::Pow() function. The book does not do a good job of explaining how to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.