manage.py syncdb error, postgres_psycopg2

Question

I'm trying to install a shopping cart plugin for django but having a problem when I run manage.py syncdb.

When run, it installs 4 tables, then I'm getting the following error message:

File "(mypath)/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute return self.cursor.execute(query, args) django.db.utils.DatabaseError: NUMERIC scale 127 must be between 0 and precision 10

I'm guessing that there is most likely a problem with the models.py but I don't know what line to look at.

has anyone ever run into anything similar?

Let use know what fields the models.py defined in the shopping cart application. Perhaps whoever wrote that never tried running it on a PostgreSQL. — Peter Bengtsson
– Peter Bengtsson, Commented Sep 24, 2010 at 13:56

Magnus Hagander · Accepted Answer · 2010-09-22 21:32:54Z

1

Sounds like you have a numeric field with an invalid scale defined. Did you perhaps mix up scale and precision?

answered Sep 22, 2010 at 21:32

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

manage.py syncdb error, postgres_psycopg2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related