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


Solutions on the web

Solution icon of stackoverflow
via Stack Overflow by Ghost
, 9 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
, 1 year 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 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'

Solution icon of stackoverflow
no such column: KEY_PHONE (code 1): , while compiling: SELECT id FROM BLOCKED_PHONES_TABLE WHERE KEY_PHONE = ? AND KEY_IS_BLOCKED = ?

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, 1 year ago
18 times, 2 months ago
11 times, 3 months ago
2 times, 4 months ago
58 times, 7 months ago
111 more bugmates