Hi,
I made a cvs update from the latest cvs. I upgraded the database.
I tried the infolog.
If I want to add a new infolog entry, I got an SQL error on my
postgresql 8.1.1.
Database error: Invalid SQL: SELECT
*,pm_id,pl_validsince,pl_price,pl_customertitle,pl_modifier,pl_modified,pl_billable,(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 <= 1139053421) AS max_validsince
FROM egw_pm_pricelist ,egw_pm_prices p WHERE
egw_pm_pricelist.pl_id=p.pl_id AND (pm_id=0) HAVING
pl_validsince=max_validsince ORDER BY pl_title
pgsql Error: -1 (ERROR: column “max_validsince” does not exist)
File:
/var/www/localhost/htdocs/egroupware/etemplate/inc/class.so_sql.inc.php
Line: 534
Function: egw_db::select / so_sql::search / sopricelist::search /
bopricelist::search / bopricelist::pricelist /
projectmanager_widget::pre_process / etemplate::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.
*
Second.*
If I try to edit an existing infolog entry, I got this sql error message:
Database error: Invalid SQL: SELECT
*,pm_id,pl_validsince,pl_price,pl_customertitle,pl_modifier,pl_modified,pl_billable,(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 <= 1139053592) AS
max_validsince,CASE p.pm_id WHEN 1 THEN 1 WHEN 0 THEN 0 END AS
prio,(select max(CASE m.pm_id WHEN 1 THEN 1 WHEN 0 THEN 0 END) FROM
egw_pm_prices m WHERE m.pl_id=p.pl_id) AS max_prio FROM egw_pm_pricelist
,egw_pm_prices p WHERE egw_pm_pricelist.pl_id=p.pl_id AND (pm_id != 0
AND pl_billable IN (0,1)) HAVING prio=max_prio AND
pl_validsince=max_validsince ORDER BY pl_title
pgsql Error: -1 (ERROR: column “prio” does not exist)
File:
/var/www/localhost/htdocs/egroupware/etemplate/inc/class.so_sql.inc.php
Line: 534
Function: egw_db::select / so_sql::search / sopricelist::search /
bopricelist::search / bopricelist::pricelist /
projectmanager_widget::pre_process / etemplate::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.
Compared it to the mysql based domain, the mysql domain works fine. I
can add/edit infolog entries,
Attached files not possible to delet nor from postgresql, nor from mysql
domain.
Except these issues, infolog got some new nice features, thanks!
Regards,
István
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
