Tagged Questions

61
votes
9answers
29k views

DatabaseError: current transaction is aborted, commands ignored until end of transaction block

I got a lot of "DatabaseError: current transaction is aborted, commands ignored until end of transaction block" errors after changed from python-psycopg to python-psycopg2 as Django project's database ...
14
votes
1answer
11k views

Use Django ORM as standalone [duplicate]

Possible Duplicates: Use only some parts of Django? Using only the DB part of Django I want to use the Django ORM as standalone. Despite an hour of searching Google, I'm still left with ...
19
votes
4answers
1k views

Migrating existing auth.User data to new Django 1.5 custom user model?

I'd prefer not to destroy all the users on my site. But I want to take advantage of Django 1.5's custom pluggable user model. Here's my new user model: class SiteUser(AbstractUser): site = ...
26
votes
9answers
7k views

MySQL vs PostgreSQL? Which should I choose for my Django project?

My Django project is going to be backed by a large database with several hundred thousand entries, and will need to support searching (I'll probably end up using djangosearch or a similar project.) ...
9
votes
1answer
3k views

How to debug: Internal Error current transaction is aborted, commands ignored until end of transaction block

Hi Stackoverflow people, I do my first steps with GeoDjango and I am looking for better options to check faulty sql statements. So far, I simply wanted to safe a lng+lat point in my postgresql ...
10
votes
7answers
2k views

Postgresql socket error on OSX 10.7.3 when running Django's syncdb

Since upgrading OSX to version 10.7.3, when I attempt to run a Django "syncdb" command, I receive the following psycopg2 error from Postgresql 8.4.2: psycopg2.OperationalError: could not connect to ...
4
votes
3answers
2k views

Django cache.set() causing duplicate key error

My Django site recently started throwing errors from my caching code and I can't figure out why... I call: from django.core.cache import cache cache.set('blogentry', some_value) And the error ...
10
votes
4answers
2k views

How to map PostgreSQL array field in Django ORM

I have an array field in my PostrgreSQL database of type text. Is there a way to map this into a Django model ?
2
votes
1answer
402 views

Optimizing performance of Postgresql database writes in Django?

I've got a Django 1.1 app that needs to import data from some big json files on a daily basis. To give an idea, one of these files is over 100 Mb and has 90K entries that are imported to a Postgresql ...
13
votes
4answers
26k views

How to setup PostgreSQL Database in Django?

I'm new to Python and Django. I'm configuring a Django project using PostgreSQL database engine backend, But I'm getting errors on each database operations, for example when i run manage.py syncdb, ...
7
votes
5answers
2k views

Deploying Django to Heroku (Psycopg2 Error)

So I'm following the getting started guide from heroku with django. However when I run this command: heroku run python manage.py syncdb I get this error psycopg2.OperationalError: could not ...
5
votes
4answers
2k views

Django fixture fails, stating “DatabaseError: value too long for type character varying(50)”

I have a fixture (json) which loads in development environment but fails to do so in server environment. The error says: "DatabaseError: value too long for type character varying(50)" My development ...
6
votes
1answer
723 views

Postgres sequences without an 'owned by' attribute do not return an id in Django 1.3

After a recent migration from Oracle to Postgres and an upgrade from Django 1.2 to 1.3, we began having problems when saving objects to our database. When save() is called no id is returned, this ...
5
votes
2answers
995 views

Django: permission denied when trying to access database after restore (migration)

I have a django 1.4 app with a populated postgres 9.1 database in development server locally. After successful deployment, I wanted to move the data from local to online database, so I used: pg_dump ...
0
votes
1answer
219 views

Horizontally scale Django Application with single Database server

I have a Python/Django Application where we want to horizontal scale based on load. Once scaled up, we will have multiple Django servers (running on different VMs) and single postgreSQL server. How ...

1 2 3 4 5
15 30 50 per page