FrederikBaerentsen/BrickTracker
8
20
Fork 12
Code Issues 16 Pull Requests Actions Packages Projects 1 Releases 10 Wiki Activity

Unraid Database Issue #111

New Issue
Closed
opened 2025-11-04 02:41:16 +01:00 by Revontulet · 12 comments
Revontulet commented 2025-11-04 02:41:16 +01:00
Copy Link
Copy Source

Recently got back into building Legos and thought it would be fun to host my own collection on my Unraid server. Found this app and have been trying to get it running for a few days now. When I use the guides on the repo, I get a "Database error!
An error has occurred: unable to open database file." Not sure what I am doing wrong here. I have tried it both with the Unraid community applications option and docker compose with the same result. I am using default settings for the container and am not planning on using this outside my network with a reverse proxy. Any help would be appreciated!

Cheers
Revo

Recently got back into building Legos and thought it would be fun to host my own collection on my Unraid server. Found this app and have been trying to get it running for a few days now. When I use the guides on the repo, I get a "Database error! An error has occurred: unable to open database file." Not sure what I am doing wrong here. I have tried it both with the Unraid community applications option and docker compose with the same result. I am using default settings for the container and am not planning on using this outside my network with a reverse proxy. Any help would be appreciated! Cheers Revo
FrederikBaerentsen commented 2025-11-04 07:44:18 +01:00
Owner
Copy Link
Copy Source

Could you share your compose file and your env?

Could you share your compose file and your env?
FrederikBaerentsen added the Kind/Bug label 2025-11-04 07:44:27 +01:00
Revontulet commented 2025-11-04 20:33:02 +01:00
Author
Copy Link
Copy Source

Hi Frederik, thanks for getting back to me. I am using the unraid community applications option, so I'm not sure if I'm able to download the .env and compose files. I have attached a screen shot pdf of the setup. It installs fine, but I feel like I'm missing a step somewhere regarding the app.db file.

Thanks

Hi Frederik, thanks for getting back to me. I am using the unraid community applications option, so I'm not sure if I'm able to download the .env and compose files. I have attached a screen shot pdf of the setup. It installs fine, but I feel like I'm missing a step somewhere regarding the app.db file. Thanks
bricktracker compose file.pdf
479 KiB
FrederikBaerentsen added the Unraid label 2025-11-05 09:07:44 +01:00
FrederikBaerentsen commented 2025-11-05 09:08:41 +01:00
Owner
Copy Link
Copy Source

Unfortunately the unraid template isn't made by me and isn't supported. Check #72 for more info. I don't know how unraid works.

Unfortunately the unraid template isn't made by me and isn't supported. Check #72 for more info. I don't know how unraid works.
FrederikBaerentsen added Out of Scope and removed Kind/Bug labels 2025-11-05 09:08:48 +01:00
bckthms commented 2025-11-15 16:39:48 +01:00
Copy Link
Copy Source

Hi @FrederikBaerentsen
Same problem here
On start, bricktracker tells me to update database. But after upgrade, all sets have disappeared.
Here is my database if it helps

Hi @FrederikBaerentsen Same problem here On start, bricktracker tells me to update database. But after upgrade, all sets have disappeared. Here is my database if it helps
app-v15-2025-03-29-06-40-26.zip
223 KiB
FrederikBaerentsen commented 2025-11-15 16:41:19 +01:00
Owner
Copy Link
Copy Source

@bckthms are you using Unraid?

Which container tag are you using?

@bckthms are you using Unraid? Which container tag are you using?
bckthms commented 2025-11-15 16:43:32 +01:00
Copy Link
Copy Source

Yes, I am using Unraid with the latest version of gitea.baerentsen.space/frederikbaerentsen/bricktracker

Yes, I am using Unraid with the latest version of gitea.baerentsen.space/frederikbaerentsen/bricktracker
FrederikBaerentsen commented 2025-11-15 19:26:49 +01:00
Owner
Copy Link
Copy Source

Alright, unfortunately I don't use Unraid myself and have no idea how its container implementation is. I would suggest you contact whoever made the Unraid template, as that is not me.

