App does not import repetitions after 21-01-2023 even though the data is contained in the .db backup file

[Spiralo-Idioide]

Pre-submission checklist

• I am submitting a bug report, not a feature request.
• I have searched for similar issues, but did not find any matches.

Description

Yesterday I exported a full backup of my habits.

When I tried to import the backup I realized the data after 21-01-2023 was not present.
I first though the backup I just didn't contain the data. Maybe a bug in the export or an error on my end.

I then tried to open the db file with DB Browser for SQLite.
As seen in the screenshot the recent data is present in the db file. 1701734400000 is epoch for 05-12-2023.

I have tried investigating the structure of the database but it seems everything is normal.

Steps to reproduce

1. Go to Settings
2. Click on Import Data
3. Pick Loop Habits Backup 2023-12-05 184220.db
4. Data after 21-01-2023 is not imported

System information

• Phone: Unihertz Titan
• Phone Operating System: Android 10
• App version: 2.1.3 F-Droid and 2.1.3 Play Store (also tried F-Droid 2.1.1 and 2.1.2 with identical results)
• App version used to export data : most likely 2.1.3 F-Droid

Screenshots

Files

Loop Habits Backup 2023-12-05 184220.db.zip

[Spiralo-Idioide]

Test

I did a test to see if it is a problem for all imports or just for importing my backup :

1. Import the data backup I provided in the first post
2. Randomly modifying data in the last two month for one of the habits
3. Exporting a full backup
4. Uninstalling the App
5. Reinstalling the App
6. Import the new backup
7. The import of the randomly modified data backup worked

So it seems the problem is linked to a specific characteristic of my backup and not a problem for all imports. I am currently trying to find what is this characteristic.

[Spiralo-Idioide]

Update

Deleting all repetitions for an archived habits (Lamic 2) and the habits itself using DB Browser made the the import work.

I have no idea why.
I am not closing this bug report myself considering the cause of the bug has not been found even though I found a solution that worked for me.

Screenshot