Presuming you are only running the one web application on the server,
do things improve it you add directive:
PythonInterpreter main_interpreter
to Apache configuration.
If it doesn't, not the same issue as pyscopg2.
Graham
On Apr 25, 9:13 pm, Newt <strejda.n...@gmail.com> wrote:
> I'm running it as mod_python on Ubuntu 8.04 server. I connect to
> external MSSQL server thru django-pyodbc, the only thing I had to
> install manually was the pyodbc, the rest was installed using package
> manager (unix-odbc, freetds). I'm not much a server admin and it was a
> few months ago.
>
> Ales
>
> On Apr 25, 12:40 pm, Graham Dumpleton <graham.dumple...@gmail.com>
> wrote:
>
> > On Apr 25, 12:37 am, Newt <strejda.n...@gmail.com> wrote:
>
> > > Hello,
>
> > > in my latest application I have models with like 15 Decimal fields,
> > > with different decimal places.
>
> > > when I try to save an object of that model, I get sometimes (often,
> > > but not always) this error:
>
> > > File "/home/newt/django/1.0/sites/cdms/item/views.py", line 1054, in
> > > item_copy
> > > object.save()
>
> > > File "/home/newt/django/1.0/lib/django/db/models/base.py", line 311,
> > > in save
>
> > > File "/home/newt/django/1.0/lib/django/db/models/base.py", line 371,
> > > in save_base
>
> > > File "/home/newt/django/1.0/lib/django/db/models/fields/
> > > __init__.py", line 192, in get_db_prep_save
>
> > > File "/home/newt/django/1.0/lib/django/db/models/fields/
> > > __init__.py", line 609, in get_db_prep_value
>
> > > File "/home/newt/django/1.0/lib/django/db/models/fields/
> > > __init__.py", line 583, in to_python
>
> > > File "/usr/lib/python2.5/decimal.py", line 650, in __new__
> > > raise TypeError("Cannot convert %r to Decimal" % value)
>
> > > TypeError: Cannot convert Decimal("0.0000") to Decimal
>
> > > It fails on the first decimal field (at it's only one with 4 decimal
> > > places) and it just happens sometimes.
> > > I remember something like that used to happen with psycopg2 some year
> > > ago.
>
> > The psycopg2 problem was because the C extension module which is a
> > part of it wasn't implemented correctly so as to work in a Python sub
> > interpreter. The problems with that would only manifest when using
> > mod_python or mod_wsgi and application running in sub interpreter and
> > not main interpreter.
>
> > So, to start with, how are you hosting this application?
>
> > Graham
>
> > > I think it breaks when it tries to get the data ready for the SQL
> > > statement.
>
> > > In this project I have to use django-pyodbc connector to MSSQL
> > > database.
>
> > > I have tried both 1.02 and 1.1b branches of the connector with same
> > > errorous results.
>
> > > It's the most frustrating bug in django so far, as I'm completely
> > > helpless and even google's silent about this.
>
> > > Please does anyone know what's causing this, or how to get rid of
> > > it...
>
> > > thanks,
>
> > > Ales
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
