Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » security system, no users shown....

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1 2 3
Go to End
Author Topic: 12314 Views
  • darkowl
    Avatar
    Community Member
    12 Posts

    Re: security system, no users shown.... Link to this post

    Very interesting... question for you, can you add / view members in the newsletter module?

    It seems that they use the same tables (site members and newsletter recipients), so could this be related to the issue that I've encountered here: http://www.silverstripe.com/site-builders-forum/flat/24702

    ?

    EDIT: Just had a look at the security section, lo and behold no users are shown (but are in the database). I'd say that they're related.

    MySQL version is 4.1.11

    Running the query from the previous page (modded for my setup), I get...

    SQL query:

    SELECT `Group_Members`.`ID` IN (SELECT `ID` FROM `Group_Members` WHERE `GroupID`='4' GROUP BY `MemberID` HAVING MIN(`ID`))

    MySQL said:

    #1109 - Unknown table 'Group_Members' in IN/ALL/ANY subquery

    Let's see if we can do something about that...

    EDIT 2: Yes indeed, it seems that HAVING MIN(`ID`) seems to be at fault. If it's removed, SilverStripe magically starts showing users again. I have no idea what repercussions that's going to have - hopefully none ;)

    The next question then, is *why* that code was failing silently (silent fails are never a good thing...)

  • Decisive Flow
    Avatar
    Community Member
    73 Posts

    Re: security system, no users shown.... Link to this post

    I have the same problem but don't really want to do anything until the 'official' fix is there.

    But I have a new live site and no access for my customer!

  • Hayden
    Avatar
    Core Development Team
    19 Posts

    Re: security system, no users shown.... Link to this post

    Does changing HAVING MIN(`ID`) to HAVING MIN(`ID`) = ID on line 143 of cms/code/MemberTableField.php help at all?

  • bbeer
    Avatar
    Community Member
    2 Posts

    Re: security system, no users shown.... Link to this post

    Hi
    OK same Problem here. The right side of the Security Panel stays empty. I don't see any users nor can I edit any groups. However I can add groups but not edit them.

    Thanks for your help!

  • bbeer
    Avatar
    Community Member
    2 Posts

    Re: security system, no users shown.... Link to this post

    OK I was able to solve my Problem.
    I had eAccelerator in PHP5 on, this prevented the users and Groups from being visible. I switched it off now all is perfect!

  • contigo
    Avatar
    Community Member
    16 Posts

    Re: security system, no users shown.... Link to this post

    I could not view users as well, Hayden's suggestion above did the trick.

  • mandrew
    Avatar
    Core Development Team
    32 Posts

    Re: security system, no users shown.... Link to this post

    Can someone confirm that this bug doesn't appear in the latest release candidate?

    If so then we need to know about it!

    Thanks

  • Decisive Flow
    Avatar
    Community Member
    73 Posts

    Re: security system, no users shown.... Link to this post

    haydens worked for me as well.. although I still don't think I can add new users - I can modify ones that exist though or something. Something seemed to work after a while anyway,

    12314 Views
Page: 1 2 3
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.