Databases
StackOverflow2013
Postsdbo
POContentResolver query is throwing a nullpointerException
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POContentResolver query is throwing a nullpointerException
    primarykey
    data
    text
    <p>I'm writing an MMS/SMS application on a rooted Android 2.3.3 htc incredible S with sense 2.1. Now, while trying to receive a certain contacts list of SMS/MMS's I get a FC in the query.</p> <p>here's some code:</p> <pre><code>Uri uri = Uri.parse("content://mms-sms/conversations/"+String.valueOf(thread_id)); ContentResolver cr = context.getContentResolver(); Cursor c= cr.query(uri,null,null,null,null); //crashing here </code></pre> <p>logcat:</p> <pre><code>05-22 15:24:24.273: E/AndroidRuntime(32087): FATAL EXCEPTION: main 05-22 15:24:24.273: E/AndroidRuntime(32087): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.uiu.messaging/com.uiu.messaging.ContactMessageChain}: java.lang.NullPointerException 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1816) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1837) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread.access$1500(ActivityThread.java:132) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1033) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.os.Handler.dispatchMessage(Handler.java:99) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.os.Looper.loop(Looper.java:143) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread.main(ActivityThread.java:4196) 05-22 15:24:24.273: E/AndroidRuntime(32087): at java.lang.reflect.Method.invokeNative(Native Method) 05-22 15:24:24.273: E/AndroidRuntime(32087): at java.lang.reflect.Method.invoke(Method.java:507) 05-22 15:24:24.273: E/AndroidRuntime(32087): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839) 05-22 15:24:24.273: E/AndroidRuntime(32087): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597) 05-22 15:24:24.273: E/AndroidRuntime(32087): at dalvik.system.NativeStart.main(Native Method) 05-22 15:24:24.273: E/AndroidRuntime(32087): Caused by: java.lang.NullPointerException 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.os.Parcel.readException(Parcel.java:1328) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:160) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:114) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.content.ContentProviderProxy.bulkQueryInternal(ContentProviderNative.java:372) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.content.ContentProviderProxy.query(ContentProviderNative.java:408) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.content.ContentResolver.query(ContentResolver.java:264) 05-22 15:24:24.273: E/AndroidRuntime(32087): at com.uiu.messaging.Data.getContactChain(Data.java:319) 05-22 15:24:24.273: E/AndroidRuntime(32087): at com.uiu.messaging.ContactMessageChain.onCreate(ContactMessageChain.java:138) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1093) 05-22 15:24:24.273: E/AndroidRuntime(32087): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1780) 05-22 15:24:24.273: E/AndroidRuntime(32087): ... 11 more </code></pre> <p>All permissions are accounted for.</p> <p>Any help will be greatly appreciated.</p> <p>EDIT:</p> <p>After following Mike's suggestion I receive the following error in the logcat:</p> <pre><code>05-22 16:31:46.178: E/AndroidRuntime(1892): FATAL EXCEPTION: main 05-22 16:31:46.178: E/AndroidRuntime(1892): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.uiu.messaging/com.uiu.messaging.ContactMessageChain}: android.database.sqlite.SQLiteException: near "*": syntax error: , while compiling: SELECT * FROM (SELECT DISTINCT date * 1 AS normalized_date, NULL AS * FROM sms WHERE (htc_category= 0 AND thread_id = 25 AND (type != 3 AND type &gt; 0)) UNION SELECT DISTINCT date * 1000 AS normalized_date, NULL AS * FROM pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_id WHERE (htc_category= 0 AND thread_id = 25 AND msg_box != 3 AND (msg_box &gt; 0 AND msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) ORDER BY normalized_date ASC) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1816) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1837) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread.access$1500(ActivityThread.java:132) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1033) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.os.Handler.dispatchMessage(Handler.java:99) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.os.Looper.loop(Looper.java:143) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread.main(ActivityThread.java:4196) 05-22 16:31:46.178: E/AndroidRuntime(1892): at java.lang.reflect.Method.invokeNative(Native Method) 05-22 16:31:46.178: E/AndroidRuntime(1892): at java.lang.reflect.Method.invoke(Method.java:507) 05-22 16:31:46.178: E/AndroidRuntime(1892): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839) 05-22 16:31:46.178: E/AndroidRuntime(1892): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597) 05-22 16:31:46.178: E/AndroidRuntime(1892): at dalvik.system.NativeStart.main(Native Method) 05-22 16:31:46.178: E/AndroidRuntime(1892): Caused by: android.database.sqlite.SQLiteException: near "*": syntax error: , while compiling: SELECT * FROM (SELECT DISTINCT date * 1 AS normalized_date, NULL AS * FROM sms WHERE (htc_category= 0 AND thread_id = 25 AND (type != 3 AND type &gt; 0)) UNION SELECT DISTINCT date * 1000 AS normalized_date, NULL AS * FROM pdu LEFT JOIN pending_msgs ON pdu._id = pending_msgs.msg_id WHERE (htc_category= 0 AND thread_id = 25 AND msg_box != 3 AND (msg_box &gt; 0 AND msg_box != 3 AND (m_type = 128 OR m_type = 132 OR m_type = 130))) ORDER BY normalized_date ASC) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:158) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:114) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.content.ContentProviderProxy.bulkQueryInternal(ContentProviderNative.java:372) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.content.ContentProviderProxy.query(ContentProviderNative.java:408) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.content.ContentResolver.query(ContentResolver.java:264) 05-22 16:31:46.178: E/AndroidRuntime(1892): at com.uiu.messaging.Data.getContactChain(Data.java:318) 05-22 16:31:46.178: E/AndroidRuntime(1892): at com.uiu.messaging.ContactMessageChain.onCreate(ContactMessageChain.java:138) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1093) 05-22 16:31:46.178: E/AndroidRuntime(1892): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1780) 05-22 16:31:46.178: E/AndroidRuntime(1892): ... 11 more </code></pre> <p>I have no idea what's wrong with the SQL statement...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USzwebie
    1. USzwebie
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. USdor506
      1. VTFavorite
    1. COAttaching the stack trace from logcat is usually wise.
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. USJens
    2. COWhat is the value of the uri before calling query?
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. USMikeIsrael
    3. COas written above the thread_id is a long
      singulars
      1. POContentResolver query is throwing a nullpointerException
      1. USzwebie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload