Public bug reported: Binary package hint: egroupware
There are known compatibility issues upstream with the currently packaged Ubuntu Edgy version of eGroupware (1.2-105) when using Postgresql 8.1. The upstream verson 1.2-106 should fix these problems. Can you please backport the Feisty version? Here's an example error created by trying to insert a new to-do item in the calendar: Database error: Invalid SQL: SELECT *,pm_id,pl_validsince,pl_price,pl_customertitle,pl_modifier,pl_modified,pl_billable FROM egw_pm_pricelist JOIN egw_pm_prices p ON egw_pm_pricelist.pl_id=p.pl_id WHERE pm_id=0 HAVING pl_validsince=(select max(t.pl_validsince) FROM egw_pm_prices t where p.pl_id=t.pl_id and p.pm_id=t.pm_id and t.pl_validsince <= 1174742022) ORDER BY pl_title pgsql Error: -1 (ERROR: column "egw_pm_pricelist.pl_id" must appear in the GROUP BY clause or be used in an aggregate function) File: /usr/share/egroupware/etemplate/inc/class.so_sql.inc.php Line: 611 Function: egw_db::select / so_sql::search / sopricelist::search / bopricelist::search / bopricelist::pricelist / projectmanager_widget::pre_process / boetemplate::extensionPreProcess / etemplate::show_cell / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::show_cell / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::exec / uiinfolog::edit / ExecMethod(infolog.uiinfolog.edit) Session halted. Thanks, Jon ** Affects: egroupware (Ubuntu) Importance: Undecided Status: Confirmed -- eGroupware compatability issues with Postgresql 8.1 https://launchpad.net/bugs/95472 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs