c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello,

I have checked this issue again and I have found that the problem comes from the server side.
Where we have used "[('name::date','=',current_date)]" these type of domains with "::" which is not working.

I have faced the same problem in mrp, crm_helpdesk aslo.

So currently I am assigning this to server side.

Thanks.

** Changed in: openobject-addons
     Assignee: OpenERP R&D Addons Team 3 (openerp-dev-addons3) => (unassigned)

** Project changed: openobject-addons => openobject-server

** Changed in: openobject-server
   Importance: Low => Medium

** Changed in: openobject-server
     Assignee: (unassigned) => OpenERP's Framework R&D (openerp-dev-framework)

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

Title:
  cannot open attendances view

Status in OpenERP Server:
  Confirmed

Bug description:
  In trunk, and an instance with demo data and all available modules in
  the main application wizard installed, I cannot open the list view of
  Human Resources/Attendances/Attendances

  
  [2011-09-20 10:02:30,906][trunk_1] INFO:res.config:all configuration actions have been executed
  [2011-09-20 10:30:03,861][?] ERROR:db.cursor:Programming error: ERREUR:  la colonne hr_attendance.name::date n'existe pas
  LIGNE 1 : ...CT "hr_attendance".id FROM "hr_attendance" WHERE (hr_attenda...
                                                                 ^
  , in query SELECT "hr_attendance".id FROM "hr_attendance" WHERE (hr_attendance."name::date" = '2011-09-20') ORDER BY name desc  limit 80
  [2011-09-20 10:30:03,862][?] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 118, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 2106, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 4574, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 213, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: ERREUR:  la colonne hr_attendance.name::date n'existe pas  (in english : the colums hr_attendance.name does not exist)
  LIGNE 1 : ...CT "hr_attendance".id FROM "hr_attendance" WHERE (hr_attenda...

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