SQLiteException: no column named forceReadOnly since update



  • Since i updated the app i cannot sync calender entries anymore. I did not sync contacts. I am getting the following exception:

    Account name: cloud
    
    EXCEPTION:
    android.database.sqlite.SQLiteException: table collections has no column named forceReadOnly (code 1): , while compiling: INSERT OR REPLACE  INTO collections(source,description,forceReadOnly,color,readOnly,url,supportsVTODO,displayName,serviceID,sync,type,timezone,supportsVEVENT) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
    	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:895)
    	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:506)
    	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    	at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    	at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469)
    	at at.bitfire.davdroid.DavService$refreshCollections$$inlined$use$lambda$7.invoke(DavService.kt:236)
    	at at.bitfire.davdroid.DavService.refreshCollections(DavService.kt:354)
    	at at.bitfire.davdroid.DavService$onStartCommand$$inlined$let$lambda$1.invoke(DavService.kt:66)
    	at at.bitfire.davdroid.DavService$onStartCommand$$inlined$let$lambda$1.invoke(DavService.kt:45)
    	at kotlin.concurrent.ThreadsKt$thread$thread$1.run(Thread.kt:18)
    
    SOFTWARE INFORMATION
    Package: at.bitfire.davdroid
    Version: 1.9.5-ose (192) from 02.12.2017
    Installed from: APK (directly)
    JB Workaround installed: no
    
    CONNECTIVITY (at the moment)
    Active connection: WiFi, CONNECTED
    
    CONFIGURATION
    android.permission.READ_CONTACTS permission: granted
    android.permission.WRITE_CONTACTS permission: granted
    android.permission.READ_CALENDAR permission: granted
    android.permission.WRITE_CALENDAR permission: granted
    org.dmfs.permission.READ_TASKS permission: denied
    org.dmfs.permission.WRITE_TASKS permission: denied
    System-wide synchronization: automatically
    Account: cloud
      Address book sync. interval: 240 min
      Calendar     sync. interval: 240 min
      OpenTasks    sync. interval: —
      WiFi only: false
      [CardDAV] Contact group method: CATEGORIES
      [CalDAV] Time range (past days): 90
               Manage calendar colors: true
    
    SQLITE DUMP
    android_metadata
    	|  locale |
    	|  de_DE |
    ----------
    services
    	|  _id | accountName | service | principal |
    	|  1 | cloud | carddav | XXXXX |
    	|  2 | cloud | caldav | XXXXX |
    ----------
    sqlite_sequence
    	|  name | seq |
    	|  services | 2 |
    	|  homesets | 5 |
    	|  collections | 17 |
    ----------
    homesets
    	|  _id | serviceID | url |
    	|  1 | 1 | XXXXX |
    	|  5 | 2 | XXXXX |
    ----------
    collections
    	|  _id | serviceID | type | url | readOnly | displayName | description | color | timezone | supportsVEVENT | supportsVTODO | source | sync |
    	|  1 | 1 | ADDRESS_BOOK | XXXXX | 0 | Kontakte | <null> | <null> | <null> | 0 | 0 | <null> | 0 |
    	|  14 | 2 | CALENDAR | XXXXX | 0 | Fußball | <null> | -8853644 | <null> | 1 | 1 | <null> | 1 |
    	|  15 | 2 | CALENDAR | XXXXX  | 0 | Gemeinsamer Kalender | <null> | -1605516 | <null> | 1 | 1 | <null> | 1 |
    	|  16 | 2 | CALENDAR | XXXXX | 0 | Persönlich | <null> | -1608502 | <null> | 1 | 1 | <null> | 1 |
    	|  17 | 2 | CALENDAR | XXXXX  | 0 | Arbeit / Uni | <null> | -9122585 | <null> | 1 | 1 | <null> | 1 |
    ----------
    
    SYSTEM INFORMATION
    Android version: 5.1.1 (23.4.A.1.232)
    Device: Sony D5803 (D5803)
    
    
    

  • admin

    This may come from an interruption while DAVdroid was updated. Maybe there was a database lock so that a new column that we need couldn't be created. It should be fixed by reinstalling DAVdroid. Can you write again after you tried that?



  • Thank you for your reply. I already have tried to uninstall und install the app. And i get the same error again. But i can try today again. Maybe i should first delete cache and app files before i uninstall again.


  • admin

    Please uninstall, then reboot your device, then install it again! Hope it helps...



  • I followed your steps. Sync does not work. But i did not get exceptions anymore. Here is my debug.txt

    SOFTWARE INFORMATION
    Package: at.bitfire.davdroid
    Version: 1.9.5-ose (192) from 02.12.2017
    Installed from: APK (directly)
    JB Workaround installed: no
    
    CONNECTIVITY (at the moment)
    Active connection: WiFi, CONNECTED
    
    CONFIGURATION
    android.permission.READ_CONTACTS permission: granted
    android.permission.WRITE_CONTACTS permission: granted
    android.permission.READ_CALENDAR permission: granted
    android.permission.WRITE_CALENDAR permission: granted
    org.dmfs.permission.READ_TASKS permission: denied
    org.dmfs.permission.WRITE_TASKS permission: denied
    System-wide synchronization: automatically
    Account: Cloud
      Address book sync. interval: 240 min
      Calendar     sync. interval: 240 min
      OpenTasks    sync. interval: —
      WiFi only: false
      [CardDAV] Contact group method: CATEGORIES
      [CalDAV] Time range (past days): 90
               Manage calendar colors: true
    
    SQLITE DUMP
    android_metadata
    	|  locale |
    	|  de_DE |
    ----------
    services
    	|  _id | accountName | service | principal |
    	|  1 | Cloud | carddav | XXXX |
    	|  2 | Cloud | caldav | XXXX |
    ----------
    sqlite_sequence
    	|  name | seq |
    	|  services | 2 |
    	|  homesets | 6 |
    	|  collections | 21 |
    ----------
    homesets
    	|  _id | serviceID | url |
    	|  1 | 1 | XXXX |
    	|  6 | 2 | XXXX |
    ----------
    collections
    	|  _id | serviceID | type | url | readOnly | forceReadOnly | displayName | description | color | timezone | supportsVEVENT | supportsVTODO | source | sync |
    	|  1 | 1 | ADDRESS_BOOK | XXXX | 0 | 0 | Kontakte | <null> | <null> | <null> | 0 | 0 | <null> | 0 |
    	|  18 | 2 | CALENDAR | XXXX | 0 | 0 | Fußball | <null> | -8853644 | <null> | 1 | 1 | <null> | 1 |
    	|  19 | 2 | CALENDAR | XXXX | 0 | 0 | Gemeinsamer Kalender | <null> | -1605516 | <null> | 1 | 1 | <null> | 1 |
    	|  20 | 2 | CALENDAR | XXXX | 0 | 0 | Persönlich | <null> | -1608502 | <null> | 1 | 1 | <null> | 1 |
    	|  21 | 2 | CALENDAR | XXXX | 0 | 0 | Arbeit / Uni | <null> | -9122585 | <null> | 1 | 1 | <null> | 1 |
    ----------
    
    SYSTEM INFORMATION
    Android version: 5.1.1 (23.4.A.1.232)
    Device: Sony D5803 (D5803)
    
    
    


  • Now sync works again fine. I thougt it was a problem of disk space on my mobile. I has only 400 mb left. After i removed facebook and had over 500 mb space left, sync worked fine. I often read that users have various problems on their android devices when capacity is under 500 mb. Thank you for your help.



  • Thank you it's work now


Log in to reply
 

Looks like your connection to Bitfire App Forums was lost, please wait while we try to reconnect.