abrignoni / abrignoni/iLEAPP

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

Abierto
#1,092 2 comentarios 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
1.2k
Forks
303
Merge medio
4 h 32 min
PR fusionados (30 d)
216

Descripción

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!

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.