[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Health-dev] [bug #40721] Query error when executing appointment report
From: |
Mario Puntin |
Subject: |
[Health-dev] [bug #40721] Query error when executing appointment report |
Date: |
Wed, 27 Nov 2013 12:08:47 +0000 |
User-agent: |
Mozilla/5.0 (X11; Linux i686; rv:25.0) Gecko/20100101 Firefox/25.0 |
URL:
<http://savannah.gnu.org/bugs/?40721>
Summary: Query error when executing appointment report
Project: GNU Health
Submitted by: mariomop
Submitted on: mié 27 nov 2013 09:08:46 ART
Category: Functionality
Severity: 3 - Normal
Item Group: None
Status: None
Privacy: Public
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Release: None
Module: health
_______________________________________________________
Details:
I'm getting the following when running an appoinment report:
ERROR:tryton.common.common:Traceback (most recent call last):
File "/trytond/protocols/jsonrpc.py", line 123, in _marshaled_dispatch
response['result'] = dispatch_method(method, params)
File "/trytond/protocols/jsonrpc.py", line 156, in _dispatch
res = dispatch(*args)
File "/trytond/protocols/dispatcher.py", line 158, in dispatch
result = rpc.result(meth(*args, **kwargs))
File "/trytond/model/modelsql.py", line 1095, in search
cursor.execute(query_str, tables_args + qu2)
File "/trytond/backend/postgresql/database.py", line 306, in execute
res = self.cursor.execute(sql, params)
DataError: la sintaxis de entrada no es válida para integer: «2013-11-26»
LINE 1: ...ent_date >= '2013-11-26' AND a.appointment_date < '2013-11-2...
la sintaxis de entrada no es válida para integer: «2013-11-26»
LINE 1: ...ent_date >= '2013-11-26' AND a.appointment_date < '2013-11-2...
^
To solve it I applied this change in health/health.py, line 1734
--- "a.appointment_date < %s + integer '1' "
+++ "a.appointment_date < date %s + integer '1' "
_______________________________________________________
Reply to this item at:
<http://savannah.gnu.org/bugs/?40721>
_______________________________________________
Mensaje enviado vía/por Savannah
http://savannah.gnu.org/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Health-dev] [bug #40721] Query error when executing appointment report,
Mario Puntin <=