Menu
▾
▴
[eGroupWare-tracker] Bugs #1338: Postgres: DB Fehler bei Verteilerliste als Filter
|
From: <tr...@eg...> - 2007-11-22 09:43:01
|
<html> <body> <table cellspacing="2" cellpadding="0" border="0" width="100%"> <tr style="background-color: #D3DCE3;;"><td style="font-weight:bold;font-size:medium;">New ticket submitted by Manfred Kiss at 2007/11/22 10:20</td></tr> <tr style="background-color: #F1F1F1;"><td style="font-size:medium;">You can respond by visiting: <a href="http://www.egroupware.org/bugs&tr_id=1338" target="_blank">http://www.egroupware.org/bugs&tr_id=1338</a></td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Tracking System: Bugs</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Category: Addressbook</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Version: Version 1.4.002</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Status: Open</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Resolution: None</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Completed: 0%</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Priority: 5 - medium</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Created By: Manfred Kiss</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:small;">Assigned to: Ralf Becker</td></tr> <tr style="background-color: #F1F1F1;"><td style="font-weight:bold;font-size:medium;">Summary: #1338 - Postgres: DB Fehler bei Verteilerliste als Filter</td></tr> <tr style="background-color: #FFFFF1;"><td style="font-size:medium;">Postgres, egq. 1.4.001<br /> <br /> Kritischer Fehler:<br /> <br /> Verteilerlisten als Filter einsetzen:<br /> <br /> Database error: Invalid SQL: SELECT DISTINCT egw_addressbook.* FROM egw_addressbook JOIN egw_addressbook2list ON egw_addressbook.contact_id=egw_addressbook2list.contact_id AND list_id=2 WHERE contact_tid='n' AND egw_addressbook.contact_owner != 0 AND (egw_addressbook.contact_owner=1117 OR contact_private=0 AND egw_addressbook.contact_owner IN (1117,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY n_family<>'' DESC,n_family ASC,n_given ASC,org_name ASC<br /> pgsql Error: -1 (FEHLER: bei SELECT DISTINCT müssen ORDER-BY-Ausdrücke in der Select-Liste erscheinen)<br /> <br /> File: /usr/share/groupware/etemplate/inc/class.so_sql.inc.php<br /> Line: 688<br /> Function: egw_db::select / socontacts_sql::search / socontacts_sql::search / uicontacts::search / uicontacts::get_rows / nextmatch_widget::pre_process / etemplate::extensionPreProcess / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::exec / uicontacts::index / ExecMethod()<br /> <br /> Session halted.<br /> <br /> Manfred Kiss<br /> <br /> </td></tr> </table> </body> </html> |