Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4 Odpovědi
12848 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Autor

I have removed addon

Nejlepší odpověď

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

Avatar
Zrušit
Nejlepší odpověď

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
Zrušit
Autor Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
kvě 22
34491
0
bře 19
4388
0
led 19
5483
4
úno 24
12776
0
led 18
4268