android.database.sqlite.SQLiteException: table contacts has no column named emailAddress (code 1): , while compiling: INSERT INTO contacts(emailAddress,lastName,phoneNumber,firstName,homeAddress) VALUES (?,?,?,?,?)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via newthinktank.com by Unknown author, 1 year ago
table contacts has no column named emailAddress (code 1): , while compiling: INSERT INTO contacts(emailAddress,lastName,phoneNumber,firstName,homeAddress) VALUES (?,?,?,?,?)
via Stack Overflow by Andy
, 2 years ago
table database_table has no column named table_row_three (code 1): , while compiling: INSERT INTO database_table(table_row_three,table_row_two,table_row_four,table_row_one) VALUES (?,?,?,?)
via Stack Overflow by levi mali
, 1 year ago
no such table: users_table (code 1): , while compiling: INSERT INTO users_table(EMAIL,USERNAME,NAME,PASSWORD) VALUES (?,?,?,?)
via blogspot.com by Unknown author, 2 years ago
no such table: users_table (code 1): , while compiling: INSERT INTO users_table(EMAIL,USERNAME,NAME,PASSWORD) VALUES (?,?,?,?)
via GitHub by drakeet
, 1 year ago
near "null": syntax error (code 1): , while compiling: INSERT INTO feed(null) VALUES (NULL)
via xluat.com by Unknown author, 2 years ago
table REGISTER has no column named NAME (code 1): , while compiling: INSERT INTO REGISTER(NAME,NUMBER) VALUES (?,?)
android.database.sqlite.SQLiteException: table contacts has no column named emailAddress (code 1): , while compiling: INSERT INTO contacts(emailAddress,lastName,phoneNumber,firstName,homeAddress) VALUES (?,?,?,?,?)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1013)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:624)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1467)
at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339)
at com.example.youtubeaddressbook.DBTools.insertContact(DBTools.java:43)
at com.example.youtubeaddressbook.NewContact.addNewContact(NewContact.java:47)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at android.view.View$1.onClick(View.java:3655)
at android.view.View.performClick(View.java:4162)
at android.view.View$PerformClick.run(View.java:17152)
at android.os.Handler.handleCallback(Handler.java:615)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:4867)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1007)

Users with the same issue

3 times, 1 year ago
7 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.