New ticket submitted by camel camel at 2010/05/11 14:47
Tracking System: Bugs
Category: Addressbook
Version: Trunk
Status: Open
Completed: 0%
Priority: 5 - medium
Created By: camel camel
Assigned to: Ralf Becker
Summary: #2589 - on deleting all items -> Database error psql
if i want to detele all items in addressbook:
on the botton right -> select all + use option, “use for the whole request”, then i try to delete:
what i can see, in the sql request all order filelds must be placed also in the select -> missing field is n_fileas
######################
Database error
Invalid SQL: SELECT DISTINCT egw_addressbook.contact_id AS id FROM egw_addressbook WHERE contact_tid=‘n’ AND account_id IS NULL AND contact_tid != ‘D’ AND egw_addressbook.contact_owner != 0 AND (egw_addressbook.contact_owner=5009 OR contact_private=0 AND egw_addressbook.contact_owner IN (5009,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY n_fileas<>’’ DESC,n_fileas ASC:
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2589&no_popup=1