1. 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

Discussion in 'Media Gallery Support' started by Nuno, Sep 6, 2015.

  1. Nuno

    Nuno Active Member


    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?
  2. Mike

    Mike XenForo Developer Staff Member

    They're not duplicates - they're different permissions.
  3. Nuno

    Nuno Active Member

    OK, so if I want to disallow all permissions = add I can run a query and delete all rows where permission = add?
  4. Chris D

    Chris D XenForo Developer Staff Member

    No. It's rarely a good idea to do anything directly in the database.

    What exactly are you trying to do?
  5. Nuno

    Nuno Active Member

    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 :)
  6. Chris D

    Chris D XenForo Developer Staff Member

    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.
  7. Nuno

    Nuno Active Member

    ok .. I'll do it by and ;)

  8. Nuno

    Nuno Active Member

    Do I need to rebuild anything after changing this?
  9. Chris D

    Chris D XenForo Developer Staff Member

    Setting the permissions in the normal way will rebuild everything that needs to be rebuilt.
    Nuno likes this.

Share This Page