Social: Own posts should also appear under "Home"

[mathiasconradt]

On cloud.nextcloud.com: own posts should also appear under "Home". Currently they don't.

[violoncelloCH]

this is already covered by #153 but as @jancborchardt suggested to split #153 up we maybe keep this one open and remove the point from #153?

[ArtificialOwl]

Ok, it seems the issue is coming from the fact that we're using INNER JOIN instead of RIGHT JOIN (to keep some compat with sqlite). If the table server_follows is totally empty, the SQL request returns no result.

The easiest (and yet almost perfectly clean) solution would be to create a random/empty/fake entry in the table server_follows.

@jancborchardt @juliushaertl - would you agree on creating a fake entry in the table during the installation process ?

[ArtificialOwl]

@mathiasconradt just to confirm, do you still have issue right now ? if so, can you follow an account and check your Home stream ?

[mathiasconradt]

@daita Issue is resolved now (Home).

Following does not work, see https://github.com/nextcloud/social/issues/165

[jancborchardt]

@daita regarding database questions I'm not the right person to ask. Probably @juliushaertl or @rullzer for example. :)