Hi Andrew,
Yes, the error log does show quite a bit to look into; here goes:
[Tue Nov 24 20:18:53.521206 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: Error: QF in
'/usr/share/davical/inc/caldav-POST.php' on line 89
[Tue Nov 24 20:18:53.521344 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: SQL error "0A000" -
ERROR: set-returning functions are not allowed in CASE LINE 4: ...
expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_mem... ^ HINT: You
[Tue Nov 24 20:18:53.521381 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: RY: SELECT group_id
FROM group_member WHERE member_id = $1 UNION SELECT expanded.g_id FROM
(SELECT CASE WHEN $2 > 0 THEN expand_memberships( group_id, $2 - 1) EN
[Tue Nov 24 20:18:53.521443 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: id IS NOT NULL;
CONTEXT: SQL function "expand_memberships" during startup SQL statement
"SELECT bit_or(subquery.privileges) FROM ( SELECT privileges FROM grants
[Tue Nov 24 20:18:53.521475 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: cessor OR
to_principal IN (SELECT expand_memberships(in_accessor,in_depth))) UNION
SELECT bit_or(sq2.privileges) FROM ( SELECT 32::BIT(24) AS privileges
FROM exp
[Tue Nov 24 20:18:53.521507 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: ON SELECT
default_privileges AS privileges FROM principal WHERE principal_id =
in_grantor ) AS sq2 ) AS subquery" PL/pgSQL function
pprivs(bigint,bigint,integer)
[Tue Nov 24 20:18:53.521563 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: Error: QF in
'/usr/share/davical/inc/caldav-POST.php' on line 89
[Tue Nov 24 20:18:53.521592 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: SELECT
pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS p,
username FROM usr JOIN principal USING(user_no) WHERE lower(usr.email) =
lower(:email
[Tue Nov 24 20:18:53.521627 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: ":session_principal"
[Tue Nov 24 20:18:53.521656 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: ":scan_depth" => "2"
[Tue Nov 24 20:18:53.521683 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: POST: Query: QF: ":email" =>
"test@tjansson.se"
[Tue Nov 24 20:18:53.521767 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: :Response status 501 for POST
/caldav.php/khav/.out/
[Tue Nov 24 20:18:53.521799 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: :***************** Response Header
****************
[Tue Nov 24 20:18:53.521826 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: headers:-->Server: 1.1
[Tue Nov 24 20:18:53.521851 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: headers:-->DAV: 1, 2, 3,
access-control, calendar-access, calendar-schedule
[Tue Nov 24 20:18:53.521876 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: headers:-->DAV: extended-mkcol, bind,
addressbook, calendar-auto-schedule, calendar-proxy
[Tue Nov 24 20:18:53.521902 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: headers:-->X-DAViCal-Version:
DAViCal/1.1.8; DB/1.3.3
[Tue Nov 24 20:18:53.521926 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: headers:-->Content-type: text/plain;
charset="utf-8"
[Tue Nov 24 20:18:53.521952 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: :******************** Response
********************
[Tue Nov 24 20:18:53.522023 2020] [php7:notice] [pid 26001] [client
192.168.0.120:50518] davical: LOG: response:-->Database error
[Tue Nov 24 20:19:02.086371 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: Error: QF in
'/usr/share/davical/inc/Principal.php' on line 224
[Tue Nov 24 20:19:02.086474 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: SQL error
"0A000" - ERROR: set-returning functions are not allowed in CASE LINE 4:
... expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_mem... ^ HINT
[Tue Nov 24 20:19:02.086510 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: RY: SELECT
group_id FROM group_member WHERE member_id = $1 UNION SELECT
expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_memberships(
group_id, $2 -
[Tue Nov 24 20:19:02.086570 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: id IS NOT NULL;
CONTEXT: SQL function "expand_memberships" during startup SQL statement
"SELECT bit_or(subquery.privileges) FROM ( SELECT privileges FROM gr
[Tue Nov 24 20:19:02.086602 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: cessor OR
to_principal IN (SELECT expand_memberships(in_accessor,in_depth))) UNION
SELECT bit_or(sq2.privileges) FROM ( SELECT 32::BIT(24) AS privileges FRO
[Tue Nov 24 20:19:02.086634 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: ON SELECT
default_privileges AS privileges FROM principal WHERE principal_id =
in_grantor ) AS sq2 ) AS subquery" PL/pgSQL function
pprivs(bigint,bigint,int
[Tue Nov 24 20:19:02.086684 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: Error: QF in
'/usr/share/davical/inc/Principal.php' on line 224
[Tue Nov 24 20:19:02.086712 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: SELECT *,
pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS
privileges FROM dav_principal WHERE lower(email)=lower(:param)
[Tue Nov 24 20:19:02.086747 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF:
":session_principal" => "1001"
[Tue Nov 24 20:19:02.086775 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF:
":scan_depth" => "2"
[Tue Nov 24 20:19:02.086802 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: Principal: Query: QF: ":param" =>
"test@tjansson.se"
[Tue Nov 24 20:19:02.089351 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: Error: QF in
'/usr/share/davical/inc/caldav-PUT-functions.php' on line 1631
[Tue Nov 24 20:19:02.089416 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: SQL error "25P02" -
ERROR: current transaction is aborted, commands ignored until end of
transaction block"
[Tue Nov 24 20:19:02.089482 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: Error: QF in
'/usr/share/davical/inc/caldav-PUT-functions.php' on line 1631
[Tue Nov 24 20:19:02.089512 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: INSERT INTO
caldav_data ( dav_id, user_no, dav_name, dav_etag, caldav_data,
caldav_type, logged_user, created, modified, collection_id, weak_etag )
VALUES( :dav_i
[Tue Nov 24 20:19:02.089543 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: d, :modified,
:collection_id, :weak_etag )
[Tue Nov 24 20:19:02.089573 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":etag" =>
"992f8e8d510a05c1f9ac93c7ad51c61c"
[Tue Nov 24 20:19:02.089601 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":dav_data" =>
"BEGIN:VCALENDAR\r\nPRODID:-//Mozilla.org/NONSGML Mozilla Calendar
V1.1//EN\r\nVERSION:2.0\r\nBEGIN:VTIMEZONE\r\nTZID:Europe/Stockholm\r\nBEGIN
[Tue Nov 24 20:19:02.089681 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":caldav_type" =>
"VEVENT"
[Tue Nov 24 20:19:02.089708 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":session_user" => "1001"
[Tue Nov 24 20:19:02.089735 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":weak_etag" => ""
[Tue Nov 24 20:19:02.089761 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":dav_id" => "1415"
[Tue Nov 24 20:19:02.089787 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":modified" =>
"20201124T191901Z"
[Tue Nov 24 20:19:02.089813 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":collection_id" =>
"1002"
[Tue Nov 24 20:19:02.089839 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":user_no" => "1001"
[Tue Nov 24 20:19:02.089865 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":dav_name" =>
"/khav/calendar/2b41b780-16a3-42bd-b8cf-742606b1a901.ics"
[Tue Nov 24 20:19:02.089892 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: LOG: PUT: Query: QF: ":created" =>
"20201124T191828Z"
[Tue Nov 24 20:19:02.089939 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] davical: FATAL: :Insert into calendar_item failed...
[Tue Nov 24 20:19:02.089957 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] ================= Stack Trace ===================
[Tue Nov 24 20:19:02.090005 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] ===> /usr/share/davical/htdocs/caldav.php[123]
calls include()
[Tue Nov 24 20:19:02.090026 2020] [php7:notice] [pid 15864] [client
192.168.0.120:50520] ===>
/usr/share/davical/inc/caldav-PUT-vcalendar.php[85] calls write_resource()
Hope this provides some input enought on how to fix this.
//Kim
On 2020-11-24 11:26, Andrew Ruthven wrote:
> Hi Kim,
>
> On Mon, 2020-11-23 at 21:44 +0100, Kim Haverblad via Davical-general
> wrote:
>> Next issue to solve is that I can create entries but I can't invite
>> any
>> other to the calendar entry; meaning when I add another users who
>> has
>> access and exist in the same DAVical server and click save; well
>> nothing
>> is saved or kept. Same entry without any invite it's being saved
>> without
>> any problem. Editing the saved entry and add an invite, the edit of
>> adding a invite isn't saved. Checking my user profile it clearly
>> indicates that users can "Scheduling: Deliver an Invitation".
> Is there anything appearing in your webservers error log?
>
--
Vänlig hälsning,
Kim Haverblad
M: 0760046232
--
GnuPG ID: 0x8B75 DF42 EE04 296E
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general