Installation problem
Hi!
I install homarr with docker:
docker run \
--name homarr \
--restart unless-stopped \
-p 7575:7575 \
-e TZ=Europe/Madrid \
-v /var/run/docker.sock:/var/run/docker.sock \
-v /Dwarf/Datos/AppData/homarr/configs:/app/data/configs \
-v /Dwarf/Datos/AppData/homarr/data:/data \
-v /Dwarf/Datos/AppData/homarr/icons:/app/public/icons \
-d ghcr.io/ajnart/homarr:latest
Container state says “unhealthy”, and when i open the url i get the error in the image.
The logs shows this errors:
{
message: 'no such table: user',
code: -32603,
������
{
code: 'INTERNAL_SERVER_ERROR',
httpStatus: 500,
path: 'user.count',
zodError: null
}
}
}
}
]
},
shape: {
message: 'no such table: user',
code: -32603,
������
{
code: 'INTERNAL_SERVER_ERROR',
httpStatus: 500,
path: 'user.count',
zodError: null
}
},
������
{
code: 'INTERNAL_SERVER_ERROR',
httpStatus: 500,
path: 'user.count',
zodError: null
},
name: 'TRPCClientError'
},
elapsedMs: 56
}
Error [TRPCClientError]: no such table: user
at TRPCClientError.from (file:///app/.next/server/src/middleware.js:1718:20)
at <unknown> (file:///app/.next/server/src/middleware.js:2273:60)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
What am i doing wrong?
Thanxs!
Solution:Jump to solution
GitHub
Release v0.14.1 Stability improvement and bug fixes · ajnart/homarr
Your issues should be resolved!
During the last release, we didn't spend enough time to test on different hardware configurations to ensure that v0.14.0 would work on the majority of people'...
33 Replies
It seems that there was an error when adding the database somehow, can you try to go to
Dwarf/Datos/AppData/homarr/data and deleting the database there ?Same error even after deleting .sqllite in folder
What does it say when you start the app?
Same here.
File deleted, container restarted, same error.
File recreated, 0B size.
Hi 🙂 It seems like, I have a same issue as @Dwarf :/
I have the same error
Instead of a deleting than restart, have you tried stopping the container, deleting, than starting?
This process provided me with a fresh db
If problems persist, this is a blank db.sqlite file ready for onboarding that my homarr created.
@NoScah @Dwarf @Leowen @SoldierofRome
Was able to resolve it by fully removing the container and re-creating it. Usually don't have to do that when running the container on a Synology NAS; a reset of the container usually does the trick.
When in doubt, more force!
Too true
Replacing de DB file with this made it for me!
Thaxs!
@ajnart might want to consider having a replacement on the github or documentation so they aren't just copying mine.
Same isssue even after removing container. There is a way to upload my old config in .json ? I think i have to re-create my dashboard from zero.
my container was fresh 😄 I just started to play with Homarr yesterday. Stop - delete - restart did not solve the issue, but copying your db file is do the trick! 🙂
So you had the mount point setup correctly and it still did not work?
yep, thats correct
replace db.sqlite with the db from above fix my instace without any additional changes.
So before you had a file created by the app but it didn’t work ?
If so can you try to rename your current to something like backup, run it again and run “ls -l” so that I can see the permissions on the files ?
just a moment
do you need the log file of my container?
Can you try to chmod 777 db.sqlite an restart the container ?
I wonder if that would fix it
it did not
@here We are looking for a group of people experiencing errors with the new release of homarr, if you are having issues please let @Manicraft1001 know you'd be interested in helping us fix this issue.
Send a message there : https://discord.com/channels/972958686051962910/1173242881486635092
Solution
GitHub
Release v0.14.1 Stability improvement and bug fixes · ajnart/homarr
Your issues should be resolved!
During the last release, we didn't spend enough time to test on different hardware configurations to ensure that v0.14.0 would work on the majority of people'...
fwiw - i last updated my container image 10/31/23 to whatever the latest version was at the time - no issues. Today I tried updating to 0.14.2 and had the database issue. It was a zero byte size db.sqllite. I stopped the container, deleted the file, and restarted and got a 2nd db.sqllite. Tried chmod, no difference. Ultimately I downloaded the above sample db.sqllite, put in place, and things fired right up.
thanks, this helped me as well
Now I'm stuck on the account creation page 😦 After entering a username and a password, and clicking on Continue, the spinner just keeps spinning. Any ideas on what could be done?
Please open a new post / issue @zlob1n8863
Hello I updated Homarr through portainer and im getting the following message An unexpected error has occurred This page has crashed unexpectedly. We're sorry for the inconvenience. Please try again or contact an administrator
Please open a new post in #💬・get-help and post your log