"Since last visit new" module question Posted by nikosal 22 Jun 2014 07:59 GMT-0000 posts: 98 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?
Posted by nikosal 25 Jun 2014 15:04 GMT-0000 posts: 98 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...
Posted by Zac 02 Jul 2014 13:44 GMT-0000 posts: 72 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.
Posted by nikosal 05 Jul 2014 16:54 GMT-0000 posts: 98 It would be nice to be the version, but no: I always use the latest one.
Posted by nikosal 10 Jul 2014 15:43 GMT-0000 posts: 98 Uninstalling the module, clearing all cache and reinstalling it didn't solve my problem. I am stuck with a list with the dozens of changes done since this specific date, 05-06-2014. Any other idea? Screenshot from 2014-07-10 18:40:35.png (16.53 Kb)
Posted by Tom Jarvis 10 Jul 2014 17:23 GMT-0000 posts: 215 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
Posted by nikosal 11 Jul 2014 15:45 GMT-0000 posts: 98 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?
Posted by Tom Jarvis 11 Jul 2014 16:25 GMT-0000 posts: 215 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