This question has been flagged
4 Replies
11370 Views
openerp7
Avatar
Gratien HOUNDAKO

Hi please tell me how to fix this error:


Server Traceback (most recent call last):

File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send

return openerp.netsvc.dispatch_rpc(service_name, method, args)

File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc

result = ExportService.getService(service_name).dispatch(method, params)

File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch

res = fn(db, uid, *params)

File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw

return self.execute(db, uid, obj, method, *args, **kw or {})

File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper

return f(self, dbname, *args, **kwargs)

File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute

res = self.execute_cr(cr, uid, obj, method, *args, **kw)

File "/opt/openerp/server/openerp/addons/audittrail/audittrail.py", line 514, in execute_cr

return fct_src(cr, uid, model, method, *args, **kw)

File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr

return getattr(object, method)(cr, uid, *args, **kw)

File "/opt/openerp/server/openerp/osv/orm.py", line 3620, in read

result = self._read_flat(cr, user, select, fields, context, load)

File "/opt/openerp/server/openerp/osv/orm.py", line 3741, in _read_flat

res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)

File "/opt/openerp/server/openerp/osv/fields.py", line 1141, in get

result = self._fnct(obj, cr, uid, ids, name, self._arg, context)

File "/opt/openerp/server/openerp/addons/invoice_print_report_balance_payment/account_invoice.py", line 59, in _to_pay_get

context=context

File "/opt/openerp/server/openerp/addons/invoice_print_report_balance_payment/partner.py", line 44, in get_balance_at_date

cr.execute(sql)

File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper

return f(self, *args, **kwargs)

File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute

res = self._obj.execute(query, params)

DataError: invalid input syntax for type date: "False"

LINE 7: AND m.date <= 'False'

Avatar
Discard
Avatar
Gerhard Baumgartner
Best Answer

LINE 7: AND m.date <= 'False'

Line 7 does not mean Line 7 in a file. This is an error your database is throwing.

The faulty query should be somewhere near

invoice_print_report_balance_payment/partner.py", line 44, in get_balance_at_date

I assume you're trying to make sure that the date is not empty, because odoo usually translates an empty field to False. 

In this case change the query to AND m.date IS NOT NULL



Avatar
Discard
Gratien HOUNDAKO
Author

I have removed addon

Avatar
John Touba
Best Answer

 if you want test, if your date is not empty . you just write "and m.date" .

Avatar
Discard
Avatar
Gülhan Celik
Best Answer

Hi Gratien,

- you can test the type of the attribute eg. >> if type(m.date) == 'date' and m.date <= ...

- you can also test if the attribute is not empty eg. >> if m.date (if m.date == True) and m.date <= ...

Avatar
Discard
Avatar
Gratien HOUNDAKO
Author Best Answer

Hello,

My problem is still not resolved.

In fact I do not know where to correct. I do not master well traceback

LINE 7: AND m.date &lt;= 'False

LINE 7 of which file

Thk.

Avatar
Discard