abrignoni / abrignoni/iLEAPP

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

Aperta
#1,092 2 commenti 0 reazioni 0 assegnatari Vedi su GitHub
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.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.