************ 27-6-2015 HH:56:35 **********
BloodFinder com.uvj.bloodfinder 4.2.2 Android 1.0.1 8695370116e6d97db3673ec871ed845b 175 9526851474 Achu Aswathy java.lang.RuntimeException: Unable to start receiver com.uvj.bloodfinder.NotifyProviderReceiver: android.database.sqlite.SQLiteException: near "ANDCASE": syntax error (code 1): , while compiling: SELECT req.request_id, service_name, provider_latitude, provider_longitude, provider_distance, request_due_date, request_activeto_date, request_details, request_cancelled, request_submit_date, request_modify_date, request_reinitiated_count,request_units, cnt.is_bid_accepted FROM tbl_my_requests AS req JOIN tbl_responses_count AS cnt ON req.request_id = cnt.request_id WHERE cnt.is_bid_accepted =1 AND request_cancelled != 1 ANDCASE WHEN request_due_date = '0000-00-00 00:00:00' THEN datetime(request_submit_date, '+48 hour') < datetime ('2015-06-27 13:56:25') ELSE request_due_date < datetime ('2015-06-27 13:56:25') END AND req.request_id IN (SELECT request_id from tbl_requests_review_notify WHERE shown_notification = 0)ORDER BY req.request_id ASC at android.app.ActivityThread.handleReceiver(ActivityThread.java:2383) at android.app.ActivityThread.access$1500(ActivityThread.java:141) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1310) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:137) at android.app.ActivityThread.main(ActivityThread.java:5041) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:511) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560) at dalvik.system.NativeStart.main(Native Method) Caused by: android.database.sqlite.SQLiteException: near "ANDCASE": syntax error (code 1): , while compiling: SELECT req.request_id, service_name, provider_latitude, provider_longitude, provider_distance, request_due_date, request_activeto_date, request_details, request_cancelled, request_submit_date, request_modify_date, request_reinitiated_count,request_units, cnt.is_bid_accepted FROM tbl_my_requests AS req JOIN tbl_responses_count AS cnt ON req.request_id = cnt.request_id WHERE cnt.is_bid_accepted =1 AND request_cancelled != 1 ANDCASE WHEN request_due_date = '0000-00-00 00:00:00' THEN datetime(request_submit_date, '+48 hour') < datetime ('2015-06-27 13:56:25') ELSE request_due_date < datetime ('2015-06-27 13:56:25') END AND req.request_id IN (SELECT request_id from tbl_requests_review_notify WHERE shown_notification = 0)ORDER BY req.request_id ASC at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493) 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:1314) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253) at com.uvj.bloodfinder.data.database.DatabaseHandler.getExpiredMyRequests(DatabaseHandler.java:3608) at com.uvj.bloodfinder.NotifyProviderReceiver.onReceive(NotifyProviderReceiver.java:59) at android.app.ActivityThread.handleReceiver(ActivityThread.java:2376) ... 10 more