[9.1.0] One user login gets error 500 and admin can't load users page

Server
1


I setup an owncloud server 2 years ago, version is 9.1.0.
Yesterday, one collegue complained it couldn't login to owncloud via web nor via the windows application.
There others worked fine.
Also, if i tried to open the users in my admin area, it keeps reloading forever.

After updating some server software (php, nginx, etc...) nothing worked.
Tried to scan the files, but even with 4gb allocated, with exausted the memory.

My file try was to delete the user in DB.
After I deleted, I could open the users admin area.
I inserted again, again, no longer could I open it.
So I started deleting the user groups. And one group is cause the issue.
But this group has other users that work properly.
How can further debug this?

Steps to reproduce

  1. After login, go to user page in admin area.

Expected behaviour

Get the list of users

Actual behaviour

Keeps reloading

Server configuration

Centos 7, nginx, php 7.0

Database:

PHP version:
7.0

ownCloud version:
9.1.0

Updated from an older ownCloud or fresh install:
Freash install 2 years ago.

Where did you install ownCloud from:
official site

2

I think you shouldn't use such way too outdated versions like 9.1.0, better use a current version like 9.1.6 before reporting a problem.

3

After some debugging, I found it was a file shared from a another user with several other users, including the one that couldn't login (a mp4 recorded with a webcam) with about 22mb.
It "crashed" owncloud when tryin to $mountConfigManager->registerMounts($userObject, $mounts);
I deleted the entries in the database, and started working.

On side note, I would update the owncloud, but it's not that easy to do. It could go wrong, and be even worse, also, not sure the same theme would work, or would have even more work configuring the new theme.

4

You could set up a test system and upgrade that, and see if it works :slight_smile:

5

That is a good idea, and I've had thought about it.
But first, I'll need to compare the db struture for any changes.
Btw, and off-topic, are there any?

6

You can check the changelog for those:

https://owncloud.org/changelog/