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 = ?

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Stack Overflow by nasch
, 1 year 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
, 1 year 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 grman.at by Unknown author, 1 year ago
no such table: <TABLE> (code 1): , while compiling: SELECT <column list> FROM <TABLE>
via Stack Overflow by alphasigmakappa
, 2 years ago
no such table: past (code 1): , while compiling: select * from past
via thinkingaboutnothing.com by Unknown author, 2 years ago
no such column: c.description (code 1): , while compiling: ...
via thinkingaboutnothing.com by Unknown author, 1 year ago
no such column: c.description (code 1): , while compiling: ...
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.(SQLiteProgram.java:59)
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:1440)
at com.activeandroid.util.SQLiteUtils.intQuery(SQLiteUtils.java:114)
at com.activeandroid.query.From.count(From.java:333)

Users with the same issue

2 times, 1 year ago
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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