gistfile1.txt

E/SQLiteLog(14234): (1) ambiguous column name: conversation_id
D/AndroidRuntime(14234): Shutting down VM
E/AndroidRuntime(14234): FATAL EXCEPTION: IntentService[ScribeService]
E/AndroidRuntime(14234): Process: com.twitter.android, PID: 14234
E/AndroidRuntime(14234): android.database.sqlite.SQLiteException: ambiguous column name: conversation_id (code 1): , while compiling: CREATE VIEW dm_inbox AS SELECT conversations.conversation_id AS conversation_id,conversations.type AS type,conversations.title AS title,conversations.is_muted AS is_muted,conversations.last_readable_event_id>conversations.last_read_event_id AS is_unread,conversation_entries._id AS _id,conversation_entries.entry_id AS entry_id,conversation_entries.data AS data,conversation_entries.entry_type AS entry_type,conversation_entries.created AS created,most_recent_user.user_id AS user_id,most_recent_user.name AS s_name,most_recent_user.username AS s_username,most_recent_user.image_url AS s_profile_image_url,count(distinct(conversation_participants.user_id)) AS user_count,user_1.user_id AS user_id_1, user_1.name AS name_1, user_1.username AS username_1, user_1.image_url AS avatar_1,user_1.user_id AS avatar_1,user_2.user_id AS user_id_2, user_2.name AS name_2, user_2.username AS username_2, user_2.image_url AS avatar_2,user_3.user_id AS user_id_3, user_3.name AS name_3, user_3.username AS username_3, user_3.image_url AS avatar_3,user_4.user_id AS user_id_4, user_4.name AS name_4, user_4.username AS username_4, user_4.image_url AS avatar_4,user_5.user_id AS user_id_5, user_5.name AS name_5, user_5.username AS username_5, user_5.image_url AS avatar_5 FROM conversation_participants JOIN conversations   ON conversations.conversation_id=conversation_participants.conversation_id LEFT OUTER JOIN users AS user_1   ON user_1.user_id=     (SELECT user_id FROM conversation_participants WHERE conversation_id=conversations.conversation_id ORDER BY join_time ASC LIMIT 0,1) LEFT OUTER JOIN users AS user_2   ON user_2.user_id=     (SELECT user_id FROM conversation_participants WHERE conversation_id=conversations.conversation_id ORDER BY join_time ASC LIMIT 1,1) LEFT OUTER JOIN users AS user_3   ON user_3.user_id=     (SELECT user_id FROM conversation_participants WHERE conversation_id=conversations.conversation_id ORDER BY join_time ASC LIMIT 2,1) LEFT OUTER JOIN users AS user_4   ON user_4.user_id=     (SELECT user_id FROM conversation_participants WHERE conversation_id=conversations.conversation_id ORDER BY join_time ASC LIMIT 3,1) LEFT OUTER JOIN users AS user_5   ON user_5.user_id=     (SELECT user_id FROM conversation_participants WHERE conversation_id=conversations.conversation_id ORDER BY join_time ASC LIMIT 4,1) LEFT OUTER JOIN conversation_entries   ON conversation_entries.entry_id=     (SELECT entry_id FROM conversation_entries       WHERE conversation_id=conversations.conversation_id         AND entry_type IN (0,1,4)       ORDER BY entry_id DESC       LIMIT 1) LEFT OUTER JOIN users AS most_recent_user   ON most_recent_user.user_id = conversation_entries.user_id WHERE conversations.type IN (0,1) GROUP BY conversation_id;
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
E/AndroidRuntime(14234): 	at com.twitter.library.provider.bb.onCreate(Twttr:3032)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
E/AndroidRuntime(14234): 	at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
E/AndroidRuntime(14234): 	at com.twitter.library.provider.bb.getWritableDatabase(Twttr:3015)
E/AndroidRuntime(14234): 	at com.twitter.library.provider.bb.j(Twttr:12634)
E/AndroidRuntime(14234): 	at com.twitter.library.provider.bb.a(Twttr:2992)
E/AndroidRuntime(14234): 	at com.twitter.library.scribe.ScribeService.a(Twttr:576)
E/AndroidRuntime(14234): 	at 
I/am_crash(  793): [14234,0,com.twitter.android,8961604,android.database.sqlite.SQLiteException,ambiguous column name: conversation_id (code 1): , while compiling: CREATE VIEW dm_inbox AS SELECT conversations.conversation_id AS conversation_id,conversations.type AS type,conversations.title AS title,conversations.is_muted AS is_muted,conversations.last_readable_event_id>conversations.last_read_event_id AS is_unread,conversation_entries._id AS _id,conversation_entries.entry_id AS entry_id,conversation_entries.data AS data,conversation_entries.entry_type AS entry_type,conversation_entries.created AS created,most_recent_user.user_id AS user_id,most_recent_user.name AS s_name,most_recent_user.username AS s_username,most_recent_user.image_url AS s_profile_image_url,count(distinct(conversation_participants.user_id)) AS user_count,user_1.user_id AS user_id_1, user_1.name AS name_1, user_1.username AS username_1, user_1.image_url AS avatar_1,user_1.user_id AS avatar_1,user_2.user_id AS user_id_2, user_2.name AS name_2, user_2.username!