Activity chart days of the week are incorrect

[kellpossible]

Describe the bug

The days of the week are incorrect on the activity chart tooltips, there are two mondays.

System information
Please provide information on:

• Wakapi version v2.12.2 @ sqlite3
• Operating system
  • Docker: ghcr.io/muety/wakapi:2.12
• Database Sqlite

[muety]

That's weird! Can't reproduce this, my activity chart shows every day only exactly once 🤔. Will have a look at it, though.

[kellpossible]

I'll have another look again tomorrow! Perhaps it's something to do with my timezone settings

…

On Thu, 19 Dec 2024, 19:09 Ferdinand Mütsch, ***@***.***> wrote: That's weird! Can't reproduce this, my activity chart shows every day only exactly once 🤔. Will have a look at it, though. — Reply to this email directly, view it on GitHub <#719 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABCRJ2WEQ4XWUBQIIJVYX5D2GJ5MBAVCNFSM6AAAAABT32JLY2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNJTGAZDKOJQGA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[muety]

Did you perhaps change your time zone or something? Also, is either the 17th or the 18th missing instead? Can you possibly even share (via email) an excerpt from your heartbeats table around that date?

[muety]

Any updates on this?

[kellpossible]

Changing timezone to UTC appears to have no effect

[kellpossible]

Here's the SVG file with the bug present, notice the tooltips for the various dates.

[muety]

Can you do me another favor and show the results of the following SQL query, please?

select * from summaries where from_time between '2024-11-17' and '2024-11-20' and user_id = 'kellpossible';

(replace with your actual user id)

[muety]

Any updates on this?