java.lang.RuntimeException: Unable to create service com.mattprecious.smsfix.library.FixService: android.database.sqlite.SQLiteException: no such column: sort_index: , while compiling: SELECT body, person, sub, subject, retr_st, type, date, ct_cls, sort_index, sub_cs, callback_number, _id, priority, read, ct_l, tr_id, st, msg_box, thread_id, reply_path_present, m_cls, read_status, failure_cause, ct_t, status, retr_txt_cs, d_rpt, error_code, m_id, m_type, v, exp, pri, service_center, address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM (SELECT thread_id AS tid, date * 1000 AS normalized_date, NULL AS body, NULL AS person, sub, NULL AS subject, retr_st, NULL AS type, date, ct_cls, sort_index, sub_cs, NULL AS callback_number, _id, NULL AS priority, read, ct_l, tr_id, st, msg_box, thread_id, NULL AS reply_path_present, m_cls, read_status, NULL AS failure_cause, ct_t, NULL AS status, retr_txt_cs, d_rpt, NULL AS error_code, m_id, m_type, v, exp, pri, NULL AS service_center, NULL AS address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM pdu WHERE ((msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) GROUP BY thread_id HAVING date = MAX(date) UNION SELECT thread_id AS tid, date * 1 AS normalized_date, body, person, NULL AS sub, subject, NULL AS retr_st, type, date, NULL AS ct_cls, sort_index, NULL AS sub_cs, callback_number, _id, priority, read, NULL AS ct_l, NULL AS tr_id, NULL AS st, NULL AS msg_box, thread_id, reply_path_present, NULL AS m_cls, NULL AS read_status, failure_cause, NULL AS ct_t, status, NULL AS retr_txt_cs, NULL AS d_rpt, error_code, NULL AS m_id, NULL AS m_type, NULL AS v, NULL AS exp, NULL AS pri, service_center, address, NULL AS rr, NULL AS rpt_a, NULL AS resp_txt, locked, NULL AS resp_st, NULL AS m_size FROM sms WHERE ((type != 3)) GROUP BY thread_id HAVING date = MAX(date)) GROUP BY tid HAVING normalized_date = MAX(normalized_date)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3043)
at android.app.ActivityThread.access$3500(ActivityThread.java:129)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2161)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:143)
at android.app.ActivityThread.main(ActivityThread.java:4701)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.SQLiteException: no such column: sort_index: , while compiling: SELECT body, person, sub, subject, retr_st, type, date, ct_cls, sort_index, sub_cs, callback_number, _id, priority, read, ct_l, tr_id, st, msg_box, thread_id, reply_path_present, m_cls, read_status, failure_cause, ct_t, status, retr_txt_cs, d_rpt, error_code, m_id, m_type, v, exp, pri, service_center, address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM (SELECT thread_id AS tid, date * 1000 AS normalized_date, NULL AS body, NULL AS person, sub, NULL AS subject, retr_st, NULL AS type, date, ct_cls, sort_index, sub_cs, NULL AS callback_number, _id, NULL AS priority, read, ct_l, tr_id, st, msg_box, thread_id, NULL AS reply_path_present, m_cls, read_status, NULL AS failure_cause, ct_t, NULL AS status, retr_txt_cs, d_rpt, NULL AS error_code, m_id, m_type, v, exp, pri, NULL AS service_center, NULL AS address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM pdu WHERE ((msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) GROUP BY thread_id HAVING date = MAX(date) UNION SELECT thread_id AS tid, date * 1 AS normalized_date, body, person, NULL AS sub, subject, NULL AS retr_st, type, date, NULL AS ct_cls, sort_index, NULL AS sub_cs, callback_number, _id, priority, read, NULL AS ct_l, NULL AS tr_id, NULL AS st, NULL AS msg_box, thread_id, reply_path_present, NULL AS m_cls, NULL AS read_status, failure_cause, NULL AS ct_t, status, NULL AS retr_txt_cs, NULL AS d_rpt, error_code, NULL AS m_id, NULL AS m_type, NULL AS v, NULL AS exp, NULL AS pri, service_center, address, NULL AS rr, NULL AS rpt_a, NULL AS resp_txt, locked, NULL AS resp_st, NULL AS m_size FROM sms WHERE ((type != 3)) GROUP BY thread_id HAVING date = MAX(date)) GROUP BY tid HAVING normalized_date = MAX(normalized_date)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:178)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:134)
at android.content.ContentProviderProxy.bulkQueryInternal(ContentProviderNative.java:373)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:409)
at android.content.ContentResolver.query(ContentResolver.java:247)
at com.mattprecious.smsfix.library.FixService.onCreate(FixService.java:95)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3033)
... 10 more
java.lang.RuntimeException: Unable to create service com.mattprecious.smsfix.library.FixService: android.database.sqlite.SQLiteException: no such column: d_ppt: , while compiling: SELECT body, person, sub, subject, retr_st, type, date, ct_cls, sort_index, sub_cs, callback_number, _id, priority, read, ct_l, tr_id, st, msg_box, thread_id, reply_path_present, m_cls, read_status, failure_cause, ct_t, status, retr_txt_cs, d_ppt, error_code, m_id, m_type, v, exp, pri, service_center, address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM (SELECT thread_id AS tid, date * 1000 AS normalized_date, NULL AS body, NULL AS person, sub, NULL AS subject, retr_st, NULL AS type, date, ct_cls, sort_index, sub_cs, NULL AS callback_number, _id, NULL AS priority, read, ct_l, tr_id, st, msg_box, thread_id, NULL AS reply_path_present, m_cls, read_status, NULL AS failure_cause, ct_t, NULL AS status, retr_txt_cs, d_ppt, NULL AS error_code, m_id, m_type, v, exp, pri, NULL AS service_center, NULL AS address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM pdu WHERE ((msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) GROUP BY thread_id HAVING date = MAX(date) UNION SELECT thread_id AS tid, date * 1 AS normalized_date, body, person, NULL AS sub, subject, NULL AS retr_st, type, date, NULL AS ct_cls, sort_index, NULL AS sub_cs, callback_number, _id, priority, read, NULL AS ct_l, NULL AS tr_id, NULL AS st, NULL AS msg_box, thread_id, reply_path_present, NULL AS m_cls, NULL AS read_status, failure_cause, NULL AS ct_t, status, NULL AS retr_txt_cs, NULL AS d_ppt, error_code, NULL AS m_id, NULL AS m_type, NULL AS v, NULL AS exp, NULL AS pri, service_center, address, NULL AS rr, NULL AS rpt_a, NULL AS resp_txt, locked, NULL AS resp_st, NULL AS m_size FROM sms WHERE ((type != 3)) GROUP BY thread_id HAVING date = MAX(date)) GROUP BY tid HAVING normalized_date = MAX(normalized_date)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3043)
at android.app.ActivityThread.access$3500(ActivityThread.java:129)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2161)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:143)
at android.app.ActivityThread.main(ActivityThread.java:4701)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.SQLiteException: no such column: d_ppt: , while compiling: SELECT body, person, sub, subject, retr_st, type, date, ct_cls, sort_index, sub_cs, callback_number, _id, priority, read, ct_l, tr_id, st, msg_box, thread_id, reply_path_present, m_cls, read_status, failure_cause, ct_t, status, retr_txt_cs, d_ppt, error_code, m_id, m_type, v, exp, pri, service_center, address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM (SELECT thread_id AS tid, date * 1000 AS normalized_date, NULL AS body, NULL AS person, sub, NULL AS subject, retr_st, NULL AS type, date, ct_cls, sort_index, sub_cs, NULL AS callback_number, _id, NULL AS priority, read, ct_l, tr_id, st, msg_box, thread_id, NULL AS reply_path_present, m_cls, read_status, NULL AS failure_cause, ct_t, NULL AS status, retr_txt_cs, d_ppt, NULL AS error_code, m_id, m_type, v, exp, pri, NULL AS service_center, NULL AS address, rr, rpt_a, resp_txt, locked, resp_st, m_size FROM pdu WHERE ((msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) GROUP BY thread_id HAVING date = MAX(date) UNION SELECT thread_id AS tid, date * 1 AS normalized_date, body, person, NULL AS sub, subject, NULL AS retr_st, type, date, NULL AS ct_cls, sort_index, NULL AS sub_cs, callback_number, _id, priority, read, NULL AS ct_l, NULL AS tr_id, NULL AS st, NULL AS msg_box, thread_id, reply_path_present, NULL AS m_cls, NULL AS read_status, failure_cause, NULL AS ct_t, status, NULL AS retr_txt_cs, NULL AS d_ppt, error_code, NULL AS m_id, NULL AS m_type, NULL AS v, NULL AS exp, NULL AS pri, service_center, address, NULL AS rr, NULL AS rpt_a, NULL AS resp_txt, locked, NULL AS resp_st, NULL AS m_size FROM sms WHERE ((type != 3)) GROUP BY thread_id HAVING date = MAX(date)) GROUP BY tid HAVING normalized_date = MAX(normalized_date)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:178)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:134)
at android.content.ContentProviderProxy.bulkQueryInternal(ContentProviderNative.java:373)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:409)
at android.content.ContentResolver.query(ContentResolver.java:247)
at com.mattprecious.smsfix.library.FixService.onCreate(FixService.java:95)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3033)
... 10 more
java.lang.RuntimeException: Unable to create service com.mattprecious.smsfix.FixService: android.database.sqlite.SQLiteException: no such column: htc_category: , while compiling: SELECT _id FROM sms WHERE ( htc_category= 0) ORDER BY _id DESC
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3140)
at android.app.ActivityThread.access$3300(ActivityThread.java:135)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2202)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:144)
at android.app.ActivityThread.main(ActivityThread.java:4937)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.SQLiteException: no such column: htc_category: , while compiling: SELECT _id FROM sms WHERE ( htc_category= 0) ORDER BY _id DESC
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:158)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:114)
at android.content.ContentProviderProxy.bulkQueryInternal(ContentProviderNative.java:372)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:408)
at android.content.ContentResolver.query(ContentResolver.java:245)
at com.mattprecious.smsfix.FixService.getLastMessageId(FixService.java:69)
at com.mattprecious.smsfix.FixService.onCreate(FixService.java:48)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:3125)
... 10 more