Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bjørn Fridal 274 posts 784 karma points
    Dec 08, 2011 @ 12:07
    Bjørn Fridal
    0

    Not always logged?

    Hi,

    This is a great package. I currently have to upgrade a test site, while a couple of editors are working on a different part of the site. Therefore I thought it might be helpfull for me to be able to see when they are logged in. However the last entry in recent logins are from two days ago, but I can see that the editors are adding new pages as I write this post. I don't think that the package is doing anything wrong, since I have been watching all the entries in umbracoUserLogins and they are the same as those the package shows.

    Therefore could it be that Umbraco doesn't log all users or clears the entries again in some circumstances?

    Cheers
    Bjørn Fridal

  • Josh Townson 67 posts 162 karma points
    Dec 08, 2011 @ 13:22
    Josh Townson
    0

    Hi Bjørn,

    Glad you like the package! I did notice a problem with the validation on number of days - I forgot to set the data type to numeric, so some values which should be valid are not, but that shouldn't actually cause a problem where logged in users don't show up.

    Can I ask what version of Umbraco you are using. The user logins table usage has changed somewhat since I wrote the package. I've not tested it on a 4.7.1 site yet either. I can't think of any way that users can edit the site without being logged in under normal circumstances. I have found that the couple of 4.7.1 instances I have, I stay logged in for about a day - so when I come back to the admin system the next day, I am still logged in - I just haven't used this package on any of those sites to know whether there are entries in the logins table!

    I'll try to have a look later to see how different the umbraco code for managing logins/sessions is. in 4.7.1 this weekend. Its a busy time for me at the moment - I've just got back to work after the arrival of my second child, so I'm catching up on work!

    Cheers,
    Josh

  • Bjørn Fridal 274 posts 784 karma points
    Dec 08, 2011 @ 13:52
    Bjørn Fridal
    0

    Hi Josh,

    Thanks for the prompt reply and congrats on you second child :)

    I am running an Umbraco 4.7.1 installation. I haven't used it on any other installations so I can only speak in regards to this one. It looks to me like that there simply are no more entries in the table than those your package shows. But maybe I am missing somthing here.

    Cheers
    Bjørn 

  • Josh Townson 67 posts 162 karma points
    Dec 08, 2011 @ 14:20
    Josh Townson
    0

    Hi Bjørn,

    The package runs the following SQL query:

    SELECT l.contextID, l.userID, l.timeout, u.userName
    FROM umbracoUserLogins l
    INNER JOIN umbracoUser u ON u.id = l.userID
    WHERE l.timeout > ??? <- this comes from .NET, and is DateTime.Now.Ticks
    ORDER BY l.timeout DESC

    so it should be the contents of that table. My limited experience with 4.7.1 leads me to suspect that this table isn't all the pieces of the puzzle any more. But I won't know until I have some time to step through what happens.

    /Josh

Please Sign in or register to post replies

Write your reply to:

Draft