c2c-oerpscenario team mailing list archive

["DBR \(OpenERP\)" <dbr@xxxxxxxxxxx>]

Public bug reported:

Following are the steps to reproduce the bug:

Open from Account/Customers/Journal Items

Traceback (most recent call last):
  File "/home/dbr/workspace_main/openobject-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/dbr/workspace_main/openobject-server/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/dbr/workspace_main/openobject-addons/account/account_move_line.py", line 855, in fields_view_get
    result = super(osv.osv, self).fields_view_get(cr, uid, view_id, view_type, context, toolbar=toolbar, submenu=submenu)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1748, in fields_view_get
    xarch, xfields = self.__view_look_dom_arch(cr, user, result['arch'], view_id, context=context)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1439, in __view_look_dom_arch
    fields_def = self.__view_look_dom(cr, user, node, view_id, context=context)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1379, in __view_look_dom
    result = self.view_header_get(cr, user, False, node.tag, context)
  File "/home/dbr/workspace_main/openobject-addons/account/account_move_line.py", line 822, in view_header_get
    cr.execute('SELECT code FROM account_period WHERE id = %s', (context['period_id'], ))
  File "/home/dbr/workspace_main/openobject-server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/dbr/workspace_main/openobject-server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "12/2010"
LINE 1: SELECT code FROM account_period WHERE id = E'12/2010'
                                                   ^

** Affects: openobject-client-web
     Importance: Medium
     Assignee: OpenERP SA's Web Client R&D (openerp-dev-web)
         Status: Confirmed

** Changed in: openobject-client-web
   Importance: Undecided => Medium

** Changed in: openobject-client-web
       Status: New => Confirmed

** Changed in: openobject-client-web
     Assignee: (unassigned) => OpenERP SA's Web Client R&D (openerp-dev-web)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/688454

Title:
  Unable to open Journal Items

Status in OpenObject Web Client:
  Confirmed

Bug description:
  Following are the steps to reproduce the bug:

Open from Account/Customers/Journal Items 

Traceback (most recent call last):
  File "/home/dbr/workspace_main/openobject-server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/dbr/workspace_main/openobject-server/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/dbr/workspace_main/openobject-addons/account/account_move_line.py", line 855, in fields_view_get
    result = super(osv.osv, self).fields_view_get(cr, uid, view_id, view_type, context, toolbar=toolbar, submenu=submenu)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1748, in fields_view_get
    xarch, xfields = self.__view_look_dom_arch(cr, user, result['arch'], view_id, context=context)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1439, in __view_look_dom_arch
    fields_def = self.__view_look_dom(cr, user, node, view_id, context=context)
  File "/home/dbr/workspace_main/openobject-server/bin/osv/orm.py", line 1379, in __view_look_dom
    result = self.view_header_get(cr, user, False, node.tag, context)
  File "/home/dbr/workspace_main/openobject-addons/account/account_move_line.py", line 822, in view_header_get
    cr.execute('SELECT code FROM account_period WHERE id = %s', (context['period_id'], ))
  File "/home/dbr/workspace_main/openobject-server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/dbr/workspace_main/openobject-server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "12/2010"
LINE 1: SELECT code FROM account_period WHERE id = E'12/2010'
                                                   ^