Some Users can not log in

Server
11

This happens when a user receives a share personally and additionally again through a group.

You’ll have to go into the database and remove the duplicated shares, I’ll see if I can find some example SQL queries for you.

I think the root cause of this problem was fixed in ownCloud version 10.0.10, however as you have the problem now, you’ll have to remove the duplicate shares first.

Make sure to take a database dump before, and put ownCloud in maintenance mode during this operation.

  1. select parent, count () from oc_share where share_type = 2 group by parent, share_with having count ()> 1;
  1. select * from oc_share where parent = xxx order by share_with; (where ‘xxx’ is an ID returned by the previous query)
  1. delete from oc_share where id = ‘xxx’; (where ‘xxx’ is the ID (the largest) of a share that exists in duplicate which is being returned by the previous query)
1 Like