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

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 web1696

  • 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 Stack Overflow by user1390816
    , 1 year ago
    no such column: _id3: , while compiling: SELECT title, dtstart, dtend FROM Instances INNER JOIN view_events AS Events ON (Instances.event_id=Events._id) WHERE (begin&lt;=? AND end&gt;=?) AND (_id3)
  • Stack trace

    • 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.<init>(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.<init>(SQLiteProgram.java:130) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94) at android.database.sqlite.SQLiteQuery.<init>(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) at dalvik.system.NativeStart.run(Native Method)

    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, 11 months ago
    68 times, 5 days ago
    Unknown user
    Once, 2 months ago
    4 times, 7 months ago
    Once, 11 months ago
    13 more bugmates