Reading Fitness artifact had errors! - no such column: associations.child_id

[BrianMer]

Hi,

I was trying to parse the healthdb_secure.sqlite artifact from an iTunes backup, but the FitnessWorkoutsLocationData.py module crashes with this error:

Reading Fitness artifact had errors!
Error was no such column: associations.child_id
Exception Traceback: Traceback (most recent call last):
  File "ileapp.py", line 426, in crunch_artifacts
  File "C:\Users\DFIR\AppData\Local\Temp\_MEI94322\scripts\artifacts\FitnessWorkoutsLocationData.py", line 36, in get_Health
    cursor.execute('''
sqlite3.OperationalError: no such column: associations.child_id

After reviewing the table associations, the column does not exists. Here is the table creation statement:

CREATE TABLE "associations" (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, destination_object_id INTEGER, source_object_id INTEGER, sync_provenance INTEGER, sync_identity INTEGER NOT NULL, type INTEGER NOT NULL, deleted INTEGER NOT NULL, creation_date REAL NOT NULL, destination_sub_object_id INTEGER NULL, UNIQUE(destination_object_id, source_object_id))

Hope it helps!

Thanks!