abrignoni / abrignoni/iLEAPP

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

Offen
#1,092 2 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Vorherrschende Sprache
Python
Sterne
1.2k
Forks
303
Ø Merge
4 Std. 32 Min.
Gemergte PRs (30 T.)
216

Beschreibung

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!

Beitragsleitfaden

Für dieses Repository ist kein Beitragsleitfaden indexiert

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.