View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000778 | MyArchiveMobile | development | public | 2020-10-08 05:36 | 2020-10-08 06:03 |
| Reporter | domjos | Assigned To | domjos | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 1.3 | ||||
| Target Version | 1.4 | Fixed in Version | 1.4 | ||
| Summary | 0000778: Error entering data to category | ||||
| Description | E/SQLiteLog: (1) near ")": syntax error E/Exception: Error android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR): , while compiling: SELECT id, title, cover, type FROM media WHERE (type='movies' AND category like '%Ab%' AND ()) OR (type='albums' AND category like '%Ab%' AND ()) OR (type='games' AND category like '%Ab%' AND ()) LIMIT 100 OFFSET 0 at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1443) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1382) at de.domjos.myarchivelibrary.database.Database.getObjectList(Database.java:128) at de.domjos.myarchivemobile.helper.ControlsHelper.getAllMediaItems(ControlsHelper.java:301) at de.domjos.myarchivemobile.helper.ControlsHelper.getAllMediaItems(ControlsHelper.java:296) at de.domjos.myarchivemobile.tasks.LoadingTask.doInBackground(LoadingTask.java:79) at de.domjos.myarchivemobile.tasks.LoadingTask.doInBackground(LoadingTask.java:43) at android.os.AsyncTask$3.call(AsyncTask.java:378) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:289) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at java.lang.Thread.run(Thread.java:919) D/EGL_emulation: eglMakeCurrent: 0xd7a1a420: ver 2 0 (tinfo 0xd7a0f980) D/EGL_emulation: eglMakeCurrent: 0xd7a1a420: ver 2 0 (tinfo 0xd7a0f980) D/EGL_emulation: eglMakeCurrent: 0xd7a1a420: ver 2 0 (tinfo 0xd7a0f980) D/EGL_emulation: eglMakeCurrent: 0xd7a1a420: ver 2 0 (tinfo 0xd7a0f980) | ||||
| Tags | No tags attached. | ||||
| GIT Revision | 9ba40e1fa7966ad359704f67261b96038f99309c | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-10-08 05:36 | domjos | New Issue | |
| 2020-10-08 05:36 | domjos | Status | new => assigned |
| 2020-10-08 05:36 | domjos | Assigned To | => domjos |
| 2020-10-08 06:03 | domjos | Status | assigned => resolved |
| 2020-10-08 06:03 | domjos | Resolution | open => fixed |
| 2020-10-08 06:03 | domjos | Fixed in Version | => 1.4 |
| 2020-10-08 06:03 | domjos | GIT Revision | => 9ba40e1fa7966ad359704f67261b96038f99309c |
