System timing wrong time

[gbrn]

@DanielnetoDotCom I don't understand how video time is measured. A 38-minute video watched by 2 users has the total hours watched as 5 hours and 39 minutes.

How does this system work, why this failure?

[DanielnetoDotCom]

if the video was in loop, it is possible

[gbrn]

Loop is disabled by default upon initial installation. So it's not Loop. And it wasn't done on purpose, so it's a bug. Could it be clear how this count is done?

[DanielnetoDotCom]

I cannot explanar you can look into the code to understand

You said it was made in propose, Can you help me reproduce this issue?

[gbrn]

I said it wasn't done on purpose. It wasn't me who caused it, it just happened.

[gbrn]

@DanielnetoDotCom Is there a bug in this count... see... now it shows 3 users and the time hasn't changed?

See video charts: Does the same movie mentioned above have 5 views? Is it 3 or 5? Totally inaccurate.

Something isn't working right...

[gbrn]

Detail that more than 5 hours was computed for a single user. I have no idea how this could happen... the player doesn't loop. I think some code modification will be necessary... to avoid this overflow.

[gbrn]

@DanielnetoDotCom Dani, were you able to verify any problems with views and time system?

[DanielnetoDotCom]

I am sorry not yet

[gbrn]

@DanielnetoDotCom I'm seeing worse and worse situations. See this one:

It wasn't supposed to be showing anything today! This movie is blocked!

The same information repeats itself....

I'm losing confidence in the system's measurements... as it's so inconsistent!

[DanielnetoDotCom]

those can be bots. I am not sure where those records come from. you may want to inspect the table videos_statistics

you will find a lot information on that table that will help you identify where does the views come from

[DanielnetoDotCom]

try this

SELECT `when`, ip
FROM videos_statistics 
WHERE DATE(`when`) = CURDATE() AND videos_id = your_video_id;