android.database.sqlite.SQLiteException: no such column: Calendars._id: , while compiling: SELECT Instances.event_id AS event_id, title, description, eventLocation, begin, end, allDay, hasAlarm, eventStatus, visibility FROM Instances INNER JOIN view_events AS Events ON (Instances.event_id=Events._id) WHERE (begin<=? AND end>=?) AND (Calendars._id=1) ORDER BY startDay ASC, startMinute ASC

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 Appcelerator JIRA by Eduardo Gomez, 1 year ago
no such column: Calendars._id: , while compiling: SELECT Instances.event_id AS event_id, title, description, eventLocation, begin, end, allDay, hasAlarm, eventStatus, visibility FROM Instances INNER JOIN view_events AS Events ON (Instances.event_id=Events._id) WHERE (begin<=? AND end>=?) AND (Calendars._id=1) ORDER BY startDay ASC, startMinute ASC
via Appcelerator JIRA by Eduardo Gomez, 1 year ago
no such column: Calendars._id: , while compiling: SELECT Instances.event_id AS event_id, title, description, eventLocation, begin, end, allDay, hasAlarm, eventStatus, visibility FROM Instances INNER JOIN view_events AS Events ON (Instances.event_id=Events._id) WHERE (begin<=? AND end>=?) AND (Calendars._id=1) ORDER BY startDay ASC, startMinute ASC
via xda-developers.com by Unknown author, 2 years ago
no such table: systemex: , while compiling: SELECT value FROM systemex WHERE (name=?)
via GitHub by matburt
, 1 year ago
no such column: displayName: , while compiling: SELECT _id, displayName FROM Calendars WHERE (selected=1)
via GitHub by jvillard
, 1 year ago
no such column: displayName: , while compiling: SELECT _id, displayName FROM Calendars WHERE (selected=1)
via GitHub by Takhion
, 2 years ago
no such collation sequence: REVID: , while compiling: SELECT revid, deleted, sequence, no_attachments, json FROM revs, docs WHERE docs.docid=? AND revs.doc_id=docs.doc_id and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
android.database.sqlite.SQLiteException: no such column: Calendars._id: , while compiling: SELECT Instances.event_id AS event_id, title, description, eventLocation, begin, end, allDay, hasAlarm, eventStatus, visibility FROM Instances INNER JOIN view_events AS Events ON (Instances.event_id=Events._id) WHERE (begin<=? AND end>=?) AND (Calendars._id=1) ORDER BY startDay ASC, startMinute ASC
at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
at android.database.sqlite.SQLiteCompiledSql.(SQLiteCompiledSql.java:64)
at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:146)
at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:367)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:130)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:94)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:46)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1539)
at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:330)
at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:280)
at com.android.providers.calendar.CalendarProvider2.handleInstanceQuery(CalendarProvider2.java:1237)
at com.android.providers.calendar.CalendarProvider2.query(CalendarProvider2.java:982)
at android.content.ContentProvider$Transport.bulkQuery(ContentProvider.java:179)
at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:111)
at android.os.Binder.execTransact(Binder.java:339)

Users with the same issue

2 times, 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, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

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