friendica.ucy.de

Ingo van Lessen (deivl) via Friendica Support 4 years ago • friendica

Photo permissions don't work [solved]

Hi folks!
I am using friendica version 2020.09-01 and I wonder if this issue is known by anyone else:
uploading or editing a photo and setting
- "public" permission works fine :)
- "Limited/Private" permission doesn't work with "Show to:" for persons or groups. The person or the one of the related group has no access to the photo. One can read posts with the same permission restrictions, but doesn't see the photos :(

Any ideas?

xy@libranet.de likes this.

Ingo van Lessen (deivl) 4 years ago friendica

Thanks for your reply :)
All persons use Friendica and are registered on the same server instance (friendica.ucy.de).

Ingo van Lessen (deivl) 4 years ago friendica

According to https://forum.friendi.ca/help/database/db_group_member the table 'group_member' should have a 'uid' field. Mine hasn't :(

> show columns from group_member;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| gid        | int(10) unsigned | NO   | MUL | 0       |                |
| contact-id | int(10) unsigned | NO   | MUL | 0       |                |
+------------+------------------+------+-----+---------+----------------+
3 rows in set (0.002 sec)

May this be an outdated database structure?

Ingo van Lessen (deivl) 4 years ago friendica

Hm, bin/console dbstructure update -f runs without any response.
Creating and editing groups works fine. But what is confusing me is this mysql respond:

> desc group;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1

This happens with some other tables also :(

Ingo van Lessen (deivl) 4 years ago friendica

Ah, I single and double quoted group which didn't work either, but > desc `group`; outputs the data correctly :) Thank you so much!
So I will have a closer look to the data to solve my initial issue ...

Ingo van Lessen (deivl) 4 years ago friendica

If I understood you right: both.
As soon as I change the permission of a photo from "Public" to "Limited/Private" nobody has access to it and can't see it in posts nor in "Photos" except the owner, no matter who's listed in "Show to:".
You mentioned "private albums". I just had a closer look and was not able to set album permissions ("Vier" theme). I only have the permission option for single pictures.

Hope it helps ...

Ingo van Lessen (deivl) 4 years ago friendica

The problem seems to be solved since the update from 2020.09-01 to 2021.01 has been successfully installed :) Thank you so much!