Here’s the results:
pi@raspberrypi:~/.kolibri $ sqlite3 fixed.data
SQLite version 3.16.2 2017-01-06 16:32:41
Enter “.help” for usage hints.
sqlite> SELECT id FROM content_file where present = “M”;
Error: no such column: present
I opened fixed.data with a text editor and searched for “6fbdd89a53597a37586843c25c51f5a7” and found it in the file. So it is here, but the sqlite query did not find it.
I’ll send you an email on how to access the Kolibri server here. We are 9 hrs ahead of CA. I believe that is where you are. The free account I have with remote.it allows for up to 8 hours of access without needing to refresh the account. So, at around 9 AM your time, I’ll open up the account and refresh the links.
BTW, another problem recurred yesterday. I had to add new students to Kolibri. I wanted to create a new group, which I did. However, I’m not able to add the new students to this group or any group because they are not listed in the “Ungrouped” section, nor anywhere on that list. This is a problem that occurred before but I worked around it by creating all new groups, etc. That was at the beginning of the workshop. At this point, it would not be easy at all to have to do the same. Maybe this is all associated with the corrupted db.