android.database.sqlite.SQLiteException

no such column: property_file._id (code 1): , while compiling: SELECT COUNT(*) FROM property INNER JOIN property_x_file ON property_file._id = property_x_file.property_id WHERE property_x_file.file_id = ?

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1781

  • via Stack Overflow by nasch
    , 10 months ago
    no such column: property_file._id (code 1): , while compiling: SELECT COUNT(*) FROM property INNER JOIN property_x_file ON property_file._id = property_x_file.property_id WHERE property_x_file.file_id = ?
  • via GitHub by nscherer
    , 10 months ago
    no such column: property_file._id (code 1): , while compiling: SELECT COUNT(*) FROM property INNER JOIN property_x_file ON property_file._id = property_x_file.property_id WHERE property_x_file.file_id = ?
  • via Stack Overflow by George Richardson
    , 1 year ago
    no such column: _id (code 1): , while compiling: SELECT _id, content FROM exampletable WHERE _id = 4
  • Stack trace

    • android.database.sqlite.SQLiteException: no such column: property_file._id (code 1): , while compiling: SELECT COUNT(*) FROM property INNER JOIN property_x_file ON property_file._id = property_x_file.property_id WHERE property_x_file.file_id = ? at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1093) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:670) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59) 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:1440) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1379) at com.activeandroid.util.SQLiteUtils.intQuery(SQLiteUtils.java:114) at com.activeandroid.query.From.count(From.java:333)

    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

    Unknown user
    Once, 1 year ago
    2 times, 3 months ago
    8 times, 8 months ago
    Unknown user
    Once, 10 months ago
    2 times, 11 months ago
    108 more bugmates