openerp-india team mailing list archive

[Eric <eric@xxxxxxxxxxxxxxx>]

It looks like in view_header_get in account_move_line.py,
context['period_id'] is returning a date (string) and not an id
(integer) like it should be.

It's a band aid fix, but changing

cr.execute('SELECT code FROM account_period WHERE id = %s',
(context['period_id'], ))

to

cr.execute('SELECT code FROM account_period WHERE code = %s',
(context['period_id'], ))

seems to make it behave as intended for now.

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/943359

Title:
  Error on view journal items

Status in OpenERP Server:
  Confirmed

Bug description:
  error when viewing journal items in 6.1

  
  Client Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\common\http.py", line 180, in dispatch
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\controllers\main.py", line 1163, in load
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\controllers\main.py", line 1045, in fields_view_get
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\common\openerplib\main.py", line 250, in proxy
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\common\openerplib\main.py", line 117, in proxy
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\common\http.py", line 611, in send

  
  Server Traceback (most recent call last):
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\web\common\http.py", line 592, in send
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\netsvc.py", line 360, in dispatch_rpc
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\service\web_services.py", line 572, in dispatch
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\osv.py", line 167, in execute_kw
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\osv.py", line 121, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\osv.py", line 176, in execute
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\osv.py", line 164, in execute_cr
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\account\account_move_line.py", line 967, in fields_view_get
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\orm.py", line 2149, in fields_view_get
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\orm.py", line 1789, in __view_look_dom_arch
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\osv\orm.py", line 1695, in __view_look_dom
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\openerp\addons\account\account_move_line.py", line 930, in view_header_get
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\sql_db.py", line 152, in wrapper
    File "C:\Program Files\OpenERP 6.1-20120229-003254\server\.\openerp\sql_db.py", line 212, in execute
  DataError: invalid input syntax for integer: "02/2012"

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/943359/+subscriptions