Hi there,
I have configured and installed DAViCal on ubuntu using apt-get.
I followed the step-by-step documentation except for the web server section, I am using nginx instead of apache2.
I can access the admin pages, create users and collections.
I can connect with OS X Calendar 7.0 and with an Androïd App too.
But I cannot go much further, when I try to sync, Calendar says:
The server responded with
“500”
to operation CalDAVAccountRefreshQueueableOperation.
And in nginx logs, I can read:
2015/02/21 20:59:22 [error] 30451#0: *704 FastCGI sent in stderr: "DAViCal: LOG: caldav.php/ab/: Query: QF: SQL error "42883" - ERROR: function new_sync_token(integer, integer) does not exist LINE 1: SELECT new_sync_token( 0, 1002) AS sync_token ^ HINT: No function matches the given name and argument types. You might need to add explicit type cas
DAViCal: LOG: caldav.php/ab/: Query: QF: ts."
DAViCal: LOG: caldav.php/ab/: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
DAViCal: LOG: caldav.php/ab/: Query: QF: ":collection_id" => "1002"
DAViCal: LOG: caldav.php/ab/: Query: QF: SQL error "42883" - ERROR: function new_sync_token(integer, integer) does not exist LINE 1: SELECT new_sync_token( 0, 1002) AS sync_token ^ HINT: No function matches the given name and argument types. You might need to add explicit type cas
DAViCal: LOG: caldav.php/ab/: Query: QF: ts."
DAViCal: LOG: caldav.php/ab/: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
DAViCal: LOG: caldav.php/ab/: Query: QF: ":collection_id" => "1002"" while reading response header from upstream, client: <ip>, server: <domain>, request: "PROPFIND /caldav.php/ab/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: “<domain>"
I guess davcal_functions.sql is not properly loaded. I don’t know postgres, I usually use MySQL or MongoDB.
Any suggestion would be great.
I can send any configuration file that might seem useful to help.
Best regards,
Anthony
I have configured and installed DAViCal on ubuntu using apt-get.
I followed the step-by-step documentation except for the web server section, I am using nginx instead of apache2.
I can access the admin pages, create users and collections.
I can connect with OS X Calendar 7.0 and with an Androïd App too.
But I cannot go much further, when I try to sync, Calendar says:
The server responded with
“500”
to operation CalDAVAccountRefreshQueueableOperation.
And in nginx logs, I can read:
2015/02/21 20:59:22 [error] 30451#0: *704 FastCGI sent in stderr: "DAViCal: LOG: caldav.php/ab/: Query: QF: SQL error "42883" - ERROR: function new_sync_token(integer, integer) does not exist LINE 1: SELECT new_sync_token( 0, 1002) AS sync_token ^ HINT: No function matches the given name and argument types. You might need to add explicit type cas
DAViCal: LOG: caldav.php/ab/: Query: QF: ts."
DAViCal: LOG: caldav.php/ab/: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
DAViCal: LOG: caldav.php/ab/: Query: QF: ":collection_id" => "1002"
DAViCal: LOG: caldav.php/ab/: Query: QF: SQL error "42883" - ERROR: function new_sync_token(integer, integer) does not exist LINE 1: SELECT new_sync_token( 0, 1002) AS sync_token ^ HINT: No function matches the given name and argument types. You might need to add explicit type cas
DAViCal: LOG: caldav.php/ab/: Query: QF: ts."
DAViCal: LOG: caldav.php/ab/: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
DAViCal: LOG: caldav.php/ab/: Query: QF: ":collection_id" => "1002"" while reading response header from upstream, client: <ip>, server: <domain>, request: "PROPFIND /caldav.php/ab/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: “<domain>"
I guess davcal_functions.sql is not properly loaded. I don’t know postgres, I usually use MySQL or MongoDB.
Any suggestion would be great.
I can send any configuration file that might seem useful to help.
Best regards,
Anthony