TypeError: the JSON object must be str, bytes or bytearray, not NoneType about hass-data-detective HOT 5 CLOSED

I have the same problem. Also the fetch_all_sensor_data function returns None for every sensor in the last_updated field. I think both of these errors come from a recent change in database schema. last_updated for example was replaced by last_updated_ts.

from hass-data-detective.

Hmm to debug need to understand what is wrong with the data you are trying to access. You can see the queries being run in https://github.com/robmarkcole/HASS-data-detective/blob/master/detective/core.py so try and debug where this error is coming from

from hass-data-detective.

Hi, I started the core.py in jupyter lab (right?) and get this:

---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
Cell In [1], line 10
      7 import pandas as pd
      8 from sqlalchemy import create_engine, text
---> 10 from . import config, functions
     13 def db_from_hass_config(path=None, **kwargs):
     14     """Initialize a database from HASS config."""

ImportError: attempted relative import with no known parent package

from hass-data-detective.

I am having the exact same issue.
Did anyone get this solved? Thanks!

from hass-data-detective.

I have the same problem. Also the fetch_all_sensor_data function returns None for every sensor in the last_updated field. I think both of these errors come from a recent change in database schema. last_updated for example was replaced by last_updated_ts.
@bernikr

Wow, thanks! I just substituted all the occurrences of last_updated into last_updated_ts in all code and reinstalled the detective and it worked! Now, Instead of getting None for the the field you get timestamp numbers.
Conversion can be easily done by:
df['last_updated_ts'] = pd.to_datetime(df['last_updated_ts'], unit='s')

from hass-data-detective.