"integer = boolean" error due to NULL name of ir_act_window

Bug #747422 reported by LudoRA
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Server (MOVED TO GITHUB)
Confirmed
Undecided
OpenERP Publisher's Warranty Team

Bug Description

There are few ir_ui_window 'name that haven't a real name. By default, the field is '' value.

But, when you modify this kind of window action, the name is replace by a NULL value.

If you try to dump and retore your database, when you try to connect with webclient, this error appear:

<code>
Traceback (most recent call last):
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/netsvc.py", line 299, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/netsvc.py", line 77, in __call__
    return getattr(self, method)(*params)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/service/web_services.py", line 577, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/osv/orm.py", line 2229, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/osv/orm.py", line 2302, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/lchevalier/Programmes/openerp-server-5.0.15/bin/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR: l'opérateur n'existe pas : integer = boolean
LIGNE 1 : SELECT "type",id FROM "ir_actions" WHERE id in (false) ORDER...
                                                      ^
ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
</code>

And the ir_act_window table is empty after the restaure.

Revision history for this message
Azazahmed Saiyed (OpenERP) (saz-openerp) wrote :

Hello,

The traceback suggested that you are using the stable 5 version. So i have tested it with that version but did not find any record of ir_act_window without the name.

Please give me the information which modules have been installed at your end. I have checked it with the sale module installation.

Waiting for your reply.

Thanks.

Revision history for this message
LudoRA (tenshi20) wrote :

OK

I'm using membership module from the 5.0.15 version.

The object that haven't any name are: report.partner_member.year and report.partner_member.year_new

Revision history for this message
Azazahmed Saiyed (OpenERP) (saz-openerp) wrote :

Hello,

Thanks for the reply! Now I did get the same problem at my end.

Thanks.

Changed in openobject-server:
assignee: nobody → OpenERP Publisher's Warranty Team (openerp-opw)
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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