openerp-india team mailing list archive

[Navrang Oza <oza.navrang@xxxxxxxxx>]

Public bug reported:

Hello,

I have just pulled my addons, revno: 8404
server: 8711.

I removed all *.pyc files, and created new database and its not allow me
to login.

Can anyone check it ?

Please find below mentioned traceback.

2012-12-19 11:21:01,501 9516 INFO postgres werkzeug: 127.0.0.1 - - [19/Dec/2012 11:21:01] "POST /web/database/get_list HTTP/1.1" 200 -
2012-12-19 11:21:01,534 9516 ERROR ? openerp.sql_db: Programming error: operator does not exist: integer = boolean
LINE 1: ...up_id)  WHERE m.model = 'res.users'    AND gu.uid = false   ...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END)   FROM ir_model_access a   JOIN ir_model m ON (m.id = a.model_id)   JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)  WHERE m.model = %s    AND gu.uid = %s    AND a.active IS True 
2012-12-19 11:21:01,535 9516 ERROR ? openerp.addons.web.http.HttpRequest.dispatch: An error occurred while handling a json request
Traceback (most recent call last):
  File "/home/navrang/workspace/trunk_test/web-trunk/addons/web/http.py", line 276, in dispatch
    r = method(self, **self.params)
  File "/home/navrang/workspace/trunk_test/web-trunk/addons/web/controllers/main.py", line 1334, in company_logo
    if user.company_id.logo_web:
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 484, in __getattr__
    return self[name]
  File "/home/navrang/workspace/trunk_test/server-trunk/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/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/res/res_users.py", line 793, in read
    res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/res/res_users.py", line 268, in read
    result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 3599, in read
    self.check_access_rights(cr, user, 'read')
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 3880, in check_access_rights
    return self.pool.get('ir.model.access').check(cr, uid, self._name, operation, raise_exception)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/tools/cache.py", line 46, in lookup
    value = d[key] = self.method(self2, cr, *args)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/ir/ir_model.py", line 699, in check
    , (model_name, uid,)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/home/navrang/workspace/trunk_test/server-trunk/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...up_id)  WHERE m.model = 'res.users'    AND gu.uid = false   ...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.


Thanks,
Navrang Oza.

** Affects: openobject-addons
     Importance: Undecided
         Status: Invalid

** Changed in: openobject-addons
       Status: New => Invalid

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

Title:
  Trunk crashed

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  Hello,

  I have just pulled my addons, revno: 8404
  server: 8711.

  I removed all *.pyc files, and created new database and its not allow
  me to login.

  Can anyone check it ?

  Please find below mentioned traceback.

  2012-12-19 11:21:01,501 9516 INFO postgres werkzeug: 127.0.0.1 - - [19/Dec/2012 11:21:01] "POST /web/database/get_list HTTP/1.1" 200 -
  2012-12-19 11:21:01,534 9516 ERROR ? openerp.sql_db: Programming error: operator does not exist: integer = boolean
  LINE 1: ...up_id)  WHERE m.model = 'res.users'    AND gu.uid = false   ...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
  , in query SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END)   FROM ir_model_access a   JOIN ir_model m ON (m.id = a.model_id)   JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)  WHERE m.model = %s    AND gu.uid = %s    AND a.active IS True 
  2012-12-19 11:21:01,535 9516 ERROR ? openerp.addons.web.http.HttpRequest.dispatch: An error occurred while handling a json request
  Traceback (most recent call last):
    File "/home/navrang/workspace/trunk_test/web-trunk/addons/web/http.py", line 276, in dispatch
      r = method(self, **self.params)
    File "/home/navrang/workspace/trunk_test/web-trunk/addons/web/controllers/main.py", line 1334, in company_logo
      if user.company_id.logo_web:
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 484, in __getattr__
      return self[name]
    File "/home/navrang/workspace/trunk_test/server-trunk/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/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/res/res_users.py", line 793, in read
      res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/res/res_users.py", line 268, in read
      result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 3599, in read
      self.check_access_rights(cr, user, 'read')
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/osv/orm.py", line 3880, in check_access_rights
      return self.pool.get('ir.model.access').check(cr, uid, self._name, operation, raise_exception)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/tools/cache.py", line 18, in lookup
      r = self.lookup(self2, cr, *args)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/tools/cache.py", line 46, in lookup
      value = d[key] = self.method(self2, cr, *args)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/addons/base/ir/ir_model.py", line 699, in check
      , (model_name, uid,)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/home/navrang/workspace/trunk_test/server-trunk/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: operator does not exist: integer = boolean
  LINE 1: ...up_id)  WHERE m.model = 'res.users'    AND gu.uid = false   ...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

  
  Thanks,
  Navrang Oza.

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