@robi mh, for me it’s not the case that it’s limited to those. I have duplicated in series and duplicated single entries. I also have correctly displayed series entries and correctly displayed single entries.
can't sync Baikal calendar [solved]
-
I’m unable to sync my Baikal (0.6.1) caldav calendar. The carddav works, and both caldav and carddav are able to sync to my local machine. See debug below.
Any tips?
Thanks.
--- BEGIN DEBUG INFO --- SYNCHRONIZATION INFO Account name: email@server.com Authority: com.android.calendar EXCEPTION: android.database.sqlite.SQLiteException: no such column: isPrimary (code 1 SQLITE_ERROR): , while compiling: SELECT originalAllDay, account_type, exrule, mutators, originalInstanceTime, allDay, allowedReminders, rrule, canOrganizerRespond, lastDate, visible, calendar_id, hasExtendedProperties, calendar_access_level, selfAttendeeStatus, allowedAvailability, eventColor_index, isOrganizer, _sync_id, calendar_color_index, _id, guestsCanInviteOthers, allowedAttendeeTypes, dtstart, guestsCanSeeGuests, sync_data9, sync_data8, exdate, sync_data7, sync_data6, sync_data1, description, eventTimezone, availability, title, ownerAccount, sync_data5, sync_data4, sync_data3, sync_data2, duration, lastSynced, guestsCanModify, cal_sync3, rdate, cal_sync2, maxReminders, COALESCE(isPrimary, ownerAccount = account_name) AS isPrimary, cal_sync1, cal_sync10, account_name, cal_sync7, cal_sync6, cal_sync5, cal_sync4, calendar_color, cal_sync9, cal_sync8, dirty, calendar_timezone, accessLevel, eventLocation, hasAlarm, uid2445, deleted, eventColor, organizer, eventStatus, customAppUri, canModifyTimeZone, eventEndTimezone, customAppPackage, original_sync_id, hasAttendeeData, displayColor, dtend, original_id, sync_data10, created_from, calendar_displayName FROM view_events WHERE (account_name='email@server.com' AND account_type='bitfire.at.davdroid' AND ((deleted AND original_id IS NULL) AND calendar_id=?)) at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:184) at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140) at android.content.ContentProviderProxy.query(ContentProviderNative.java:423) at android.content.ContentProviderClient.query(ContentProviderClient.java:195) at android.content.ContentProviderClient.query(ContentProviderClient.java:177) at android.content.ContentProviderClient.query(ContentProviderClient.java:167) at at.bitfire.ical4android.AndroidCalendar.queryEvents(AndroidCalendar.kt:186) at at.bitfire.davdroid.resource.LocalCalendar.findDeleted(LocalCalendar.kt:110) at at.bitfire.davdroid.syncadapter.SyncManager.processLocallyDeleted(SyncManager.kt:283) at at.bitfire.davdroid.syncadapter.SyncManager$performSync$1.invoke(SyncManager.kt:129) at at.bitfire.davdroid.syncadapter.SyncManager$performSync$1.invoke(SyncManager.kt:57) at at.bitfire.davdroid.syncadapter.SyncManager.unwrapExceptions(SyncManager.kt:854) at at.bitfire.davdroid.syncadapter.SyncManager.performSync(SyncManager.kt:116) at at.bitfire.davdroid.syncadapter.CalendarsSyncAdapterService$CalendarsSyncAdapter.sync(CalendarsSyncAdapterService.kt:61) at at.bitfire.davdroid.syncadapter.SyncAdapterService$SyncAdapter.onPerformSync(SyncAdapterService.kt:122) at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:334) SOFTWARE INFORMATION * at.bitfire.davdroid 2.6.4-ose (331) from org.fdroid.fdroid * com.android.providers.contacts 3.3.0 (3003000) * com.android.providers.calendar 3.2.0 (0) * com.android.contacts 3.3.0 (3003000) * com.google.android.calendar 2020.08.4-301138406-release (2016531522) from com.android.vending * org.wikipedia 2.7.50309-r-2020-01-08 (50309) from com.android.vending CONNECTIVITY (at the moment) - [ Transports: WIFI Capabilities: NOT_METERED&INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VPN&VALIDATED&NOT_ROAMING&FOREGROUND&NOT_CONGESTED&NOT_SUSPENDED LinkUpBandwidth>=1048576Kbps LinkDnBandwidth>=1048576Kbps SignalStrength: -30] CONFIGURATION Power saving disabled: yes Notifications (not blocked): [group] sync isBlocked=false syncProblems: importance=3 syncIoErrors: importance=1 syncWarnings: importance=2 general: importance=3 debug: importance=4 Permissions: READ_CONTACTS: granted WRITE_CONTACTS: granted READ_CALENDAR: granted WRITE_CALENDAR: granted READ_TASKS: denied WRITE_TASKS: denied ACCESS_COARSE_LOCATION: denied System-wide synchronization: automatically ACCOUNTS Account: email@server.com Address book sync. interval: 240 min Calendar sync. interval: 240 min OpenTasks sync. interval: — WiFi only: false [CardDAV] Contact group method: GROUP_VCARDS [CalDAV] Time range (past days): 90 Manage calendar colors: true Use event colors: false Address book account: Default Address Book (email@server.com Ig) Main account: Account {name=email@server.com, type=bitfire.at.davdroid} URL: http://dav.server.com/dav.php/addressbooks/xx/default/ Sync automatically: true SQLITE DUMP android_metadata | locale | | en_US | ---------- service | id | accountName | type | principal | | 3 | email@server.com | carddav | http://dav.server.com/dav.php/principals/xx/ | | 4 | email@server.com | caldav | http://dav.server.com/dav.php/principals/xx/ | ---------- sqlite_sequence | name | seq | | service | 4 | | homeset | 4 | | collection | 4 | ---------- homeset | id | serviceId | url | privBind | displayName | | 3 | 3 | http://dav.server.com/dav.php/addressbooks/xx/ | 1 | <null> | | 4 | 4 | http://dav.server.com/dav.php/calendars/xx/ | 1 | <null> | ---------- collection | id | serviceId | type | url | privWriteContent | privUnbind | forceReadOnly | displayName | description | color | timezone | supportsVEVENT | supportsVTODO | supportsVJOURNAL | source | sync | | 3 | 3 | ADDRESS_BOOK | http://dav.server.com/dav.php/addressbooks/xx/default/ | 1 | 1 | 0 | Default Address Book | Default Address Book for XX | <null> | <null> | <null> | <null> | <null> | <null> | 1 | | 4 | 4 | CALENDAR | http://dav.server.com/dav.php/calendars/xx/default/ | 1 | 1 | 0 | dav.balibari | dav.balibari | <null> | <null> | 1 | 1 | 0 | <null> | 1 | ---------- room_master_table | id | identity_hash | | 42 | a7554d1ebc5ecfe0c7aefe271485d63c | ---------- SYSTEM INFORMATION Android version: 10 (RMX1931EX_11_C.23) Device: realme RMX1931 (RMX1931L1) --- END DEBUG INFO --- -
Hi,
Looks like the Android calendar database is corrupt. Can you try Android settings / Apps / System apps / Calendar storage provider / Clear data (will delete all local events on the Android device) and then sync again?
-
That did it! Thanks!
