Your message dated Sat, 1 Mar 2008 23:23:41 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Re: Bug#468494: Day view in Calendar not working for users,
only for groups
has caused the Debian Bug report #468494,
regarding Day view in Calendar not working for users, only for groups
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [EMAIL PROTECTED]
immediately.)
--
468494: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=468494
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
Package: egroupware-infolog
Version: 1.2.107-2.dfsg-2
Severity: serious
Tags: patch
--- Please enter the report below this line. ---
After upgrading to egroupware version 1.2.107, the day view in the
calendar does not work for single users anymore, only for groups. Week
and month views still work for single users. The error message one gets
when visiting a person's day view is the following:
Database error: Invalid SQL: SELECT main.info_id FROM egw_infolog main
WHERE ( ((info_owner=6 AND info_responsible=0 OR
','||info_responsible||',' LIKE '%,6,%') AND (info_owner=6 OR
(','||info_responsible||',' LIKE '%,6,%' AND info_access='public') OR
info_owner IN (6) OR (info_access='public' AND info_owner
IN(-11,6,12,7,9,-1,8,-10))) ) AND NOT (info_status IN
('done','billed','cancelled')) AND info_startdate < '1204326000' )
pgsql Error: -1 (ERROR: operator does not exist: character varying =
integer LINE 1: ... main WHERE ( ((info_owner=6 AND info_responsible=0
OR ','|... ^ HINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts.)
File: /usr/share/egroupware/infolog/inc/class.soinfolog.inc.php
Line: 590
Function: soinfolog::search / boinfolog::search /
boinfolog::cal_to_include /
ExecMethod(infolog.boinfolog.cal_to_include) / hooks::single /
hooks::process / uiviews::get_todos / uiviews::day /
ExecMethod(calendar.uiviews.day)
Session halted.
Having looked at the database schema of egw_infolog I verified that
postgresql is correct here as the info_responsible column is of type
character varying but gets compared to integer. Having looked
inside /usr/share/egroupware/infolog/inc/class.soinfolog.inc.php I
indeed spotted the problem in line 167 where info_responsible=0 is
missing the quotation marks to make the 0 a string literal. After
replacing it with info_responsible='0', the day view works again.
--- System information. ---
Architecture: i386
Kernel: Linux 2.6.16
Debian Release: lenny/sid
500 unstable www.debian-multimedia.org
500 unstable ftp.debian.org
--- Package information. ---
Depends (Version) | Installed
=============================================-+-=====================
egroupware-core (= 1.2.107-2.dfsg-2) | 1.2.107-2.dfsg-2
egroupware-etemplate (= 1.2.107-2.dfsg-2) | 1.2.107-2.dfsg-2
--
Stefan Bellon
--- End Message ---
--- Begin Message ---
Version: 1.4.001.dfsg-1
Am Samstag, 1. März 2008 schrieb Ralf Becker:
> The bug (and other ones related to newer postgres versions) are fixed in
> the current release 1.4. The old version 1.2 is no longer supported by
> the egroupware project.
--- End Message ---
