Skip to content

Instantly share code, notes, and snippets.

@pawitp
Created November 24, 2011 13:30
Show Gist options
  • Save pawitp/1391353 to your computer and use it in GitHub Desktop.
Save pawitp/1391353 to your computer and use it in GitHub Desktop.
Bug report for astrid
CREATE TABLE Attendees (_id INTEGER PRIMARY KEY,event_id INTEGER,attendeeName TEXT,attendeeEmail TEXT,attendeeStatus INTEGER,attendeeRelationship INTEGER,attendeeType INTEGER);
CREATE INDEX attendeesEventIdIndex ON Attendees (event_id);
CREATE TABLE CalendarAlerts (_id INTEGER PRIMARY KEY,event_id INTEGER,begin INTEGER NOT NULL,end INTEGER NOT NULL,alarmTime INTEGER NOT NULL,creationTime INTEGER NOT NULL DEFAULT 0,receivedTime INTEGER NOT NULL DEFAULT 0,notifyTime INTEGER NOT NULL DEFAULT 0,state INTEGER NOT NULL,minutes INTEGER,UNIQUE (alarmTime, begin, event_id));
CREATE INDEX calendarAlertsEventIdIndex ON CalendarAlerts (event_id);
CREATE TABLE CalendarCache (_id INTEGER PRIMARY KEY,key TEXT NOT NULL,value TEXT);
CREATE TABLE CalendarMetaData (_id INTEGER PRIMARY KEY,localTimezone TEXT,minInstance INTEGER,maxInstance INTEGER);
CREATE TABLE Calendars (_id INTEGER PRIMARY KEY,account_name TEXT,account_type TEXT,_sync_id TEXT,dirty INTEGER,name TEXT,calendar_displayName TEXT,calendar_color INTEGER,calendar_access_level INTEGER,visible INTEGER NOT NULL DEFAULT 1,sync_events INTEGER NOT NULL DEFAULT 0,calendar_location TEXT,calendar_timezone TEXT,ownerAccount TEXT, canOrganizerRespond INTEGER NOT NULL DEFAULT 1,canModifyTimeZone INTEGER DEFAULT 1,canPartiallyUpdate INTEGER DEFAULT 0,maxReminders INTEGER DEFAULT 5,allowedReminders TEXT DEFAULT '0,1',deleted INTEGER NOT NULL DEFAULT 0,cal_sync1 TEXT,cal_sync2 TEXT,cal_sync3 TEXT,cal_sync4 TEXT,cal_sync5 TEXT,cal_sync6 TEXT,cal_sync7 TEXT,cal_sync8 TEXT,cal_sync9 TEXT,cal_sync10 TEXT);
CREATE TRIGGER calendar_cleanup DELETE ON Calendars BEGIN DELETE FROM Events WHERE calendar_id=old._id;END;
CREATE TABLE Events (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_id TEXT,dirty INTEGER,lastSynced INTEGER DEFAULT 0,calendar_id INTEGER NOT NULL,title TEXT,eventLocation TEXT,description TEXT,eventColor INTEGER,eventStatus INTEGER,selfAttendeeStatus INTEGER NOT NULL DEFAULT 0,dtstart INTEGER,dtend INTEGER,eventTimezone TEXT,duration TEXT,allDay INTEGER NOT NULL DEFAULT 0,accessLevel INTEGER NOT NULL DEFAULT 0,availability INTEGER NOT NULL DEFAULT 0,hasAlarm INTEGER NOT NULL DEFAULT 0,hasExtendedProperties INTEGER NOT NULL DEFAULT 0,rrule TEXT,rdate TEXT,exrule TEXT,exdate TEXT,original_id INTEGER,original_sync_id TEXT,originalInstanceTime INTEGER,originalAllDay INTEGER,lastDate INTEGER,hasAttendeeData INTEGER NOT NULL DEFAULT 0,guestsCanModify INTEGER NOT NULL DEFAULT 0,guestsCanInviteOthers INTEGER NOT NULL DEFAULT 1,guestsCanSeeGuests INTEGER NOT NULL DEFAULT 1,organizer STRING,deleted INTEGER NOT NULL DEFAULT 0,eventEndTimezone TEXT,sync_data1 TEXT,sync_data2 TEXT,sync_data3 TEXT,sync_data4 TEXT,sync_data5 TEXT,sync_data6 TEXT,sync_data7 TEXT,sync_data8 TEXT,sync_data9 TEXT,sync_data10 TEXT);
CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);
CREATE TRIGGER events_cleanup_delete DELETE ON Events BEGIN DELETE FROM Instances WHERE event_id=old._id;DELETE FROM EventsRawTimes WHERE event_id=old._id;DELETE FROM Attendees WHERE event_id=old._id;DELETE FROM Reminders WHERE event_id=old._id;DELETE FROM CalendarAlerts WHERE event_id=old._id;DELETE FROM ExtendedProperties WHERE event_id=old._id;END;
CREATE TRIGGER original_sync_update UPDATE OF _sync_id ON Events BEGIN UPDATE Events SET original_sync_id=new._sync_id WHERE original_id=old._id; END;
CREATE TABLE EventsRawTimes (_id INTEGER PRIMARY KEY,event_id INTEGER NOT NULL,dtstart2445 TEXT,dtend2445 TEXT,originalInstanceTime2445 TEXT,lastDate2445 TEXT,UNIQUE (event_id));
CREATE TABLE ExtendedProperties (_id INTEGER PRIMARY KEY,event_id INTEGER,name TEXT,value TEXT);
CREATE INDEX extendedPropertiesEventIdIndex ON ExtendedProperties (event_id);
CREATE TABLE Instances (_id INTEGER PRIMARY KEY,event_id INTEGER,begin INTEGER,end INTEGER,startDay INTEGER,endDay INTEGER,startMinute INTEGER,endMinute INTEGER,UNIQUE (event_id, begin, end));
CREATE INDEX instancesStartDayIndex ON Instances (startDay);
CREATE TABLE Reminders (_id INTEGER PRIMARY KEY,event_id INTEGER,minutes INTEGER,method INTEGER NOT NULL DEFAULT 0);
CREATE INDEX remindersEventIdIndex ON Reminders (event_id);
CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account_name, account_type));
CREATE TABLE _sync_state_metadata (version INTEGER);
CREATE TABLE android_metadata (locale TEXT);
CREATE VIEW view_events AS SELECT Events._id AS _id,title,description,eventLocation,eventColor,eventStatus,selfAttendeeStatus,dtstart,dtend,duration,eventTimezone,eventEndTimezone,allDay,accessLevel,availability,hasAlarm,hasExtendedProperties,rrule,rdate,exrule,exdate,original_sync_id,original_id,originalInstanceTime,originalAllDay,lastDate,hasAttendeeData,calendar_id,guestsCanInviteOthers,guestsCanModify,guestsCanSeeGuests,organizer,sync_data1,sync_data2,sync_data3,sync_data4,sync_data5,sync_data6,sync_data7,sync_data8,sync_data9,sync_data10,Events.deleted AS deleted,Events._sync_id AS _sync_id,Events.dirty AS dirty,lastSynced,Calendars.account_name AS account_name,Calendars.account_type AS account_type,calendar_timezone,calendar_displayName,calendar_location,visible,calendar_color,calendar_access_level,maxReminders,allowedReminders,canOrganizerRespond,canModifyTimeZone,canPartiallyUpdate,cal_sync1,cal_sync2,cal_sync3,cal_sync4,cal_sync5,cal_sync6,cal_sync7,cal_sync8,cal_sync9,cal_sync10,ownerAccount,sync_events FROM Events JOIN Calendars ON (Events.calendar_id=Calendars._id);
I/SqliteDatabaseCpp( 1014): sqlite returned: error code = 1, msg = no such column: displayName, db=/data/data/com.android.providers.calendar/databases/calendar.db
E/DatabaseUtils( 1014): Writing exception to parcel
E/DatabaseUtils( 1014): android.database.sqlite.SQLiteException: no such column: displayName: , while compiling: SELECT _id, displayName FROM Calendars WHERE (access_level>= 500) ORDER BY displayName ASC
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
E/DatabaseUtils( 1014): at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:354)
E/DatabaseUtils( 1014): at com.android.providers.calendar.CalendarProvider2.query(CalendarProvider2.java:955)
E/DatabaseUtils( 1014): at com.android.providers.calendar.CalendarProvider2.query(CalendarProvider2.java:935)
E/DatabaseUtils( 1014): at android.content.ContentProvider$Transport.query(ContentProvider.java:178)
E/DatabaseUtils( 1014): at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:112)
E/DatabaseUtils( 1014): at android.os.Binder.execTransact(Binder.java:338)
E/DatabaseUtils( 1014): at dalvik.system.NativeStart.run(Native Method)
D/AndroidRuntime( 2089): Shutting down VM
W/dalvikvm( 2089): threadid=1: thread exiting with uncaught exception (group=0x40a311f8)
W/System.err( 2089): android.database.sqlite.SQLiteException: no such column: displayName: , while compiling: SELECT _id, displayName FROM Calendars WHERE (access_level>= 500) ORDER BY displayName ASC
W/System.err( 2089): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
W/System.err( 2089): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
W/System.err( 2089): at android.content.ContentProviderProxy.query(ContentProviderNative.java:358)
W/System.err( 2089): at android.content.ContentResolver.query(ContentResolver.java:310)
W/System.err( 2089): at com.todoroo.astrid.gcal.Calendars.getCalendars(Calendars.java:88)
W/System.err( 2089): at com.todoroo.astrid.gcal.GCalControlSet.<init>(GCalControlSet.java:67)
W/System.err( 2089): at com.todoroo.astrid.activity.TaskEditActivity$TaskEditBackgroundLoader.onUiThread(TaskEditActivity.java:386)
W/System.err( 2089): at com.todoroo.astrid.activity.TaskEditActivity$TaskEditBackgroundLoader$2.run(TaskEditActivity.java:429)
W/System.err( 2089): at android.os.Handler.handleCallback(Handler.java:605)
W/System.err( 2089): at android.os.Handler.dispatchMessage(Handler.java:92)
W/System.err( 2089): at android.os.Looper.loop(Looper.java:137)
W/System.err( 2089): at android.app.ActivityThread.main(ActivityThread.java:4340)
W/System.err( 2089): at java.lang.reflect.Method.invokeNative(Native Method)
W/System.err( 2089): at java.lang.reflect.Method.invoke(Method.java:511)
W/System.err( 2089): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
W/System.err( 2089): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
W/System.err( 2089): at dalvik.system.NativeStart.main(Native Method)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment