Chapter 10 Earthquake 2

MellowFellow · September 13th, 2010, 02:31 PM

I'm getting a force close when trying to open the live folder on the Home Screen. It is telling me that one of the column names does not exist. See initial part of error message below:

09-13 12:39:47.833: INFO/Database(448): sqlite returned: error code = 1, msg = no such column: name
09-13 12:39:47.922: ERROR/DatabaseUtils(448): Writing exception to parcel
09-13 12:39:47.922: ERROR/DatabaseUtils(448): android.database.sqlite.SQLiteException: no such column: name: , while compiling: SELECT * FROM earthquakes ORDER BY name ASC

Any ideas on how to resolve this?

MellowFellow · September 13th, 2010, 02:41 PM

I found the correct code on anther post:

Code:

static {
		uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
		uriMatcher.addURI("com.paad.provider.earthquake", "earthquakes", QUAKES);
		uriMatcher.addURI("com.paad.provider.earthquake", "earthquakes/#", QUAKE_ID);
		uriMatcher.addURI("com.paad.provider.earthquake", "live_folder", LIVE_FOLDER)
}