Activity Diary v1.2.2 crashes when I imported files with another extension

in #utopian-io6 years ago

Project Information
Repository: https://github.com/ramack/ActivityDiary
Project Name: Activity Diary

Expected behavior

Activity diary allows the import and export of a database which is saved in sqlite3 format. I expected that on importing the database and using any available file manager for that function, I'll only see the sqlite3 file in the directory where it was saved and even though other file formats can be seen, only the sqlite3 file can be imported successfully.

Actual behavior

When I select the import function, my file manager pops-up and some files are faded which indicates that the file can't be imported. However files in .pdf, .db, .kdbx etc formats can be imported and when it is imported, Activity diary said the import was successful but on going back to main menu, the app crashed.

How to reproduce

Ensure files of any of the aforementioned formats are available on your device.

  • launch the app
  • swipe from left to right to reveal menu
  • goto settings
  • scroll down to import database (exporting a database ain't really a necessary step to reproduce this)
  • browse directories to where any of the files is and select it
  • There's a toast message that import was successful
  • Go back to menu by pressing back button and the app crashes.

Test Enviroment

  • Software version: v 1.2.2
  • Device: Tecno Camon CM
  • Operating system: Android 7.0

Recording of the bug

Logcat

Process: de.rampro.activitydiary, PID: 19473
android.database.sqlite.SQLiteException: no such table: diary (code 1)
    at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
    at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:861)
    at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
    at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
    at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:154)
    at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:143)
    at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:219)
    at android.database.AbstractCursor.moveToFirst(AbstractCursor.java:258)
    at de.rampro.activitydiary.model.conditions.GlobalOccurrenceCondition.doEvaluation(GlobalOccurrenceCondition.java:63)
    at de.rampro.activitydiary.model.conditions.Condition$1.run(Condition.java:68)
    at java.lang.Thread.run(Thread.java:761)

The above logcat was gotten when I imported a .db file.

FATAL EXCEPTION: GlobalOccurrenceCondition-Thread-4
Process: de.rampro.activitydiary, PID: 18957
android.database.sqlite.SQLiteDatabaseCorruptException: file is encrypted or is not a database (code 26)
    at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
    at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:861)
    at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
    at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
    at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:154)
    at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:143)
    at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:219)
    at android.database.AbstractCursor.moveToFirst(AbstractCursor.java:258)
    at de.rampro.activitydiary.model.conditions.GlobalOccurrenceCondition.doEvaluation(GlobalOccurrenceCondition.java:63)
    at de.rampro.activitydiary.model.conditions.Condition$1.run(Condition.java:68)
    at java.lang.Thread.run(Thread.java:761)

This one was gotten when I imported a .kdbx(keepass) file

Both logcats seem slightly different.

This issue was opened on github and was acknowledged by the project owner.

Proof of Work Done

This is the link to my github account

Sort:  

Hello @kodeblacc,thank you for your contribution through the Utopian.You have done very good job,unfortunately this bug was already shared here.We appriciate your effort and also thank you for sharing it with the project owner.

Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord
utopian-moderator

Coin Marketplace

STEEM 0.18
TRX 0.15
JST 0.028
BTC 63099.80
ETH 2455.59
USDT 1.00
SBD 2.58