Android待办列表开发报错：CursorWindow无法读取第0行第3列

Hey there! Let’s work through this frustrating CursorWindow error you’re facing. Even though you’re sure your database has 4 columns (indices 0-3), the error tells us the Cursor you’re working with only has 3 columns. Here are the most common reasons this happens, plus fixes to try:

• Your query isn’t selecting the 4th column
  Just because your table has 4 columns doesn’t mean every query returns all of them. If your SELECT statement only pulls 3 columns (e.g., SELECT id, title, note FROM tasks), the resulting Cursor will only have those 3 columns—so trying to access index 3 will throw this error.
  Fix: Double-check your SQL query to make sure it includes the 4th column you need. Instead of hardcoding columns, you can list them explicitly (better practice) or use SELECT * (though explicit is safer for future changes).

• You’re using hardcoded column indices incorrectly
  It’s easy to mix up which column maps to which index. For example, if you added the 4th column later, maybe your mental map of indices is out of sync with the actual query result.
  Fix: Replace hardcoded indices with cursor.getColumnIndex("your_column_name"). This method returns the correct index for the given column name, eliminating guesswork. Example:

  int completedIndex = cursor.getColumnIndex("is_completed");
  boolean taskCompleted = cursor.getInt(completedIndex) == 1;
  

• Database schema mismatch (upgrade issue)
  If you recently added the 4th column to your table but didn’t properly handle database upgrades, the actual database on your test device/emulator might still have only 3 columns. Old data doesn’t automatically update when you change your schema code.
  Fix: Uninstall and reinstall your app to reset the database (good for testing), or update your SQLiteOpenHelper’s onUpgrade method to alter the table and add the missing column for existing users.

• You forgot to move the Cursor to a valid row
  Before reading data, you need to position the Cursor on an existing row. If you skip calling cursor.moveToFirst() or cursor.moveToNext(), the Cursor stays at an invalid position, and any column read will fail (even if the column exists).
  Fix: Always wrap your Cursor reads in a check like this:

  if (cursor != null && cursor.moveToFirst()) {
      // Read your columns here
  }
  

Quick Debugging Tip #

To confirm what’s actually in your Cursor, add these lines before trying to read columns:

Log.d("CursorDebug", "Total columns: " + cursor.getColumnCount());
for (int i = 0; i < cursor.getColumnCount(); i++) {
    Log.d("CursorDebug", "Column " + i + ": " + cursor.getColumnName(i));
}

This will print the number of columns and their names, so you can verify if your 4th column is actually present in the Cursor.

内容的提问来源于stack exchange，提问作者user3906610