• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

MG 1.1 duplicated entries in xengallery_album_permission

Nuno

Active member
#1
Hello,

I found that I have duplicated entries in xengallery_album_permission ...

album id: 31, permission: add, access_type: public
album id: 31, permission: view, access_type: public

Is this ok?
 

Nuno

Active member
#3
OK, so if I want to disallow all permissions = add I can run a query and delete all rows where permission = add?
 

Chris D

XenForo developer
Staff member
#4
No. It's rarely a good idea to do anything directly in the database.

What exactly are you trying to do?
 

Nuno

Active member
#5
I let the permissions by default when installed xfmg and this allows users to set who can upload photos to their albums.
Without knowing the implication, some choose to allow anyone to upload photos to their albums and I already disable that, but now, I need to remove all previous permissions too and would like to do it without going one by one :)
 

Chris D

XenForo developer
Staff member
#6
One by one is best. There's potentially records on other tables and caches that would need to be rebuilt that can only be guaranteed if you do it properly.

At least you can see from the database which albums you need to change.