Conflicting data

Hi Chrisssssi,

thank you for letting us know about this issue. We were not able to replicate it on our test environment. However we would like to get in touch with you to troubleshoot the problem where it is happening. We suspect that your DB server’s time settings are different from your WEB server time settings. You may want to enable the corresponding option in the settings, to see if that fixes the problem in your case. If it doesn’t, please contact us at https://support.getused.to.it/

Thank you again for your feedback and for helping us make Slimstat a better tool!

Best,
Camu

I assume you are talking about reset timezone setting. This was enabled the whole time.

Yes, that’s the setting. What happens if you deactivate it?

Same behavior.

Example:
after klick on audience:
https://picturehost.eu/uploads/be7be5c90d60fb92b27acd2b5c79a770_1.png

now i clicked on last 60 days (nothing else changed):
https://picturehost.eu/uploads/99afff0cf2c6c4c001913c731f9ac329_2.png

Interesting. However from what I can see, it’s only affecting the chart, and no other reports. Can you check what time is it on your MySQL server ( select now() ) and on your WEB server ( <?php echo date(‘Ymd h:i a’) ?> ) and see what you get?

mysql
2015-01-31 17:38:21

php
20150131 05:38 pm

Did you use phpmyadmin? Could you do it either via command line or through a php script?

<?php echo “php: “.date(‘Ymd h:i a’).” – “;
$host = “x.de”;
$db = “x”;
$user = “xx”;
$pass = “xxx”;
$con = mysql_connect($host, $user, $pass) or die(mysql_error());

mysql_select_db($db, $con);
$query = “SELECT NOW() as datetime;”;
$result = mysql_query($query, $con);
$date = mysql_result($result,0,’datetime’);
echo “sql: “.$date;

?>

php: 20150131 06:52 pm – sql: 2015-01-31 18:52:50

Thank you for all the info and for your patience. We are trying to reproduce the issue on our end. I’ll get back to you asap.

Hi Chrisssssi,

it turns out you were right, there was a bug in calculating date ranges with intervals (both positive, like Jan 14 + 3 days, and negative, like Jan 14 – 3 days). Congrats on unearthing this problem! We are working on a patch, which will be included in the next update. If you want to help us test it out, please contact us through our support site ( support.getused.to.it ) so that I can send you a copy of the next release!

Hi Chrisssssi,

we just released version 3.9.4 which addresses the bug you found. Please feel free to test it thoroughly and let us know if the issue is resolved. We would also appreciate if you could update your vote accordingly ??

Best,
Camu

Hey,

seems to work now. Thanks for the quick fix.

You’re very welcome. Thank you for helping us make Slimstat a better product!