We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28215
    • 4,149 Posts
    What are the records in the modx_access_context table?
      shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
      • 9069
      • 18 Posts
      Quote from: splittingred at Aug 03, 2010, 11:03 AM

      What are the records in the modx_access_context table?

      id target principal_class principal authority policy
      1 web modUserGroup 0 9999 3
      2 mgr modUserGroup 1 0 2
      3 web modUserGroup 1 0 2
        • 23491 ☆ A M B ☆
        • 1,056 Posts
        Quote from: erunix at Aug 03, 2010, 11:08 AM

        Quote from: splittingred at Aug 03, 2010, 11:03 AM

        What are the records in the modx_access_context table?

        id target principal_class principal authority policy
        1 web modUserGroup 0 9999 3
        2 mgr modUserGroup 1 0 2
        3 web modUserGroup 1 0 2

        Umm... how did you manage to get two "web" contexts? ...if you change it to "web2" (where id=1 and authority=9999), logout then back in, does that correct your issue?

        UPDATE modx_access_context SET target="web2" WHERE id=1 AND authority=9999; 
        



        @shaun, Should there perhaps be a UNIQUE index constraint placed on `modx_access_context`.`target`?
          Mike Reid - www.pixelchutes.com
          MODx Ambassador / Contributor
          [Module] MultiMedia Manager / [Module] SiteSearch / [Snippet] DocPassword / [Plugin] EditArea / We support FoxyCart
          ________________________________
          Where every pixel matters.
          • 9069
          • 18 Posts
          Quote from: pixelchutes at Aug 03, 2010, 11:16 AM

          Quote from: erunix at Aug 03, 2010, 11:08 AM

          Quote from: splittingred at Aug 03, 2010, 11:03 AM

          What are the records in the modx_access_context table?

          id target principal_class principal authority policy
          1 web modUserGroup 0 9999 3
          2 mgr modUserGroup 1 0 2
          3 web modUserGroup 1 0 2

          Umm... how did you manage to get two "web" contexts? ...if you change it to "web2" (where id=1 and authority=9999), logout then back in, does that correct your issue?

          UPDATE modx_access_context SET target="web2" WHERE id=1 AND authority=9999; 
          


          Did it and no juice still nothing on show up. I even created a new document and nothing. Clear my cache, etc. Even try with Safari.
            • 22303 MODX Staff
            • 10,725 Posts
            You can apply multiple policies to a single context; that is not an issue. It looks like you just applied restrictions to a different user group for web and now the Administrator can’t load it. That or you just didn’t flush permissions after making the changes.
              • 9069
              • 18 Posts
              Quote from: OpenGeek at Aug 03, 2010, 11:27 AM

              You can apply multiple policies to a single context; that is not an issue. It looks like you just applied restrictions to a different user group for web and now the Administrator can’t load it. That or you just didn’t flush permissions after making the changes.

              Flushed permissions, sessions. Relog and nothing. Should I redo a new fresh install once more?
                • 22303 MODX Staff
                • 10,725 Posts
                Quote from: erunix at Aug 03, 2010, 11:34 AM

                Quote from: OpenGeek at Aug 03, 2010, 11:27 AM

                You can apply multiple policies to a single context; that is not an issue. It looks like you just applied restrictions to a different user group for web and now the Administrator can’t load it. That or you just didn’t flush permissions after making the changes.

                Flushed permissions, sessions. Relog and nothing. Should I redo a new fresh install once more?
                That certainly isn’t gonna help anything, but I’m not sure since I don’t know what all you’ve done. Did you change the role of your admin user from Super User in the Administrators group?
                  • 9069
                  • 18 Posts
                  Quote from: OpenGeek at Aug 03, 2010, 11:41 AM


                  That certainly isn’t gonna help anything, but I’m not sure since I don’t know what all you’ve done. Did you change the role of your admin user from Super User in the Administrators group?

                  I didn’t touch anything besides creating the content after the install. So no I didn’t change role.
                    • 9069
                    • 18 Posts
                    I think i would be great if i record this behavior.
                      • 9069
                      • 18 Posts
                      Here is a screen shot of a fresh installation. Just log in after install, haven’t touch any setting or anything yet.