[egw 1.6 rc3 + postgres 8.3] database error when sorting on custom fields in address book

Bert_van_der_Perk 2008-11-06 13:08:58 UTC #1

Hello,
When I create a custom field in the address book, and then click on the column header of this field to sort the addresses on it, I get this error:

Database error

Invalid SQL: SELECT DISTINCT egw_addressbook.*,contact_value<>’’ FROM egw_addressbook LEFT JOIN egw_addressbook_extra extra_order ON egw_addressbook.contact_id=extra_order.contact_id AND extra_order.contact_name=‘extra’ WHERE contact_tid=‘n’ AND (egw_addressbook.contact_owner=8 OR contact_private=0 AND egw_addressbook.contact_owner IN (8,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY extra_order.contact_value<>’’ DESC,extra_order.contact_value ASC,org_name ASC,n_family ASC,n_given ASC:
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

Is this a known bug? I couldn’t find anything about it.

Leithoff_Klaus 2008-11-06 14:29:54 UTC #2

please report that as bug in tracker.
It is a bug known as incompatibility between MYSQL and postgres.

Bert_van_der_Perk 2008-11-06 14:32:21 UTC #3

As a test, I connected the same egroupware installation to a mysql server, and was unable to reproduce the error. So it seems to be postgres-specific.

Bert_van_der_Perk 2008-11-06 14:34:35 UTC #4

I will do that as soon as I don’t get an error message anymore when logging in to tracker.

kenklay 2009-03-05 16:51:11 UTC #5

As a test, I connected the same egroupware installation to a mysql server, and was unable to reproduce the error. So it seems to be postgres-specific.
[/quote]

We are still experiencing this error using 1.6.001 with Postgres 8.1.

We have one user effectively locked out of the addressbook since each time he tries to open it, he get the error message. How do we change the settings so his addressbook does not attempt to do the sort when he opens the addressbook?