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
