bug Continuous Trips

[SiNaPsEr0x]

this error on open page:

[jheredianet]

Hi, division by zero means an incomplete drive in this case.
It should be because you may have a wrong data recorded, meaning that does not have a start and end date. Check on the drives dashboard (from Teslamate) and look for any drive with not end date, or with zero or no duration, or no mileage recorder (a drive that has not been closed) as explained here: https://docs.teslamate.org/docs/maintenance/manually_fixing_data#terminate-a-drive-or-charge

[SiNaPsEr0x]

All drive have a start and end ... Can check with a command specific?

[jheredianet]

On thing you can do by browsing is to change the period as how on the image. For example, last week or last month until you find when you got that division by zero. You may also try with min distance value.

[SiNaPsEr0x]

I fixed the DB to delete drive without end date but same problem on select

[jheredianet]

Did you try what I've pointed on the previos message? Try to change the period to a short one to see what you get.

[SiNaPsEr0x]

With a shorter period it works

[jheredianet]

Perfect, so what you have to do is to open the period step by step (a week, a month or so) so you may find exactly which drive is causing you the division by zero.

[SiNaPsEr0x]

I order by null and nothing view

[jheredianet]

It's not enough, there are other tables implicated in the query. To make it easy, try to do it using the "continuous trips dashboard" as I explain you in my previos screenshot.

By the way, your query is wrong it should be:

SELECT * FROM drives WHERE end_date IS NULL;