Alright, unfortunately I don't use Unraid myself and have no idea how its container implementation is. I would suggest you contact whoever made the Unraid template, as that is not me.
Watever commented 2025-11-23 17:23:23 +01:00
Copy Link
Copy Source

I have the exact same issue.
Looks like the database is getting reset when we restart the container.
In the instruction for the database location, I can see : Path to the SQLite database. Run touch app.db BEFORE running container for the first time.

Wondering if the touch app.db isn't run every time the container is restarted but I don't know where to find this.

I restarted the container because I am having difficulties when running the container in reverse proxy (nginx). if I do brick.domainname.com I get a web socket disconnect, but I don't have this issue when going to the ip/port directly. Any idea if it's related ?

I have the exact same issue. Looks like the database is getting reset when we restart the container. In the instruction for the database location, I can see : Path to the SQLite database. Run `touch app.db` BEFORE running container for the first time. Wondering if the touch app.db isn't run every time the container is restarted but I don't know where to find this. I restarted the container because I am having difficulties when running the container in reverse proxy (nginx). if I do brick.domainname.com I get a web socket disconnect, but I don't have this issue when going to the ip/port directly. Any idea if it's related ?
csuno commented 2025-12-18 22:21:04 +01:00
Copy Link
Copy Source

seems for me, the last update moved my app.db location...
so i have to setup a new path variable in my unraid template config... to gave him the app.db at: "/app/data/app.db":"/mnt/user/appdata/$brick_tracker_somethingfolder$/app.db" (not "/app/app.db" anymore, like it is in the standarttemplate!)

seems for me, the last update moved my app.db location... so i have to setup a new path variable in my unraid template config... to gave him the app.db at: "/app/data/app.db":"/mnt/user/appdata/$brick_tracker_somethingfolder$/app.db" (not "/app/app.db" anymore, like it is in the standarttemplate!)
bckthms commented 2025-12-19 08:08:42 +01:00
Copy Link
Copy Source

I created a custom template for myself with only port and data path :
image.png
The app.db location is defined in the .env file (see migration guide)
Much easier to maintain !
I no longer have database problems after container update

I created a custom template for myself with only port and data path : ![image.png](/attachments/e83375b0-306f-4b2c-8d3c-f37b4b8a38d4) The app.db location is defined in the .env file (see [migration guide](https://bricktracker.baerentsen.space/migration_guide)) Much easier to maintain ! I no longer have database problems after container update
image.png
47 KiB
joshmans commented 2025-12-25 18:57:12 +01:00
Copy Link
Copy Source

I created a custom template for myself with only port and data path :
image.png
The app.db location is defined in the .env file (see migration guide)
Much easier to maintain !
I no longer have database problems after container update

Can you screenshot what your file structure looks like inside of your bricktracker data directory on your appdata share?

> I created a custom template for myself with only port and data path : > ![image.png](/attachments/e83375b0-306f-4b2c-8d3c-f37b4b8a38d4) > The app.db location is defined in the .env file (see [migration guide](https://bricktracker.baerentsen.space/migration_guide)) > Much easier to maintain ! > I no longer have database problems after container update Can you screenshot what your file structure looks like inside of your bricktracker data directory on your appdata share?
joshmans commented 2025-12-26 04:20:33 +01:00
Copy Link
Copy Source

...Nevermind, I set mine up the same and now its working.

...Nevermind, I set mine up the same and now its working.
👍 1
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
 Out of Scope
Request is out of scope
Priority
Critical
The priority is critical
Priority
High
The priority is high
Priority
Low
The priority is low
Priority
Medium
The priority is medium
Reviewed
Confirmed
Issue has been confirmed
Reviewed
Duplicate
This issue or pull request already exists
Reviewed
Invalid
Invalid issue
Reviewed
Won't Fix
This issue won't be fixed
Status
Abandoned
Somebody has started to work on this but abandoned work
Status
Blocked
Something is blocking this issue or pull request
Status
Need More Info
Feedback is required to reproduce issue or to continue work
Unraid
Unsupported/Can't help
No Label Out of Scope Unraid
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
FrederikBaerentsen
No Assignees
6 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: FrederikBaerentsen/BrickTracker#111
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?