traceback in hr dashboard after installing hr_timesheet_sheet

Bug #900700 reported by Aline (OpenERP)
26
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP R&D Addons Team 3

Bug Description

[niv] The bug was reported to only appear in some versions of Ubuntu

web, chome, trunk,

install hr_timesheet_sheet

go to Human Resource dashboard :

[2011-12-06 11:17:27,818][?] INFO:werkzeug:127.0.0.1 - - [06/Dec/2011 11:17:27] "POST /web/session/eval_domain_and_context HTTP/1.1" 200 -
[2011-12-06 11:17:27,848][?] ERROR:db.cursor:bad query: SELECT ir_actions."type",ir_actions.id FROM "ir_actions" WHERE ir_actions.id IN %s ORDER BY name
Traceback (most recent call last):
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
  File "/usr/lib/python2.6/dist-packages/psycopg2/extensions.py", line 124, in getquoted
    qobjs = [str(o.getquoted()) for o in pobjs]
AttributeError: 'str' object has no attribute 'getquoted'
[2011-12-06 11:17:27,848][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/source/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/source/server/trunk/openerp/osv/orm.py", line 3345, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/aline/source/server/trunk/openerp/osv/orm.py", line 3404, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/aline/source/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
  File "/usr/lib/python2.6/dist-packages/psycopg2/extensions.py", line 124, in getquoted
    qobjs = [str(o.getquoted()) for o in pobjs]
AttributeError: 'str' object has no attribute 'getquoted'

Related branches

Changed in openerp-web:
importance: Undecided → High
status: New → Confirmed
assignee: nobody → OpenERP R&D Web Team (openerp-dev-web)
Revision history for this message
Xavier (Open ERP) (xmo-deactivatedaccount) wrote :

Could not reproduce issue:
* Created new database
* Installed HR and hr_timesheet_sheet via "Add more Features" wizard
* Clicked on HR menu, no problem
* Logged out and back in, tried again, still no problem.

Changed in openerp-web:
status: Confirmed → Invalid
Revision history for this message
Purnendu Singh (OpenERP) (purnendu-singh) wrote :

Hello,

I think the problem is with version of ubuntu which is less than 11.10!!!

My ubuntu version is 11.04 and i tested it in 11.10 also where i am not getting this issue!!

* Created new database in Ubuntu 11.04
* Installed hr module and click on "Human Resources" Menu, I am getting this trace back.
* Now istalled hr_evaluation module error is solve.

This may be happening b'coz we are not passing any action in hr/hr_board.xml

    <record id="board_hr_form" model="ir.ui.view">
        <field name="name">board.hr.form</field>
        <field name="model">board.board</field>
        <field name="type">form</field>
        <field name="arch" type="xml">
            <form string="My Board" layout="manual">
                <board style="2-1">
                    <column/>
                    <column/>
                </board>
            </form>
        </field>
    </record>

Thanks,
Purnendu singh

Revision history for this message
Amit Parik (amit-parik) wrote :

Hello Purnendu,

Thanks for remind this,

It's also reproduced at my end,on 10.04.

Changed in openerp-web:
status: Invalid → New
importance: High → Undecided
assignee: OpenERP R&D Web Team (openerp-dev-web) → nobody
Changed in openerp-web:
status: New → Confirmed
importance: Undecided → Medium
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
Changed in openerp-web:
status: Confirmed → In Progress
Revision history for this message
DJ Patel (OpenERP) (mdi-openerp) wrote :

Hello Aline,

Thanks for reporting. The solution for this bug is proposed in the branch : https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-900700-mdi/

with following Revision ID and Number.

Revision ID : <email address hidden>
Revision Number : 6778

Thanks,
Divyesh

Changed in openerp-web:
status: In Progress → Fix Committed
Revision history for this message
Thibault Delavallée (OpenERP) (tde-openerp) wrote :

Hello,

The fix did not solve the issue. Another iteration will be necessary !

Best regards,

Thibault.

Changed in openerp-web:
status: Fix Committed → In Progress
description: updated
Revision history for this message
Nicolas Vanhoren (OpenERP) (niv-openerp) wrote :

Don't know why it was in web client while assigned to addons team.

Changed in openerp-web:
status: In Progress → Confirmed
affects: openerp-web → openobject-addons
Changed in openobject-addons:
status: Confirmed → In Progress
Revision history for this message
Saurang Suthar(OpenERP) (ssu-openerp) wrote :

Hello Aline,

I have fixed the problem in lp:~openerp-dev/openobject-addons/trunk-bug-900700-ssu branch, It will be merged soon in lp:openobject-addons.

Revision No: 6968
Revision ID: help-20120702085852-df1i9neevc9g2m1c

Thanks
Saurang Suthar

Changed in openobject-addons:
status: In Progress → Fix Committed
Revision history for this message
Hardik Sanchawat (OpenERP) (hsa-openerp) wrote :

Hello,

I have tested this issue with latest trunk on runbot with following revision numbers but it can't be reproduced :
server (4516)
addons (7893)
web (3328)

Thank you.
HSA

Revision history for this message
Arnaud Pineux (OpenERP) (api-openerp) wrote :

Hello I can't reproduce the bug either.
server (4556)
addons (8022)
web (3399)

Good luck,

Pineux Arnaud

Changed in openobject-addons:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.