android.database.sqlite.SQLiteConstraintException in android

Question

android.database.sqlite.SQLiteConstraintException:

Logcat :

E/SQLiteDatabase: Error inserting Email_ID=1234567 USER_ID=abcd13 Password=a@g.com Mobile=1234567890 Name=asdf android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: User.USER_ID (code 1555) at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:780) at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1471) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341) at edmt.dev.androidgridlayout.DatabaseHelper.saveUserData(DatabaseHelper.java:555) at edmt.dev.androidgridlayout.Register$1.onClick(Register.java:80) at android.view.View.performClick(View.java:5207) at android.view.View$PerformClick.run(View.java:21168) at android.os.Handler.handleCallback(Handler.java:746) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:148) at android.app.ActivityThread.main(ActivityThread.java:5443) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:728) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618) Application terminated. 1 source edit rollback

Possible duplicate of [UNIQUE constraint failed: sqlite database : android](https://stackoverflow.com/questions/34980137/unique-constraint-failed-sqlite-database-android) — AskNilesh, Mar 16 '18 at 11:16
i cant find solution it appears whenever i try to insert values in signup form — gulam khan, Mar 16 '18 at 11:16
Slightly meta question, why did you rollback Nilesh's edit to make your question effectively unreadable again? — Michael Dodd, Mar 16 '18 at 12:12

score 3 · Answer 1 · answered Mar 16 '18 at 11:36

3

Your database already has row with USER_ID=adcd13, therefore you must either update the row or remove it and insert again.

answered Mar 16 '18 at 11:36

user2930077

135
2
9

can someone contact me my exams r there final year project submission i need to solve this... – gulam khan Apr 24 '18 at 18:03
Did you try to insert your data in empty database? I am sure, it will work fine. Because your error **E/SQLiteDatabase: Error inserting Email_ID=1234567 USER_ID=abcd13...** says ** UNIQUE constraint failed: User.USER_ID** – user2930077 Apr 26 '18 at 11:50

android.database.sqlite.SQLiteConstraintException in android

1 Answers1