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 OpenERP
CTP, which is subscribed to OpenERP Server.
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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help : https://help.launchpad.net/ListHelp
