"Error: no such table: VAR_MAP" - can't seem to figure it out

[BrainFriedLab]

I got ethoscopy up and running and could run the tutorials, but hit a wall when trying to figure out how to run it on my own data. So, I thought I'd try rethomics instead. But, I'm still hitting a wall with using my own data.

I got rethomics to work with the "ethoscope data in practice" tutorial. I then made a similar structured folder with one of my .db files. When I run the following:

dt <- load_ethoscope(metadata_subset, verbose=FALSE)

I get the following error:

Error: no such table: VAR_MAP

I then started troubleshooting. I put tutorial .db files into the file structure, changed the metadata file, and ran that line of code and still got the same error. I then changed the metadata file to not include MY .db files and only include the two tutorial .db files and I no longer got the error.

It leads me to believe that there's something wrong with my .db file OR there's something wrong with the entries I made in the metadata file. I'm leaning toward the issue being with the .db file because I can't see any issues with my metadata file.

Any idea what's going on?
And is there a way to look at the contents of the .db file? I wasn't sure how to even open it to compare and contrast mine with the tutorial .db files.

[BrainFriedLab]

So... I downloaded SQlite to look at the .db file closer. And sure enough... my .db file doesn't include a table called "VARMAP". It's structure actually looks VERY different from the tutorial structure. It seems to be missing all sorts of variables.

The tutorial .db file is on the right.
My .db file is on the left.

[BrainFriedLab]

Figured it out! I went back to more .db files. Turns out my other .db files are a-okay in terms of the tables that are in them. It's just this single one that doesn't have the tables correctly in there. Not sure how to add proper tables, but I've gotten through that error!