Reading Fitness artifact had errors! - no such column: associations.child_id
- Lingua principale
- Python
- Stelle
- 1.2k
- Fork
- 303
- Merge medio
- 4h 32m
- PR unite (30g)
- 216
Descrizione
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!
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Valutazione
Questa issue non è ancora stata valutata.