android.database.sqlite.SQLiteConstraintException in android

Question

android.database.sqlite.SQLiteConstraintException:

Logcat :

E/SQLiteDatabase: Error inserting Email_ID=1234567 USER_ID=abcd13 [email protected] 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 — AskNilesh
– AskNilesh, Commented Mar 16, 2018 at 11:16
i cant find solution it appears whenever i try to insert values in signup form — gulam khan
– gulam khan, Commented Mar 16, 2018 at 11:16
Slightly meta question, why did you rollback Nilesh's edit to make your question effectively unreadable again? — Michael Dodd
– Michael Dodd, Commented Mar 16, 2018 at 12:12

user2930077 · Accepted Answer · 2018-03-16 11:36:03Z

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, 2018 at 11:36

user2930077

1351 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

gulam khan Over a year ago

can someone contact me my exams r there final year project submission i need to solve this...

user2930077 Over a year ago

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**

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteConstraintException in android

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related