Calendar - one calendar can't be synced and downloaded

Server
1

Hello there,
some days ago, my Owncloud wasn’t accessible anymore, I found out I have to update it. I have tried a lot and the Updater doesn’t work (Server error 504: Gateway Timeout Message when creating a checkpoint), so I decided to just make a fresh install. But of course I need a backup of all my files.
Now something very interesting happens: I can download all calendars but one from the browser. When I try downloading this calendar, I get an HTTP ERROR 500. But I can still see all this calendar’s entries in the browser. This calendar is the default calendar (it’s the first one I had).
My phone doesn’t sync all my calendars anymore and tells me there’s an “authentification problem”.
When I try accessing all my calendars with a calendar program on my Ubuntu, it will ask for the password again and again.
Do you have an idea what the problem might be?
Thank you for all your answers.
Julia

Steps to reproduce

Sorry, I have no idea.

Expected behaviour

I would like to sync my calendar - but because this doesn’t work, I just want to download the calendar as a backup and then continue using it.

Actual behaviour

I get the HTTP ERROR 500 when I try downloading one specific calendar. All other calendars can be downloaded.

Server configuration

ownCloud version: 9.1.0

Updated from an older ownCloud or fresh install: It was a fresh install more than a year ago.

Client configuration

Browser: Chromium

Operating system: Ubuntu 18.04

2

It’s difficult to tell what’s wrong, without knowledge what exactly you did and without seeing any log file snippets.
And BTW, using such an outdated version these days is a risky business. Only few people (if any) are able and/or willing to give support.

3

Do you have Shell Access to your Server? You could then use my script calcardbackup:

4

Thank you for your answers.

@Bernie_O: That’s a very good idea, but I don’t have Shell Access. The installation of Owncloud was done by my Internet/Domain Provider…
@alfredb: I thought that it’s difficult to tell, still wanted to give it a try. Because I don’t install Owncloud manually, I don’t see what’s happening in the log file. I would also like to not use the Updater,but update via the shell - but I can’t. If I find some time, I might install it manually next time, then perhaps it will be easier to fix problems.

5

Of course you are right. I didn’t wanted to say it would be impossible. Don’t give up, always dare to ask! However, at the moment I’m somewhat clueless, with the given information.

7

I had posted some log file but I have to go afk now and I wasn’t sure if it was safe enough. I will post it again later.

8

No problem, I have the log you posted. Could you also supply some relevant lines of owncloud.log? Maye you should remove/hide the IP-adresses.

9

@seicaso which Database are you using? SQLite3 or MySQL?

10

MySQL :slightly_smiling_face:

11

can you please tell me where I find this file? at this moment I’m searching for it on the server, it hasn’t found a file named owncloud.log yet.

12

oh ! i found it already. i post it more when i find the relevant lines.

13

{"reqId":"bik2\/Zkatk8yCvRh5RMy","remoteAddr":"xxxx","app":"PHP","message":"Error: [] operator not supported for strings at \/data\/web\/1\/000\/073\/900\/303849\/htdocs\/owncloud\/lib\/private\/App\/InfoParser.php#186","level":3,"time":"2018-11-23T15:59:14+00:00","method":"GET","url":"\/owncloud\/status.php","user":"--"} {"reqId":"oAcxZjIX\/O\/rL739\/jJM","remoteAddr":"xxxx","app":"index","message":"Exception: {\"Exception\":\"Error\",\"Message\":\"[] operator not supported for strings\",\"Code\":0,\"Trace\":\"#0 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/App\\\/InfoParser.php(188): OC\\\\App\\\\InfoParser->xmlToArray(Object(SimpleXMLElement))\\n#1 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/App\\\/InfoParser.php(59): OC\\\\App\\\\InfoParser->xmlToArray(Object(SimpleXMLElement))\\n#2 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(662): OC\\\\App\\\\InfoParser->parse('\\\/data\\\/web\\\/1\\\/000...')\\n#3 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(634): OC_App::getAppInfo('\\\/data\\\/web\\\/1\\\/000...', true)\\n#4 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(621): OC_App::getAppVersionByPath('\\\/data\\\/web\\\/1\\\/000...')\\n#5 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/app.php(987): OC_App::getAppVersion('files')\\n#6 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/util.php(1461): OC_App::shouldUpgrade('files')\\n#7 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/util.php(622): OC_Util::needUpgrade(Object(OC\\\\AllConfig))\\n#8 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/base.php(587): OC_Util::checkServer(Object(OC\\\\AllConfig))\\n#9 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/base.php(967): OC::init()\\n#10 \\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/index.php(37): require_once('\\\/data\\\/web\\\/1\\\/000...')\\n#11 {main}\",\"File\":\"\\\/data\\\/web\\\/1\\\/000\\\/073\\\/900\\\/303849\\\/htdocs\\\/owncloud\\\/lib\\\/private\\\/App\\\/InfoParser.php\",\"Line\":186}","level":3,"time":"2018-11-23T15:59:18+00:00","method":"GET","url":"\/owncloud\/","user":"--"} {"reqId":"oAcxZjIX\/O\/rL739\/jJM","remoteAddr":"xxxx","app":"PHP","message":"Error: [] operator not supported for strings at \/data\/web\/1\/000\/073\/900\/303849\/htdocs\/owncloud\/lib\/private\/App\/InfoParser.php#186","level":3,"time":"2018-11-23T15:59:18+00:00","method":"GET","url":"\/owncloud\/","user":"--"} {"reqId":"MRjxZz29lpWLflc4lQzI","remoteAddr":"xxxx","app":"PHP","message":"Error: [] operator not supported for strings at \/data\/web\/1\/000\/073\/900\/303849\/htdocs\/owncloud\/lib\/private\/App\/InfoParser.php#186","level":3,"time":"2018-11-23T15:59:46+00:00","method":"GET","url":"\/owncloud\/status.php","user":"--"} {"reqId":"s1TdFEQHzEewbDFoJKIN","remoteAddr":"xxxx","app":"core","message":"Could not get application: cURL error 60: SSL certificate problem: certificate has expired","level":3,"time":"2018-11-23T16:28:03+00:00","method":"GET","url":"\/owncloud\/cron.php","user":"--"} {"reqId":"s1TdFEQHzEewbDFoJKIN","remoteAddr":"xxxx","app":"core","message":"Could not get application: cURL error 60: SSL certificate problem: certificate has expired","level":3,"time":"2018-11-23T16:28:03+00:00","method":"GET","url":"\/owncloud\/cron.php","user":"--"} {"reqId":"s1TdFEQHzEewbDFoJKIN","remoteAddr":"xxxx","app":"core","message":"Could not get application: cURL error 60: SSL certificate problem: certificate has expired","level":3,"time":"2018-11-23T16:28:03+00:00","method":"GET","url":"\/owncloud\/cron.php","user":"--"} {"reqId":"s1TdFEQHzEewbDFoJKIN","remoteAddr":"xxxx","app":"core","message":"Could not get application: cURL error 60: SSL certificate problem: certificate has expired","level":3,"time":"2018-11-23T16:28:03+00:00","method":"GET","url":"\/owncloud\/cron.php","user":"--"} {"reqId":"s1TdFEQHzEewbDFoJKIN","remoteAddr":"xxxx","app":"core","message":"Could not get application: cURL error 60: SSL certificate problem: certificate has expired","level":3,"time":"2018-11-23T16:28:03+00:00","method":"GET","url":"\/owncloud\/cron.php","user":"--"} {"reqId":"VpKfZj3PIZJuA1SLmWJK","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:12+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=s&perPage=200&itemType=principals","user":"admin"}

