psycopg2.DataError: invalid input syntax
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
On Tue, Oct 30, 2012 at 6:06 AM, jondbaker 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
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.