Reconcile Entries
Created originally on Bitbucket by Anonymous
In the database numergy_test copied the 10th october 2013, i get this error when trying to reconcile all entries from Bouabache Fatiha :
#!shell
2013-10-10 15:20:30,051 19191 INFO numergy_test werkzeug: 127.0.0.1 - - [10/Oct/2013 15:20:30] "POST /web/dataset/call_kw/account.move.line.reconcile:fields_view_get HTTP/1.1" 200 -
2013-10-10 15:20:30,214 19191 INFO numergy_test werkzeug: 127.0.0.1 - - [10/Oct/2013 15:20:30] "POST /web/dataset/call_kw/account.move.line.reconcile:default_get HTTP/1.1" 200 -
2013-10-10 15:20:31,131 19191 INFO numergy_test werkzeug: 127.0.0.1 - - [10/Oct/2013 15:20:31] "POST /web/dataset/call_kw/account.move.line.reconcile:create HTTP/1.1" 200 -
2013-10-10 15:20:31,176 19191 INFO numergy_test werkzeug: 127.0.0.1 - - [10/Oct/2013 15:20:31] "POST /web/dataset/call_kw/account.move.line.reconcile:read HTTP/1.1" 200 -
2013-10-10 15:20:31,265 19191 ERROR numergy_test openerp.sql_db: Programming error: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT account_account."code",account_account."reconcile",account_account."t2_ctl",account_account."t3_ctl",account_account."user_type",account_account."currency_id",account_account."a1_id",account_account."note",account_account."a2_id",account_account."company_id",account_account."shortcut",account_account."parent_id",account_account."type",account_account."t4_ctl",account_account."a3_id",account_account."a4_id",account_account."active",account_account."a5_id",account_account."t5_ctl",account_account."parent_right",account_account."name",account_account."level",account_account."parent_left",account_account."t1_ctl",account_account."currency_mode",account_account.id FROM "account_account" WHERE account_account.id IN %s ORDER BY code
2013-10-10 15:20:31,266 19191 ERROR numergy_test openerp.osv.osv: Uncaught exception
Traceback (most recent call last):
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/alorimier/progs/openerp/sources/additionnal_addons/account_streamline/wizard/account_reconcile.py", line 116, in trans_rec_reconcile_full
return super(account_move_line_reconcile, self).trans_rec_reconcile_full(cr, uid, ids, context=context)
File "/home/alorimier/progs/openerp/sources/openobject-addons/account/wizard/account_reconcile.py", line 92, in trans_rec_reconcile_full
period_id, journal_id, context=context)
File "/home/alorimier/progs/openerp/sources/openobject-addons/hr_expense/hr_expense.py", line 463, in reconcile
res = super(account_move_line, self).reconcile(cr, uid, ids, type=type, writeoff_acc_id=writeoff_acc_id, writeoff_period_id=writeoff_period_id, writeoff_journal_id=writeoff_journal_id, context=context)
File "/home/alorimier/progs/openerp/sources/additionnal_addons/account_streamline/account_move_line.py", line 532, in reconcile
company_currency = account.company_id.currency_id
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 484, in __getattr__
return self[name]
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 399, in __getitem__
field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 3605, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 3657, in _read_flat
cr.execute(query, [tuple(sub_ids)] + rule_params)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/sql_db.py", line 226, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2013-10-10 15:20:31,269 19191 ERROR numergy_test openerp.netsvc: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Traceback (most recent call last):
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/netsvc.py", line 292, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/service/web_services.py", line 626, in dispatch
res = fn(db, uid, *params)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/alorimier/progs/openerp/sources/additionnal_addons/account_streamline/wizard/account_reconcile.py", line 116, in trans_rec_reconcile_full
return super(account_move_line_reconcile, self).trans_rec_reconcile_full(cr, uid, ids, context=context)
File "/home/alorimier/progs/openerp/sources/openobject-addons/account/wizard/account_reconcile.py", line 92, in trans_rec_reconcile_full
period_id, journal_id, context=context)
File "/home/alorimier/progs/openerp/sources/openobject-addons/hr_expense/hr_expense.py", line 463, in reconcile
res = super(account_move_line, self).reconcile(cr, uid, ids, type=type, writeoff_acc_id=writeoff_acc_id, writeoff_period_id=writeoff_period_id, writeoff_journal_id=writeoff_journal_id, context=context)
File "/home/alorimier/progs/openerp/sources/additionnal_addons/account_streamline/account_move_line.py", line 532, in reconcile
company_currency = account.company_id.currency_id
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 484, in __getattr__
return self[name]
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 399, in __getitem__
field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 3605, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/osv/orm.py", line 3657, in _read_flat
cr.execute(query, [tuple(sub_ids)] + rule_params)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
File "/home/alorimier/progs/openerp/sources/openobject-server/openerp/sql_db.py", line 226, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2013-10-10 15:20:31,273 19191 INFO numergy_test werkzeug: 127.0.0.1 - - [10/Oct/2013 15:20:31] "POST /web/dataset/call_button HTTP/1.1" 200 -