[Health-dev] [bug #40721] Query error when executing appointment report

[Mario Puntin]

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/