# \[FIXED\] Sync problem with OneDrive for Business (student) (v2.8.8) \[FIXED\]

**URL:** <https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392>\
**Category:** Support\
**Created:** [16 September 2022 13:01 UTC](https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392 "2022-09-16T13:01:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DumbMahreeo](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/dumbmahreeo/32/14954_2.png) [@DumbMahreeo](https://discourse.joplinapp.org/u/DumbMahreeo)\
**Post date:** [16 September 2022 13:01 UTC](https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392/1 "2022-09-16T13:01:52Z")

</div>

Joplin version: `2.8.8`  
Installed trough: Flatpak `net.cozic.joplin_desktop` on Flathub  
Operating System: `EndeavourOS` (based on Arch Linux)

I could sync fine with my personal OneDrive account, but now that I switched to OneDrive for Business (trough the institutional email address my university provided) the following error appears on the console and syncing doesn't work.

```auto
Error: The provided drive id appears to be malformed, or does not represent a valid drive.
    at OneDriveApi.oneDriveErrorResponseToError (onedrive-api.ts:134)
    at OneDriveApi.<anonymous> (onedrive-api.ts:312)
    at Generator.next (<anonymous>)
    at fulfilled (/app/joplin-desktop/…b/onedrive-api.js:5)
    at processTicksAndRejections (internal/process/task_queues.js:95)

```

I also tried logging in again several times

---

<div class="post-metadata">

**Author:** ![DumbMahreeo](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/dumbmahreeo/32/14954_2.png) [@DumbMahreeo](https://discourse.joplinapp.org/u/DumbMahreeo)\
**Post date:** [16 September 2022 23:08 UTC](https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392/2 "2022-09-16T23:08:37Z")

</div>

EDIT: (thanks to Daeraxa \<3) please, before attempting any of this, do a backup of your data/config directory along with all of your notes.

* * *

So, just wanted to share my solution.

I opened my `database.sqlite` file (which I found in `$HOME/.config/joplin-desktop`, but location may vary depending on your system) with `sqlite3`.

Then I deleted a couple of rows from the `settings` table with the following query:

```sql
DELETE FROM settings WHERE key REGEXP "sync.3";

```

After deleting every row in the `settings` table with a key that started with `sync.3` I just needed to login again and then I could sync just fine.

Seems like Joplin was having trouble updating that row, so it did not register the Business account.

If you are having trouble deleting that row, simply deleting the `database.sqlite` file or the whole config directory may help, but in that case you'd loose the rest of your configuration.

---

<div class="post-metadata">

**Author:** ![Daeraxa](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/daeraxa/32/6172_2.png) [@Daeraxa](https://discourse.joplinapp.org/u/Daeraxa)\
**Post date:** [16 September 2022 23:27 UTC](https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392/3 "2022-09-16T23:27:41Z")

</div>

> [@DumbMahreeo](#):
>
> but in that case you'd loose the rest of your configuration.

Just to point out (to others reading this) that if you do this you also lose all of your notes as well so please don't touch this unless you have either backed everything up or know what you are doing.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/3X/1/c/1c948e33314e232a0927789508474d8624f4270b.png) [@system](https://discourse.joplinapp.org/u/system)\
**Post date:** [16 October 2022 23:27 UTC](https://discourse.joplinapp.org/t/fixed-sync-problem-with-onedrive-for-business-student-v2-8-8-fixed/27392/4 "2022-10-16T23:27:45Z")

</div>

Closed on 16 October 2022 23:27 UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.