Android & SQLite: "Table audios has no column named downloaded"

Answer 1

I will hazard a guess that you have this in your code:

public static final String KEY_DOWNLOADED = "downloaded";

The reason for the error message is that...

table audios has no column named downloaded

Really. It doesn't, just as the error message says.

If you re-read your table-creation SQL, you'll notice that the column name is actually download, not downloaded.

So correct your code to use the correct column name and you should be set. Note that correcting the code could mean either:

1. changing the column name in your table to be downloaded instead of just download. Personally I would go with this one, unless you have lots of other code already using download, since download in my mind is either a download or to download, not has been downloaded, but it really depends on its actual meaning
2. changing the column name in the SQL that accesses the table to use the same column name as the table