{"reqId":"vc3TlCTxXTfBqeUgoqio","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:12+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=si&perPage=200&itemType=principals","user":"admin"} {"reqId":"qaJV02U0Iusf8PgoJrHK","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:13+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=sim&perPage=200&itemType=principals","user":"admin"} {"reqId":"gWqu26UT5D3oUK\/kbghA","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:13+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=simo&perPage=200&itemType=principals","user":"admin"} {"reqId":"yZuHvOzjI9\/MdiGBDiNI","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:13+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=simon&perPage=200&itemType=principals","user":"admin"} {"reqId":"gPwiBQ+ZPQ3pL4iFBKlj","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:14+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=simo&perPage=200&itemType=principals","user":"admin"} {"reqId":"oZBJR7bHpRiJB4R8ktJk","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:51+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=j&perPage=200&itemType=principals","user":"admin"} {"reqId":"FcHkvNI3JFpi7iHauzcB","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:51+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=ju&perPage=200&itemType=principals","user":"admin"} {"reqId":"dD4fxwoo9e3RPGGpTqcJ","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:51+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=jul&perPage=200&itemType=principals","user":"admin"} {"reqId":"1NWQG5f5xoJqhtuOkk6m","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:52+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=juli&perPage=200&itemType=principals","user":"admin"} {"reqId":"yHYWHENNzjjnKsz+Z2SE","remoteAddr":"xxxx","app":"OCP\\Share","message":"Sharing backend for principals not found","level":3,"time":"2018-11-23T19:25:52+00:00","method":"GET","url":"\/owncloud\/ocs\/v1.php\/apps\/files_sharing\/api\/v1\/sharees?format=json&search=julia&perPage=200&itemType=principals","user":"admin"}

14

What you also could do is to dump the MySQL database, create a MySQL database on your local machine and import the dump to that database and then let calcardbackup export calendars and addressbooks from that database. There is no need for a working ownCloud instance. Have a look at calcardbackups README in the repository at github.

15

This is probably LDAP related. Unfortunately I have no deeper knowledge in that topic…

16

Thank you very much for both your answers! You are very helpful.
I will continue searching for a solution, now I know already more. I don’t know very much about MySQL, but I will try Bernie’s solution and perhaps there will be someone else who can give me a hint about the LDAP problem.

17

You’re welcome! I’m vey sorry that I couldn’t help more.

18

Hi Bernie,
do you understand more about this? it’s from calcardbackups.

  • no valid status.php found at xxx.
    – Notice: can’t detect vendor.
  • Server 9.1.0 detected.
  • Database of chosen Server installation is MySQL/MariaDB.
  • Looking for calendars in your Server:
    ERROR 1045 (28000): Access denied for user ‘xxxx’@‘localhost’ (using password: YES)
19

You need to use username and password of your local database in the dummy config.php. Test it with:
mysql -u USERNAME -p