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

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

Solutions on the web

via Stack Overflow by Ghost
, 11 months ago
no such column: image (code 1): , while compiling: SELECT id, nameDefault, name, image FROM contacts WHERE id=?
via GitHub by HeinrichReimer
, 1 year ago
no such column: ١ (code 1): , while compiling: SELECT BAND_LEVEL_0, BAND_LEVEL_1, BAND_LEVEL_2, BAND_LEVEL_3, BAND_LEVEL_4, BASS_BOOST_ENABLED, BASS_BOOST_LEVEL, _id, LOUDNESS_ENHANCER_ENABLED, LOUDNESS_ENHANCER_LEVEL, PRESET_NAME, VIRTUALIZER_ENABLED, VIRTUALIZER_LEVEL FROM PRESETS WHERE PRESET_NAME = ? ORDER BY null LIMIT ١
via GitHub by pinpong
, 1 year ago
no such column: ١ (code 1): , while compiling: SELECT BAND_LEVEL_0, BAND_LEVEL_1, BAND_LEVEL_2, BAND_LEVEL_3, BAND_LEVEL_4, BASS_BOOST_ENABLED, BASS_BOOST_LEVEL, _id, LOUDNESS_ENHANCER_ENABLED, LOUDNESS_ENHANCER_LEVEL, PRESET_NAME, VIRTUALIZER_ENABLED, VIRTUALIZER_LEVEL FROM PRESETS WHERE PRESET_NAME = ? ORDER BY null LIMIT ١
via GitHub by heinrichreimer
, 8 months ago
no such column: ١ (code 1): , while compiling: SELECT BAND_LEVEL_0, BAND_LEVEL_1, BAND_LEVEL_2, BAND_LEVEL_3, BAND_LEVEL_4, BASS_BOOST_ENABLED, BASS_BOOST_LEVEL, _id, LOUDNESS_ENHANCER_ENABLED, LOUDNESS_ENHANCER_LEVEL, PRESET_NAME, VIRTUALIZER_ENABLED, VIRTUALIZER_LEVEL FROM PRESETS WHERE PRESET_NAME = ? ORDER BY null LIMIT ١
via Stack Overflow by HextechEnthusiast
, 1 year ago
no such column: COLUMN_USER_USERNAME (code 1): , while compiling: SELECT usuaid, username, password FROM usuario WHERE COLUMN_USER_USERNAME = ?
via Stack Overflow by Unknown author, 2 years ago
unrecognized token: "'%xyz" (code 1): , while compiling: **SELECT column FROM TABLE_NAME WHERE Name LIKE '%xyz��������������������������������������������������������������������%'**
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.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.(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.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)

Users with the same issue

12 times, 13 hours ago
40 times, 2 months ago
347 times, 2 months ago
9 times, 3 months ago
Once, 5 months ago

Write tip

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