Android sqlite returned: error code = 1, msg = duplicate column name

Issue

05-30 11:29:43.854: I/SqliteDatabaseCpp(788): sqlite returned: error code = 1, msg = duplicate column name: call_time, db=/data/data/com.app.ts/databases/contacts_3.db

05-30 11:29:43.874: E/SQLiteOpenHelper(788): Couldn't open engrid_contacts_3.db for writing (will try read-only):

05-30 11:29:43.874: E/SQLiteOpenHelper(788): android.database.sqlite.SQLiteException: duplicate column name: call_time

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:89)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1933)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1864)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:223)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.content.ContentProvider$Transport.query(ContentProvider.java:192)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.content.ContentResolver.query(ContentResolver.java:302)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.FragmentManagerImpl.moveToState(FragmentManager.java:754)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.FragmentManagerImpl.moveToState(FragmentManager.java:926)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.BackStackRecord.run(BackStackRecord.java:578)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.FragmentManagerImpl.execPendingActions(FragmentManager.java:1226)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.FragmentManagerImpl$1.run(FragmentManager.java:374)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.os.Handler.handleCallback(Handler.java:587)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.os.Handler.dispatchMessage(Handler.java:92)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.os.Looper.loop(Looper.java:132)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at android.app.ActivityThread.main(ActivityThread.java:4025)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at java.lang.reflect.Method.invokeNative(Native Method)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at java.lang.reflect.Method.invoke(Method.java:491)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:841)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:599)

05-30 11:29:43.874: E/SQLiteOpenHelper(788): at dalvik.system.NativeStart.main(Native Method)

Answer

Check if you are trying to create a table with duplicate column name. In this case i was trying to create 2 columns with name call_time.