Skip to content

[Bug]: database query local responds with zero events #715

@dnextcom

Description

@dnextcom

Client version

3.4.0

Node version

24.11.1

Operating System type

Windows

Operating system version

Windows 11

Describe the bug

I am querying the local database using "database query local" with different timeframes for start and end date but it always comes back with zero events.

However, if I query "database query latest" I get the latest event correctly!

This is for eufy smart door bell model T8214.

How can I get the information for all events in a timeframe?

To reproduce

  1. Connect the client
  2. Get a database query for "local" for start date=yesterday and end date=today, all event types

Screenshots & Logfiles

Return from local query:

{
  "type": "event",
  "event": {
    "source": "station",
    "event": "database query local",
    "serialNumber": "XXXXX",
    "returnCode": 0,
    "data": []
  }
}

Return from latest query:

{
  "type": "event",
  "event": {
    "source": "station",
    "event": "database query latest",
    "serialNumber": "XXXXX",
    "returnCode": 0,
    "data": [
      {
        "device_sn": "XXXXX",
        "event_count": 62,
        "crop_local_path": "/media/mmcblk0p1/Camera00/event/202512/20251201/20251201171029_snapshot.jpg"
      }
    ]
  }
}

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions