search

federicoiosue / Omni-Notes

Open source note-taking application for Android
https://omninotes.app
GNU General Public License v3.0
2.67k stars 1.11k forks source link

Backup/Restore odd behavior #525

Open wesv opened 6 years ago

wesv commented 6 years ago

So, I recently had to factory reset my Axon 7 running android 7.1.1. I backed up my notes, copied them to my computer, then copied it back after the factory reset all under version 5.5.2. I went to restore the file, which the app claims to successfully do. I restarted the app via the notification icon, however, my notes didn't show up; it displays as if there are no notes. Since I backed up my settings, I tried changing one and retried the restore. The setting changed back correctly, but again the notes wouldn't show, even after the restart via both the notification and force closing the app. I then tried backing up the notes in app and noticed it backed up the notes correctly: the backup files are identical. Its like the app has the data stored correctly, but is displaying as if I don't have any notes.

sivaraam commented 6 years ago

This seems to be happening for me too on a Galaxy j1 ace running Android 5.1.1.

Wabo0 commented 5 years ago

Can confirm the same behavior on a Moto G6 running Android 9.

However this also happens when the backup is created on the same device/rom. I can add a note which is then displayed correctly (even when app is quit, device restarted, ...), backup, clear the apps storage, then restore from the backup and tap on the refresh notification. Now nothing is displayed anymore.

Following is adb logcat | grep Omni of above procedure after clearing the apps storage.

10-07 09:48:44.725  2706 20902 I ActivityManager: START u0 {act=org.fdroid.fdroid.installer.DefaultInstaller.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.4.5.apk cmp=org.fdroid.fdroid/.installer.DefaultInstallerActivity (has extras)} from uid 10068
10-07 09:48:44.725  2706 20902 W ActivityManager: startActivity called from non-Activity context; forcing Intent.FLAG_ACTIVITY_NEW_TASK for: Intent { act=org.fdroid.fdroid.installer.DefaultInstaller.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.4.5.apk cmp=org.fdroid.fdroid/.installer.DefaultInstallerActivity (has extras) }
10-07 09:48:44.765  2706  4352 I ActivityManager: START u0 {act=android.intent.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.4.5.apk flg=0x1 cmp=com.android.packageinstaller/.InstallStart (has extras)} from uid 10068
10-07 09:48:44.843  2706  4352 I ActivityManager: START u0 {act=android.intent.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.4.5.apk flg=0x2000000 cmp=com.android.packageinstaller/.InstallStaging (has extras)} from uid 10024
10-07 09:49:53.561  2706  2720 I ActivityManager: START u0 {act=org.fdroid.fdroid.installer.DefaultInstaller.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.5.2.apk cmp=org.fdroid.fdroid/.installer.DefaultInstallerActivity (has extras)} from uid 10068
10-07 09:49:53.562  2706  2720 W ActivityManager: startActivity called from non-Activity context; forcing Intent.FLAG_ACTIVITY_NEW_TASK for: Intent { act=org.fdroid.fdroid.installer.DefaultInstaller.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.5.2.apk cmp=org.fdroid.fdroid/.installer.DefaultInstallerActivity (has extras) }
10-07 09:49:53.601  2706  2720 I ActivityManager: START u0 {act=android.intent.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.5.2.apk flg=0x1 cmp=com.android.packageinstaller/.InstallStart (has extras)} from uid 10068
10-07 09:49:53.667  2706 20902 I ActivityManager: START u0 {act=android.intent.action.INSTALL_PACKAGE dat=content://org.fdroid.fdroid.installer.ApkFileProvider/files/Omni Notes-5.5.2.apk flg=0x2000000 cmp=com.android.packageinstaller/.InstallStaging (has extras)} from uid 10024
10-07 10:02:26.299  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42 parent: 10 storageID: 00010001
10-07 10:02:26.378  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42 _size=0 bucket_id=27988277 parent=529 date_added=1538899346 date_modified=1538899346 media_type=0 format=12289 title=2018.10.04-10 bucket_display_name=Omni Notes Foss
10-07 10:02:26.417  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/omni-notes parent: 457 storageID: 00010001
10-07 10:02:26.433  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/omni-notes _size=57344 bucket_id=-2027059036 parent=530 date_added=1538899346 date_modified=1538899346 media_type=0 format=12288 title=omni-notes bucket_display_name=2018.10.04-10.42
10-07 10:02:26.476  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/it.feio.android.omninotes.foss_preferences.xml parent: 457 storageID: 00010001
10-07 10:02:26.484  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/it.feio.android.omninotes.foss_preferences.xml _size=1741 bucket_id=-2027059036 parent=530 date_added=1538899346 date_modified=1538899346 media_type=0 format=12288 title=it.feio.android.omninotes.foss_preferences bucket_display_name=2018.10.04-10.42
10-07 10:02:26.522  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files parent: 457 storageID: 00010001
10-07 10:02:26.529  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files _size=0 bucket_id=-2027059036 parent=530 date_added=1538899346 date_modified=1538899346 media_type=0 format=12289 title=files bucket_display_name=2018.10.04-10.42
10-07 10:02:26.557  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20170315_130427_792.jpeg parent: 460 storageID: 00010001
10-07 10:02:26.630  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20170315_130427_792.jpeg _size=1641712 bucket_id=979893580 parent=533 date_added=1538899346 datetaken=1538899346000 date_modified=1538899346 mime_type=image/jpeg media_type=1 format=14337 title=20170315_130427_792 bucket_display_name=files
10-07 10:02:26.683  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20180617_124408_241.db parent: 460 storageID: 00010001
10-07 10:02:26.718  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20180617_124408_241.db _size=569344 bucket_id=979893580 parent=533 date_added=1538899346 date_modified=1538899346 media_type=0 format=12288 title=20180617_124408_241 bucket_display_name=files
10-07 10:02:26.775  4838 26636 D MtpServer: path: /storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20180912_194647_978.mp4 parent: 460 storageID: 00010001
10-07 10:02:28.089  4838 26636 E SQLiteDatabase: Error inserting _data=/storage/emulated/0/Omni Notes Foss/2018.10.04-10.42/files/20180912_194647_978.mp4 _size=26662032 bucket_id=979893580 parent=533 date_added=1538899348 datetaken=1538899348000 date_modified=1538899348 mime_type=video/mpeg media_type=3 format=12299 title=20180912_194647_978 bucket_display_name=files
10-07 10:06:29.372  2706  6232 I ActivityManager: START u0 {act=android.intent.action.SEND typ=text/plain flg=0x1 cmp=com.android.bluetooth/.opp.BluetoothOppLauncherActivity clip={text/plain T:Omni Notes (Note taking open-source application aimed to have both a simple interface but ke) - https://f-droid.org/app/it.feio.android.omninotes.foss} (has extras)} from uid 10068
10-07 10:13:27.095 27306 27439 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:27.096 27306 27439 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:13:27.141 27306 27306 D Omni Notes FOSS: initNotesList intent: null
10-07 10:13:27.142 27306 27349 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:13:27.145 27306 27349 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:27.179 27306 27306 D Omni Notes FOSS: Finished main menu initialization
10-07 10:13:27.180 27306 27306 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:13:27.180 27306 27346 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:13:27.180 27306 27306 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:13:27.188 27306 27306 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:13:27.191 27306 27306 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:13:27.191 27306 27306 D Omni Notes FOSS: Finished main menu initialization
10-07 10:13:27.191 27306 27306 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:13:27.192 27306 27347 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS: Error fetching app metadata
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
10-07 10:13:32.848 27454 27488 W Omni Notes FOSS:   at java.lang.Thread.run(Thread.java:764)
10-07 10:13:32.851 27454 27454 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:13:32.855 27454 27454 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:13:32.859 27454 27454 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, pref_tour_complete=true, settings_language=en_DE, acra.lastVersionNr=247, settings_current_app_version=247}
10-07 10:13:32.935 27454 27454 D Omni Notes FOSS: initNotesList intent: android.intent.action.MAIN
10-07 10:13:32.939 27454 27493 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:13:32.949 27454 27493 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:33.034 27454 27454 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:13:33.056 27454 27454 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:13:33.059 27454 27454 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:13:33.060 27454 27454 D Omni Notes FOSS: Finished main menu initialization
10-07 10:13:33.062 27454 27495 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  ORDER BY title||content ASC 
10-07 10:13:33.064 27454 27454 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:13:33.066 27454 27495 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:33.066 27454 27495 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:13:33.066 27454 27495 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS: Error fetching app metadata
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
10-07 10:13:47.188 27540 27561 W Omni Notes FOSS:   at java.lang.Thread.run(Thread.java:764)
10-07 10:13:47.193 27540 27540 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:13:47.197 27540 27540 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:13:47.266 27540 27540 D Omni Notes FOSS: initNotesList intent: android.intent.action.MAIN
10-07 10:13:47.269 27540 27562 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:13:47.282 27540 27540 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, settings_language=en_DE, acra.lastVersionNr=247}
10-07 10:13:47.321 27540 27562 I Omni Notes FOSS: Database creation
10-07 10:13:47.321 27540 27562 I Omni Notes FOSS:   exec sql file: {}create.sql
10-07 10:13:47.325 27540 27562 V Omni Notes FOSS:     sql: {}CREATE TABLE notes ( creation INTEGER PRIMARY KEY, last_modification INTEGER, title TEXT, content TEXT, archived INTEGER, trashed INTEGER, alarm INTEGER DEFAULT null, reminder_fired INTEGER, recurrence_rule TEXT, latitude REAL, longitude REAL, address TEXT, category_id INTEGER DEFAULT null, locked INTEGER, checklist  INTEGER )
10-07 10:13:47.326 27540 27562 V Omni Notes FOSS:     sql: {}CREATE TABLE attachments ( attachment_id INTEGER PRIMARY KEY AUTOINCREMENT, uri TEXT, name TEXT, size INTEGER, length INTEGER, mime_type TEXT, note_id INTEGER )
10-07 10:13:47.328 27540 27562 V Omni Notes FOSS:     sql: {}CREATE TABLE categories ( category_id INTEGER PRIMARY KEY, name TEXT, description TEXT, color TEXT )
10-07 10:13:47.331 27540 27562 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:47.461 27540 27540 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:13:47.482 27540 27540 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:13:47.484 27540 27540 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:13:47.485 27540 27540 D Omni Notes FOSS: Finished main menu initialization
10-07 10:13:47.487 27540 27561 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  ORDER BY title||content ASC 
10-07 10:13:47.488 27540 27561 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:47.488 27540 27540 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:13:47.489 27540 27561 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:13:47.489 27540 27561 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:13:47.492 27540 27566 I Omni Notes FOSS: System rebooted: service refreshing reminders
10-07 10:13:47.494 27540 27566 D Omni Notes FOSS: Notifies AppWidget data changed for widgets []
10-07 10:13:47.495 27540 27566 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE alarm IS NOT NULL AND reminder_fired IS NOT 1 AND archived IS NOT 1 AND trashed IS NOT 1 ORDER BY title||content ASC 
10-07 10:13:47.496 27540 27566 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:13:47.497 27540 27566 D Omni Notes FOSS: Found 0 reminders
10-07 10:13:56.667 27540 27540 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, pref_tour_complete=true, settings_language=en_DE, acra.lastVersionNr=247, settings_current_app_version=247}
10-07 10:14:09.722 27540 27592 D Omni Notes FOSS: Resettings reminders
10-07 10:14:09.724 27540 27592 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE alarm IS NOT NULL AND reminder_fired IS NOT 1 AND archived IS NOT 1 AND trashed IS NOT 1 ORDER BY title||content ASC 
10-07 10:14:09.725 27540 27592 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS: Error fetching app metadata
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
10-07 10:14:12.084 27602 27621 W Omni Notes FOSS:   at java.lang.Thread.run(Thread.java:764)
10-07 10:14:12.087 27602 27602 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:14:12.091 27602 27602 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:14:12.173 27602 27602 D Omni Notes FOSS: initNotesList intent: android.intent.action.MAIN
10-07 10:14:12.176 27602 27622 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:14:12.187 27602 27622 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:12.192 27602 27602 D Omni Notes FOSS: {settings_language=en_DE, acra.legacyAlreadyConvertedTo4.8.0=true, settings_password_access=false, pref_tour_complete=true, acra.lastVersionNr=247, settings_current_app_version=247}
10-07 10:14:12.264 27602 27602 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:14:12.289 27602 27602 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:14:12.292 27602 27602 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:14:12.293 27602 27602 D Omni Notes FOSS: Finished main menu initialization
10-07 10:14:12.294 27602 27624 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  ORDER BY title||content ASC 
10-07 10:14:12.296 27602 27624 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:12.296 27602 27602 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:14:12.297 27602 27624 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:14:12.297 27602 27624 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:14:13.582 27602 27602 V Omni Notes FOSS: Notes list: onViewTouchOccurred 0
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS: Error fetching app metadata
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
10-07 10:14:41.625 27645 27667 W Omni Notes FOSS:   at java.lang.Thread.run(Thread.java:764)
10-07 10:14:41.631 27645 27645 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:14:41.636 27645 27645 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:14:41.713 27645 27645 D Omni Notes FOSS: initNotesList intent: android.intent.action.MAIN
10-07 10:14:41.716 27645 27668 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:14:41.730 27645 27645 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, settings_language=en_DE, acra.lastVersionNr=247}
10-07 10:14:41.765 27645 27668 I Omni Notes FOSS: Database creation
10-07 10:14:41.765 27645 27668 I Omni Notes FOSS:   exec sql file: {}create.sql
10-07 10:14:41.768 27645 27668 V Omni Notes FOSS:     sql: {}CREATE TABLE notes ( creation INTEGER PRIMARY KEY, last_modification INTEGER, title TEXT, content TEXT, archived INTEGER, trashed INTEGER, alarm INTEGER DEFAULT null, reminder_fired INTEGER, recurrence_rule TEXT, latitude REAL, longitude REAL, address TEXT, category_id INTEGER DEFAULT null, locked INTEGER, checklist  INTEGER )
10-07 10:14:41.769 27645 27668 V Omni Notes FOSS:     sql: {}CREATE TABLE attachments ( attachment_id INTEGER PRIMARY KEY AUTOINCREMENT, uri TEXT, name TEXT, size INTEGER, length INTEGER, mime_type TEXT, note_id INTEGER )
10-07 10:14:41.770 27645 27668 V Omni Notes FOSS:     sql: {}CREATE TABLE categories ( category_id INTEGER PRIMARY KEY, name TEXT, description TEXT, color TEXT )
10-07 10:14:41.773 27645 27668 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:41.903 27645 27645 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:14:41.923 27645 27645 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:14:41.926 27645 27645 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:14:41.927 27645 27645 D Omni Notes FOSS: Finished main menu initialization
10-07 10:14:41.929 27645 27667 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  ORDER BY title||content ASC 
10-07 10:14:41.930 27645 27667 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:41.931 27645 27667 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:14:41.931 27645 27667 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:14:41.931 27645 27645 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:14:41.934 27645 27672 I Omni Notes FOSS: System rebooted: service refreshing reminders
10-07 10:14:41.936 27645 27672 D Omni Notes FOSS: Notifies AppWidget data changed for widgets []
10-07 10:14:41.937 27645 27672 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE alarm IS NOT NULL AND reminder_fired IS NOT 1 AND archived IS NOT 1 AND trashed IS NOT 1 ORDER BY title||content ASC 
10-07 10:14:41.938 27645 27672 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:14:41.939 27645 27672 D Omni Notes FOSS: Found 0 reminders
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS: Error fetching app metadata
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
10-07 10:15:29.580 27752 27791 W Omni Notes FOSS:   at java.lang.Thread.run(Thread.java:764)
10-07 10:15:29.584 27752 27752 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:15:29.588 27752 27752 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:15:29.591 27752 27752 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, acra.lastVersionNr=247, settings_language=en_DE}
10-07 10:15:29.667 27752 27752 D Omni Notes FOSS: initNotesList intent: android.intent.action.MAIN
10-07 10:15:29.669 27752 27792 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE archived IS NOT 1 AND trashed IS NOT 1  ORDER BY title||content ASC 
10-07 10:15:29.692 27752 27792 I Omni Notes FOSS: Database creation
10-07 10:15:29.692 27752 27792 I Omni Notes FOSS:   exec sql file: {}create.sql
10-07 10:15:29.695 27752 27792 V Omni Notes FOSS:     sql: {}CREATE TABLE notes ( creation INTEGER PRIMARY KEY, last_modification INTEGER, title TEXT, content TEXT, archived INTEGER, trashed INTEGER, alarm INTEGER DEFAULT null, reminder_fired INTEGER, recurrence_rule TEXT, latitude REAL, longitude REAL, address TEXT, category_id INTEGER DEFAULT null, locked INTEGER, checklist  INTEGER )
10-07 10:15:29.696 27752 27792 V Omni Notes FOSS:     sql: {}CREATE TABLE attachments ( attachment_id INTEGER PRIMARY KEY AUTOINCREMENT, uri TEXT, name TEXT, size INTEGER, length INTEGER, mime_type TEXT, note_id INTEGER )
10-07 10:15:29.701 27752 27792 V Omni Notes FOSS:     sql: {}CREATE TABLE categories ( category_id INTEGER PRIMARY KEY, name TEXT, description TEXT, color TEXT )
10-07 10:15:29.704 27752 27792 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:15:29.826 27752 27752 D Omni Notes FOSS: it.feio.android.omninotes.async.bus.NotesLoadedEvent
10-07 10:15:29.851 27752 27752 D Omni Notes FOSS: Started navigation drawer initialization
10-07 10:15:29.853 27752 27752 D Omni Notes FOSS: Finished navigation drawer initialization
10-07 10:15:29.853 27752 27752 D Omni Notes FOSS: Finished main menu initialization
10-07 10:15:29.857 27752 27791 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  ORDER BY title||content ASC 
10-07 10:15:29.857 27752 27752 D Omni Notes FOSS: Finished categories menu initialization
10-07 10:15:29.858 27752 27791 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:15:29.858 27752 27791 D Omni Notes FOSS: Dynamic menu finished counting items
10-07 10:15:29.858 27752 27791 E Omni Notes FOSS: Wrong element choosen: 0
10-07 10:15:29.862 27752 27797 I Omni Notes FOSS: System rebooted: service refreshing reminders
10-07 10:15:29.865 27752 27797 D Omni Notes FOSS: Notifies AppWidget data changed for widgets []
10-07 10:15:29.866 27752 27797 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE alarm IS NOT NULL AND reminder_fired IS NOT 1 AND archived IS NOT 1 AND trashed IS NOT 1 ORDER BY title||content ASC 
10-07 10:15:29.867 27752 27797 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:15:29.868 27752 27797 D Omni Notes FOSS: Found 0 reminders
10-07 10:15:40.088 27752 27752 D Omni Notes FOSS: {acra.legacyAlreadyConvertedTo4.8.0=true, pref_tour_complete=true, acra.lastVersionNr=247, settings_language=en_DE, settings_current_app_version=247}
10-07 10:15:54.114 27752 27840 D Omni Notes FOSS: Resettings reminders
10-07 10:15:54.117 27752 27840 V Omni Notes FOSS: Query: SELECT creation,last_modification,title,content,archived,trashed,alarm,reminder_fired,recurrence_rule,latitude,longitude,address,locked,checklist,category_id,name,description,color FROM notes LEFT JOIN categories USING( category_id)  WHERE alarm IS NOT NULL AND reminder_fired IS NOT 1 AND archived IS NOT 1 AND trashed IS NOT 1 ORDER BY title||content ASC 
10-07 10:15:54.117 27752 27840 V Omni Notes FOSS: Query: Retrieval finished!
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS: Error fetching app metadata
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS: java.net.MalformedURLException: no protocol: 
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:601)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:498)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at java.net.URL.<init>(URL.java:447)
10-07 10:15:57.648 2github7858 27878 W Omni Notes FOSS:     at it.feio.android.omninotes.async.UpdaterTask.getAppData(UpdaterTask.java:165)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:83)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at it.feio.android.omninotes.async.UpdaterTask.doInBackground(UpdaterTask.java:51)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at android.os.AsyncTask$2.call(AsyncTask.java:333)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
10-07 10:15:57.648 27858 27878 W Omni Notes FOSS:   at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
10-07 10:15:57.648 27858 27`
ionwerz commented 5 years ago

The same issue on Google Pixel with Android 9. I was trying to restore notes from backup, but list is empty all the time.

electro575 commented 5 years ago

Omni Notes FOSS: Error fetching app metadata

Same problem as "ionwerz" on Android 9.