psycopg2.DataError: invalid input syntax

[omar ahmed]

i am getting this error :
psycopg2.DataError: invalid input syntax
what is the solution ?

-- 
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/2157b59e-ec8a-4fe4-a4d9-8b9e030c79a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: psycopg2.DataError

[Tom Evans]

On Tue, Oct 30, 2012 at 6:06 AM, jondbaker <jonathandavidba...@gmail.com> wrote:
> When I run 'python manage.py validate' the following error is returned:
>
> psycopg2.DataError: invalid value for parameter "TimeZone": "UTC"
>
> settings.py
> TIME_ZONE = 'America/Denver'
> USE_TZ = True
>
> I'm using Django 1.4.2 with Postgres 9.1/PostGIS on OSX.
>
> To test, I went back and commented out my custom apps in INSTALLED_APPS, but
> the error is still there. If I set USE_TZ to False, then the error becomes:
> psycopg2.DataError: invalid value for parameter "TimeZone": "America/Denver"
>

Postgres uses your OS's zoneinfo information, which for some reason is
missing on your OS X install.

You would probably have more luck getting an explanation on the
postrgresql mailing lists. To reproduce without django, open a
database shell ("python manage.py dbshell" is an easy way) and type in
"SET TIME ZONE 'UTC';".

Cheers

Tom

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

psycopg2.DataError

[jondbaker]

When I run 'python manage.py validate' the following error is returned:

*psycopg2.DataError: invalid value for parameter "TimeZone": "UTC"*
*
*
settings.py
TIME_ZONE = 'America/Denver'
USE_TZ = True

I'm using Django 1.4.2 with Postgres 9.1/PostGIS on OSX.

To test, I went back and commented out my custom apps in INSTALLED_APPS, 
but the error is still there. If I set USE_TZ to False, then the error 
becomes:
*psycopg2.DataError: invalid value for parameter "TimeZone": 
"America/Denver"*

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/django-users/-/zi-34uY9WKMJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.