API call failure when loading graph data

[mcardosodol]

Describe the bug
When attempting to load the historical graph data on the Detail page, an API call failure message is displayed, and the graph is stuck "Syncing" unable to display data.

This may possibly be related to Daylight Savings Time? The DST time change occurred at 02:00 on 3/9/2025 which coincides with the error message.

The full error message including log details have been included below

-------------------------------------------START OF ERROR MESSAGE--------------------------------------------

`We can't all be winners.
API call failed: Incorrect datetime value: '2025-03-09 02:00:00' for column 'timestamp' at row 1

Sorry about that! This error has been logged and will be investigated and appropriately punished. Please reach out to contact@beestat.io if it persists.

{
"success": false,
"data": {
"error_message": "Incorrect datetime value: '2025-03-09 02:00:00' for column 'timestamp' at row 1",
"error_code": 1292,
"error_detail": {
"file": "/var/www/beestat/api/cora/database.php",
"line": 368,
"trace": [
{
"file": "/var/www/beestat/api/cora/database.php",
"line": 368,
"function": "query",
"class": "mysqli",
"type": "->"
},
{
"file": "/var/www/beestat/api/cora/database.php",
"line": 752,
"function": "query",
"class": "cora\database",
"type": "->"
},
{
"file": "/var/www/beestat/api/runtime.php",
"line": 673,
"function": "create",
"class": "cora\database",
"type": "->"
},
{
"file": "/var/www/beestat/api/runtime.php",
"line": 419,
"function": "sync_runtime_thermostat",
"class": "runtime",
"type": "->"
},
{
"file": "/var/www/beestat/api/runtime.php",
"line": 280,
"function": "sync_",
"class": "runtime",
"type": "->"
},
{
"file": "/var/www/beestat/api/runtime.php",
"line": 85,
"function": "sync_forwards",
"class": "runtime",
"type": "->"
},
{
"function": "sync",
"class": "runtime",
"type": "->"
},
{
"file": "/var/www/beestat/api/cora/api_call.php",
"line": 169,
"function": "call_user_func_array"
},
{
"file": "/var/www/beestat/api/cora/request.php",
"line": 160,
"function": "process",
"class": "cora\api_call",
"type": "->"
},
{
"file": "/var/www/beestat/api/index.php",
"line": 47,
"function": "process",
"class": "cora\request",
"type": "->"
}
]`
----------------------------------------------END OF ERROR MESSAGE---------------------------------------------

To Reproduce
Browse to the Beestat "Detail" page

Screenshots

[mcardosodol]

Forgot to note that this is a self-hosted instance if that matters.

[gpz1100]

Are you on the latest source?

I was getting API errors last night ~2300 central, before the time change.

In fact, got this a day ago as well. I was on some older code, from over a year ago. Updating to current fixed things.

[mcardosodol]

Good thought! I did upgrade to the latest source about 2 months ago in early January but I just gave it a go right now and unfortunately I'm still seeing the same error message.

I thought it may potentially be something I was missing on the SQL side, but it looks like the last change to 'beestat.sql' was about 2 years ago and that was quite some time before I spun up my local instance.

[mcardosodol]

Finally found a workaround to this issue.

Since it seemed to be related to Daylight Savings Time, I was able to change the time zone of the Ubuntu server to UTC (Since MySQL is using the server's time zone) and this has allowed the UI to load properly without any errors.

Hope this helps anyone else that may be experiencing the issue.