# Sonata stats wrong start\_time

**URL:** <https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812>\
**Category:** Sonata Stats Issues\
**Created:** [September 26, 2022, 6:05am UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812 "2022-09-26T06:05:25Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [September 26, 2022, 6:05am UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/1 "2022-09-26T06:05:25Z")

</div>

Hi Vitalpbx Team,

Why is the start time not correct?

At 12:34 I have logged out of vitxi webrtc page then login then “login to queue”

It should be next record “start\_time” \> 12:34 but it appears at 12:30

 ![image](https://forums.vitalpbx.org/uploads/default/original/2X/4/49a80c92ba6f79ad9cd2a7a2b85cb5ba1ce268ea.png)

Is this a bug?

Thanks

---

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [September 27, 2022, 11:03am UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/2 "2022-09-27T11:03:37Z")

</div>

Hi Vitalpbx,

Any update about start\_hour?

Thanks

---

<div class="post-metadata">

**Author:** ![Roger](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/r/c0e974/32.png) [@Roger](https://forums.vitalpbx.org/u/Roger)\
**Post date:** [September 30, 2022, 10:58pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/3 "2022-09-30T22:58:10Z")

</div>

Hello,

We’ll proceed to do some tests and let you know what we find, also make sure you have set the report settings

---

<div class="post-metadata">

**Author:** ![Roger](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/r/c0e974/32.png) [@Roger](https://forums.vitalpbx.org/u/Roger)\
**Post date:** [October 5, 2022, 7:36pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/4 "2022-10-05T19:36:52Z")

</div>

Do you see the same result on any of the other session reports?

---

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [October 5, 2022, 10:12pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/5 "2022-10-05T22:12:46Z")

</div>

Hi Sir,

Yes I found also on other extensions

 ![image](https://forums.vitalpbx.org/uploads/default/original/2X/e/e50855ce4b7e5384a6049f70a673c67618fe02fe.png)

This only happens on Sep 26, 2022

Meanwhile, if I try today it runs normally.

 ![image](https://forums.vitalpbx.org/uploads/default/original/2X/3/3fdfa9293c674ca406791b9377227d18b2f13432.png)

Thanks

---

<div class="post-metadata">

**Author:** ![Roger](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/r/c0e974/32.png) [@Roger](https://forums.vitalpbx.org/u/Roger)\
**Post date:** [October 6, 2022, 8:05pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/6 "2022-10-06T20:05:13Z")

</div>

please execute the following commands and share the results for analysis

- mysql
- use asterisk;
- select \* from queues\_log where event = ‘ADDMEMBER’ and time between ‘2022-09-26 00:00:00’ and ‘2022-09-26 23:59:59’ order by time desc;

---

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [October 7, 2022, 10:34am UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/7 "2022-10-07T10:34:46Z")

</div>

> [@Roger](#):
>
> select \* from queues\_log where event = ‘ADDMEMBER’ and time between ‘2022-09-26 00:00:00’ and ‘2022-09-26 23:59:59’ order by time desc;

Hi Sir @Roger

This is the result query

 ![image](https://forums.vitalpbx.org/uploads/default/original/2X/c/cb171a647a590ba4b1b763e2591ed52f1a0d5f45.png)

Thanks

---

<div class="post-metadata">

**Author:** ![Roger](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/r/c0e974/32.png) [@Roger](https://forums.vitalpbx.org/u/Roger)\
**Post date:** [October 7, 2022, 3:36pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/8 "2022-10-07T15:36:22Z")

</div>

In the current implementation the records are ordered by agent and queue not by time, times are corret according to that data

---

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [October 7, 2022, 5:27pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/9 "2022-10-07T17:27:03Z")

</div>

Hi Sir,

May be easy to see report if you sort by agent, queue and time.

Thanks

---

<div class="post-metadata">

**Author:** ![Roger](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/r/c0e974/32.png) [@Roger](https://forums.vitalpbx.org/u/Roger)\
**Post date:** [October 7, 2022, 8:09pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/10 "2022-10-07T20:09:08Z")

</div>

Thank you for the suggestion we’ll consider adding filters for ordering results for a future update

---

<div class="post-metadata">

**Author:** ![x\_mos](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/x_mos/32/931_2.png) [@x\_mos](https://forums.vitalpbx.org/u/x_mos)\
**Post date:** [October 7, 2022, 11:41pm UTC](https://forums.vitalpbx.org/t/sonata-stats-wrong-start-time/1812/11 "2022-10-07T23:41:53Z")

</div>

Thanks @Roger & All vitalpbx team.