Saturday, 19 February 2022
  4 Replies
  541 Visits
0
Votes
Undo
  Subscribe

Dear brothers, 

These last weeks I keep getting more and more duplicates (see the attached picture). They seem to appear in the following situations: 

* Syncing from another device after changing an assignment (e.g. assign the part to another brother). After sync both assignments will show up with old and new names. Trying to edit the old names will open a dialogue with the new names. 

* Syncing from another device after marking the assignment as "done". These will show as exact duplicates. Editing something in one assignment will change the other, too. 

I've tried this to fix it: 
* delete duplicate assignments, re-import epub. Deleting the duplicate also deletes the original. So I have to manually reassign the part. Takes a lot of time and has a risk for data loss. Also duplicates keep showing up in following weeks once above conditions are met. 

* go through the database and remove duplicate parts. The duplicates seem to be in the lmm_assignment table. Deleting the duplicates there solves the problem for a time, but it's quite time consuming and new duplicates keep showing up. Risk of accidental data loss is even greater here. 

Is there an easy way to fix this? Does anybody else have this problem? 

2 months ago
·
#9175
0
Votes
Undo

Thank you Marc, for your help! Before I'll do it the brute force way, I'll wait a little bit and see if this problem sorts itself out. I suspect I might have worsened it by trying to fix it (deleting duplicates and reimporting workbooks). As you suspect, the second room might also have something to do with the issue. Curiously, the problem seems only visible on the desktop app. On mobile everything appears fine. As most brothers with access to TheocBase in our congregation just use the mobile app they are blissfully unaware of these problems. 

2 months ago
·
#9154
0
Votes
Undo

No the issue wouldn't be in the schedule table. Every assignment has a record in the assignment table, and several assignments can relate to only one record in the schedule (i.e.: one meeting item, can have more than one assignment, as in the case of more than one school). Come to think about it, I tested with only one school... I'll try that later. Tomorrow I am afraid....

What you could do: tell everyone to log out and stay out (!) of TB.
Fix your side.
Backup the theocbase.sqlite file, locally, just to be sure.
Hover over the Dropbox symbol, click 'Delete cloud data', OK the warning. Within a second it will ask you if you want to synchronise. Click Yes. This will create a new database in Dropbox, based on your current local database.
Send the local theocbase.sqlite file around in the mail, and have everybody replace their database with the one you sent.
Make sure all have done this before you allow them to reconnect to Dropbox. (Don't change anything yourself in the meantime either)
This gives all of you (all of your devices) the same starting point.

Maybe not a very sophistacated solution, but it has worked quite a few times.


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


2 months ago
·
#9153
0
Votes
Undo

Hey Marc, thanks for trying. We're using Dropbox sync. I've mentioned the lmm_assigments table because the problem seems to be with duplicates in this table and not the table with the schedule. Could deleting assignments and re-importing the epub have caused this problem?

2 months ago
·
#9152
0
Votes
Undo

Yes, lmm_assignment is the only table that has, well, the assignments...

I have tried hard, but cannot reproduce it yet.

Do you sync via Dropbox, or do you use the export and import function? The latter is known to cause doubling up. If you do not want to use Dropbox, but rather want to exchange data files (like via mail), it is better to use the original theocbase.sqlite than to use the im/export function.

 


https://www.theocbase.net/support-forum/post/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I now use https://code.visualstudio.com/ 

 


  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!