SQLiteException: near "s
Closed this issue · 0 comments
While retrieving resource from path, we can exception android.database.sqlite.SQLiteException: near "s": syntax error (code 1) complete crash report is below.
Log
APP_VERSION_CODE=12
APP_VERSION_NAME=Muses App version v0.012
ANDROID_VERSION=5.0.2
PHONE_MODEL=D6503
STACK_TRACE=java.lang.RuntimeException: An error occured while executing doInBackground()
at android.os.AsyncTask$3.done(AsyncTask.java:300)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355)
at java.util.concurrent.FutureTask.setException(FutureTask.java:222)
at java.util.concurrent.FutureTask.run(FutureTask.java:242)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
at java.lang.Thread.run(Thread.java:818)
Caused by: android.database.sqlite.SQLiteException: near "s": syntax error (code 1): , while compiling: SELECT id, description, path, condition, resourcetype, modification FROM resource WHERE path LIKE 'What's New'
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:895)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:506)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1202)
at eu.musesproject.client.db.handler.DBManager.getResourceFromPath(DBManager.java:1881)
at eu.musesproject.client.decisionmaker.DecisionMaker.makeDecision(DecisionMaker.java:310)
at eu.musesproject.client.usercontexteventhandler.UserContextEventHandler.retrieveDecision(UserContextEventHandler.java:265)
at eu.musesproject.client.usercontexteventhandler.UserContextEventHandler.send(UserContextEventHandler.java:196)
at eu.musesproject.client.contextmonitoring.UserContextMonitoringController.sendUserAction(UserContextMonitoringController.java:93)
at eu.musesproject.client.contextmonitoring.SensorController$ContextEventBus.onEvent(SensorController.java:278)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor.createContextEvent(AppSensor.java:126)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor.access$3(AppSensor.java:100)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor$AppObserver.doInBackground(AppSensor.java:194)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor$AppObserver.doInBackground(AppSensor.java:1)
at android.os.AsyncTask$2.call(AsyncTask.java:288)
at java.util.concurrent.FutureTask.run(FutureTask.java:237)
... 3 more
android.database.sqlite.SQLiteException: near "s": syntax error (code 1): , while compiling: SELECT id, description, path, condition, resourcetype, modification FROM resource WHERE path LIKE 'What's New'
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:895)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:506)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1202)
at eu.musesproject.client.db.handler.DBManager.getResourceFromPath(DBManager.java:1881)
at eu.musesproject.client.decisionmaker.DecisionMaker.makeDecision(DecisionMaker.java:310)
at eu.musesproject.client.usercontexteventhandler.UserContextEventHandler.retrieveDecision(UserContextEventHandler.java:265)
at eu.musesproject.client.usercontexteventhandler.UserContextEventHandler.send(UserContextEventHandler.java:196)
at eu.musesproject.client.contextmonitoring.UserContextMonitoringController.sendUserAction(UserContextMonitoringController.java:93)
at eu.musesproject.client.contextmonitoring.SensorController$ContextEventBus.onEvent(SensorController.java:278)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor.createContextEvent(AppSensor.java:126)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor.access$3(AppSensor.java:100)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor$AppObserver.doInBackground(AppSensor.java:194)
at eu.musesproject.client.contextmonitoring.sensors.AppSensor$AppObserver.doInBackground(AppSensor.java:1)
at android.os.AsyncTask$2.call(AsyncTask.java:288)
at java.util.concurrent.FutureTask.run(FutureTask.java:237)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
at java.lang.Thread.run(Thread.java:818)
LOGCAT=--------- beginning of main
[ 04-14 13:24:27.330 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:37.582 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:37.716 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:37.787 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:37.825 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:38.056 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:38.079 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:38.106 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:38.148 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:38.226 21604:21645 W/ProcessManager ]
waitpid on failed exec failed: No child processes
[ 04-14 13:24:44.015 21604:21646 W/ResourceType ]
Found multiple library tables, ignoring...
04-14 13:24:44.033 21604:21646 E/SQLiteLog near "s": syntax error
[ 04-14 13:24:44.035 21604:21646 E/ACRA ]
ACRA caught a RuntimeException exception for eu.musesproject.client. Building report.
[ 04-14 13:24:44.048 21604:21646 I/ACRA ]
READ_LOGS granted! ACRA can include LogCat and DropBox data.