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

  • developer

    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!


Log in to reply
 

Similar topics

  • 10
  • 4
  • 2