android.database.sqlite.SQLiteException: no such column: address (code 1): , while compiling: SELECT ID, studentName, gender, course, age, address FROM Students

Stack Overflow | Joshua Edwards | 5 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Andriod Studio No Such Column

    Stack Overflow | 5 months ago | Joshua Edwards
    android.database.sqlite.SQLiteException: no such column: address (code 1): , while compiling: SELECT ID, studentName, gender, course, age, address FROM Students
  2. 0

    Error Opening Database

    Stack Overflow | 1 year ago | Hayes121
    android.database.sqlite.SQLiteException: no such table: recipes (code 1): , while compiling: SELECT reciep_name FROM recipes
  3. 0

    Apps crashed with fatal exception

    Stack Overflow | 1 year ago | Abdurrahman Azhar
    android.database.sqlite.SQLiteException: near "'ANDpassword='": syntax error (code 1): , while compiling: SELECT id, username, password FROM user WHERE username=therhaman'ANDpassword='091192'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    find CRUD Sqlite android implementation

    Stack Overflow | 1 year ago | boblinux
    android.database.sqlite.SQLiteException: no such table: table_sms_received (code 1): , while compiling: SELECT ID, dateReceiving, processed, phone, data FROM table_sms_received WHERE dateReceiving LIKE "janvier"
  6. 0

    Android- No such column error

    Stack Overflow | 11 months ago | Samer Alabi
    android.database.sqlite.SQLiteException: no such column: TEAM_NUMBER (code 1): , while compiling: SELECT TEAM_NUMBER, PORTCULLIS, CHEVAL_DE_FRISE, MOAT, RAMPARTS, DRAWBRIDGE, SALLY_PORT, ROCK_WALL, ROCK_TERRAIN, LOW_BAR FROM scout_table
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. android.database.sqlite.SQLiteException

    no such column: address (code 1): , while compiling: SELECT ID, studentName, gender, course, age, address FROM Students

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.query
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
    7. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
    8. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
    9. android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
    10. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
    11. android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1202)
    11 frames
  3. com.example.owner
    AddStudent.onOptionsItemSelected
    1. com.example.owner.studentmanager.DatabaseManager.retrieveRows(DatabaseManager.java:57)
    2. com.example.owner.studentmanager.AddStudent.showRec(AddStudent.java:130)
    3. com.example.owner.studentmanager.AddStudent.onOptionsItemSelected(AddStudent.java:109)
    3 frames
  4. Android Platform
    Activity.onMenuItemSelected
    1. android.app.Activity.onMenuItemSelected(Activity.java:2908)
    1 frame
  5. Android Support v4
    FragmentActivity.onMenuItemSelected
    1. android.support.v4.app.FragmentActivity.onMenuItemSelected(FragmentActivity.java:325)
    1 frame
  6. Android v7
    ActionMenuItemView.onClick
    1. android.support.v7.app.AppCompatActivity.onMenuItemSelected(AppCompatActivity.java:147)
    2. android.support.v7.internal.view.WindowCallbackWrapper.onMenuItemSelected(WindowCallbackWrapper.java:100)
    3. android.support.v7.app.AppCompatDelegateImplV7.onMenuItemSelected(AppCompatDelegateImplV7.java:609)
    4. android.support.v7.internal.view.menu.MenuBuilder.dispatchMenuItemSelected(MenuBuilder.java:811)
    5. android.support.v7.internal.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:153)
    6. android.support.v7.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:958)
    7. android.support.v7.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:948)
    8. android.support.v7.widget.ActionMenuView.invokeItem(ActionMenuView.java:619)
    9. android.support.v7.internal.view.menu.ActionMenuItemView.onClick(ActionMenuItemView.java:139)
    9 frames
  7. Android Platform
    ActivityThread.main
    1. android.view.View.performClick(View.java:5198)
    2. android.view.View$PerformClick.run(View.java:21147)
    3. android.os.Handler.handleCallback(Handler.java:739)
    4. android.os.Handler.dispatchMessage(Handler.java:95)
    5. android.os.Looper.loop(Looper.java:148)
    6. android.app.ActivityThread.main(ActivityThread.java:5417)
    6 frames
  8. Java RT
    Method.invoke
    1. java.lang.reflect.Method.invoke(Native Method)
    1 frame
  9. Android
    ZygoteInit.main
    1. com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
    2. com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
    2 frames