Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » "Since last visit new" module question
 
Thread actions
PDF Print this page
  • Print all pages

    • "Since last visit new" module question

    Posted by nikosal posts: 98 Greece

    I use this specific module for some time now with no problem, but lately it... decided to show me ALL changes since a date two weeks ago. This way I now have a huge list of changes, and this list will not reset even if I log out and log in again.

    Why is that?

    Reads: 2475
    Link
    Posted by nikosal posts: 98 Greece

    Back here, to mention that clearing all cache doesn't solve the problem. Any other idea?

    I am stuck with an enormous "Multiple wiki pages changed, including..." and "new files" and "new users" list of entries "since June 5th", with no way to flash them on the horizon...

    Link

    Posted by Zac posts: 72 United States
    What version of Tiki are you using? I had this issue with some older versions (I think it was 8.x), but it was fixed with an upgrade.
    Link

    Posted by nikosal posts: 98 Greece
    It would be nice to be the version, but no: I always use the latest one.
    Link

    Posted by Tom Jarvis posts: 214

    I took a look at "function get_news_from_last_visit($user)", and it gets the last log in date from the users_users table, lastLogin column.
    You could check your last login date and time by going to MyTiki, MyInfo.

    I don't know if this is what the problem is, but do you have "Remember me" set? And maybe you have not logged in since that date?

    Tom

    Link

    Posted by nikosal posts: 98 Greece

    In database "lastLogin" column of users_users I don't get dates in a format I can undestand. What I get is numerical strings like -for example- 1392216349

    How do I translate them in real world dates?

    Link
    Posted by Tom Jarvis posts: 214

    The MySQL column is stored in timestamp format, the number of seconds since 00:00:00 UTC January 1, 1970.

    1392216349 is Wed, 12 Feb 2014 14:45:49 UTC.

    You can get it converted to a more readable date using SQL:
    SELECT FROM_UNIXTIME(`lastLogin`) FROM `users_users` WHERE `login` = '(your user name)';

    Or, I found this webpage where you can enter the timestamp and it will convert it for you: http://www.onlineconversion.com/unix_time.htm

    Tom

    Link