android.database.sqlite.SQLiteException

no such column: image (code 1): , while compiling: SELECT id, nameDefault, name, image FROM contacts WHERE id=?


Solutions on the web1792

Solution icon of stackoverflow
via Stack Overflow by Ghost
, 7 months ago
no such column: image (code 1): , while compiling: SELECT id, nameDefault, name, image FROM contacts WHERE id=?

Solution icon of stackoverflow
via Stack Overflow by John
, 11 months ago
no such column: alex (code 1): , while compiling: SELECT Image FROM User WHERE Name = alex

Solution icon of stackoverflow
no such column: task2 (code 1): , while compiling: SELECT id, name, image, task1, task2, task3 FROM tblmypets

Solution icon of stackoverflow
via Stack Overflow by Unknown author, 1 year ago
no such column: image (code 1): , while compiling: SELECT DISTINCT _id, task, date, image FROM mainToDo

Solution icon of github
via GitHub by door43app
, 1 year ago
no such column: language_code (code 1): , while compiling: SELECT language_code FROM languages WHERE id = '-1'

Solution icon of github
via GitHub by door43app
, 1 year ago
no such column: language_code (code 1): , while compiling: SELECT language_code FROM languages WHERE id = '-1'

Solution icon of github
via GitHub by door43app
, 1 year ago
no such column: language_code (code 1): , while compiling: SELECT language_code FROM languages WHERE id = '-1'

Solution icon of stackoverflow
no such column: ۱۴۱۰۸۷۶۰۹۷۸۰۷ (code 1): , while compiling: SELECT * FROM favorites WHERE id=۱۴۱۰۸۷۶۰۹۷۸۰۷ ;

Solution icon of github
via GitHub by door43app
, 1 year ago
no such column: language_code (code 1): , while compiling: SELECT language_code FROM languages WHERE id = '-1'

Solution icon of github
via GitHub by door43app
, 1 year ago
no such column: language_code (code 1): , while compiling: SELECT language_code FROM languages WHERE id = '2'

Stack trace

  • android.database.sqlite.SQLiteException: no such column: image (code 1): , while compiling: SELECT id, nameDefault, name, image FROM contacts WHERE id=? at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314) at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1161) at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1032) at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1238) at com.example.nirvan.diary30.DatabaseHandler.getContact(DatabaseHandler.java:136) at com.example.nirvan.diary30.MainActivity$1.onPageSelected(MainActivity.java:87) at android.support.v4.view.ViewPager.dispatchOnPageSelected(ViewPager.java:1933) at android.support.v4.view.ViewPager.scrollToItem(ViewPager.java:685) at android.support.v4.view.ViewPager.setCurrentItemInternal(ViewPager.java:669) at android.support.v4.view.ViewPager.setCurrentItemInternal(ViewPager.java:630) at android.support.v4.view.ViewPager.setCurrentItem(ViewPager.java:611) at android.support.design.widget.TabLayout$ViewPagerOnTabSelectedListener.onTabSelected(TabLayout.java:2156) at android.support.design.widget.TabLayout.dispatchTabSelected(TabLayout.java:1138) at android.support.design.widget.TabLayout.selectTab(TabLayout.java:1132) at android.support.design.widget.TabLayout.selectTab(TabLayout.java:1105) at android.support.design.widget.TabLayout$Tab.select(TabLayout.java:1396) at android.support.design.widget.TabLayout$TabView.performClick(TabLayout.java:1501) at android.view.View$PerformClick.run(View.java:18465) at android.os.Handler.handleCallback(Handler.java:733) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:136) at android.app.ActivityThread.main(ActivityThread.java:5086) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:515) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:785) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:601) at dalvik.system.NativeStart.main(Native Method)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 11 months ago
18 times, 5 days ago
11 times, 1 month ago
2 times, 2 months ago
58 times, 5 months ago
109 more bugmates