While trying to open the addressbook I got the following error:
Database error
Invalid SQL: SELECT DISTINCT egw_addressbook.* FROM egw_addressbook LEFT JOIN egw_accounts ON egw_addressbook.account_id=egw_accounts.account_id WHERE contact_tid=‘n’ AND contact_tid != ‘D’ AND (egw_addressbook.contact_owner=12 OR contact_private=0 AND egw_addressbook.contact_owner IN (-14,12,0) OR egw_addressbook.contact_owner IS NULL) AND (account_expires IS NULL OR account_expires = -1 OR account_expires > 1277551562) ORDER BY n_family<>’’ DESC,n_family ASC,n_given ASC,org_name ASC:
FEHLER: bei SELECT DISTINCT müssen ORDER-BY-Ausdrücke in der Select-Liste erscheinen
I´m using postgresql on debian lenny with an actuall svn checkout version of egroupware.
The problem is the select DISTINCT * with the ORDER BY. I hope you can fix it.
