Homarr•10mo ago

Error after updating (not sure which tag to assign to it)

Hello! I'll preface this by saying it probably is some very stupid error on my part. It's been a while since I've updated Homarr. I've updated it through portainer, using recreate with "Re-pull the image". Now that I've updated it, I get an error page saying "An unexpected error has occurred. - Type: Client side". When I go to the logs, I get this:

 2024-03-08T23:53:24.130529671Z   shape: {
2024-03-08T23:53:24.130533378Z   message: 'no such table: user',
2024-03-08T23:53:24.130536893Z   code: -32603,
2024-03-08T23:53:24.130540360Z   data: {
2024-03-08T23:53:24.130543847Z   code: 'INTERNAL_SERVER_ERROR',
2024-03-08T23:53:24.130547283Z   httpStatus: 500,
2024-03-08T23:53:24.130550649Z   path: 'user.count',
2024-03-08T23:53:24.130553965Z   zodError: null
2024-03-08T23:53:24.130557392Z }
2024-03-08T23:53:24.130560768Z },
2024-03-08T23:53:24.130564105Z   data: {
2024-03-08T23:53:24.130567561Z   code: 'INTERNAL_SERVER_ERROR',
2024-03-08T23:53:24.130570987Z   httpStatus: 500,
2024-03-08T23:53:24.130574153Z   path: 'user.count',
2024-03-08T23:53:24.130577480Z   zodError: null
2024-03-08T23:53:24.130580956Z },
2024-03-08T23:53:24.130584282Z   name: 'TRPCClientError'
2024-03-08T23:53:24.130587417Z },
2024-03-08T23:53:24.130590794Z   elapsedMs: 21
2024-03-08T23:53:24.130594200Z }
2024-03-08T23:53:24.130597677Z Error [TRPCClientError]: no such table: user
2024-03-08T23:53:24.130601343Z     at TRPCClientError.from (file:///app/.next/server/src/middleware.js:1718:20)
2024-03-08T23:53:24.130605060Z     at <unknown> (file:///app/.next/server/src/middleware.js:2273:60)
2024-03-08T23:53:24.130615249Z     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

 2024-03-08T23:53:24.130529671Z   shape: {
2024-03-08T23:53:24.130533378Z   message: 'no such table: user',
2024-03-08T23:53:24.130536893Z   code: -32603,
2024-03-08T23:53:24.130540360Z   data: {
2024-03-08T23:53:24.130543847Z   code: 'INTERNAL_SERVER_ERROR',
2024-03-08T23:53:24.130547283Z   httpStatus: 500,
2024-03-08T23:53:24.130550649Z   path: 'user.count',
2024-03-08T23:53:24.130553965Z   zodError: null
2024-03-08T23:53:24.130557392Z }
2024-03-08T23:53:24.130560768Z },
2024-03-08T23:53:24.130564105Z   data: {
2024-03-08T23:53:24.130567561Z   code: 'INTERNAL_SERVER_ERROR',
2024-03-08T23:53:24.130570987Z   httpStatus: 500,
2024-03-08T23:53:24.130574153Z   path: 'user.count',
2024-03-08T23:53:24.130577480Z   zodError: null
2024-03-08T23:53:24.130580956Z },
2024-03-08T23:53:24.130584282Z   name: 'TRPCClientError'
2024-03-08T23:53:24.130587417Z },
2024-03-08T23:53:24.130590794Z   elapsedMs: 21
2024-03-08T23:53:24.130594200Z }
2024-03-08T23:53:24.130597677Z Error [TRPCClientError]: no such table: user
2024-03-08T23:53:24.130601343Z     at TRPCClientError.from (file:///app/.next/server/src/middleware.js:1718:20)
2024-03-08T23:53:24.130605060Z     at <unknown> (file:///app/.next/server/src/middleware.js:2273:60)
2024-03-08T23:53:24.130615249Z     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

Any idea where should I even start looking for a fix?

Solution:

Actually, I think you might have updated from a pre Auth version. Did you add the mount for the database? We'll need to check your docker-compose if you did use that....

Jump to solution

16 Replies

Cakey Bot•10mo ago

Thank you for submitting a support request. Depending on the volume of requests, our team should get in contact with you shortly.

⚠️ Please include the following details in your post or we may reject your request without further comment: - Log (See https://homarr.dev/docs/community/faq#how-do-i-open-the-console--log) - Operating system (Unraid, TrueNAS, Ubuntu, ...) - Exact Homarr version (eg. 0.15.0, not latest) - Configuration (eg. docker-compose, screenshot or similar. Use ``your-text`` to format) - Other relevant information (eg. your devices, your browser, ...)

❓ Frequently Asked Questions | Homarr documentation

Can I install Homarr on a Raspberry Pi?

Manicraft1001•10mo ago

Hi, what file storage do you use? Is it a SMB mounted share? What does your config look like?

CtaethOP•10mo ago

Ahhhh I'm lost there. I'm using a VPS and have no idea there. As for config, I'm fairly sure it was just some default docker-compose from github. I don't have the compose anymore since it was created using an older version of portainer and i didnt know how to keep "permissions" to view/edit the compose file through versions

Solution

Serenaphic•10mo ago

Actually, I think you might have updated from a pre Auth version. Did you add the mount for the database? We'll need to check your docker-compose if you did use that.

CtaethOP•10mo ago

Is that Auth version from within the last year? Cause in that case, I havent. Im using the default password on the front page but thats it

Serenaphic•10mo ago

V0.14 from november

CtaethOP•10mo ago

ok yeah i might not have updated since lol

Serenaphic•10mo ago

Default password was deprecated in favor of a full userbase authentication system

CtaethOP•10mo ago

Then again, if i use the latest docker-compose shown on documentation, I shouldn't lose any info as long as I dont delete the volume or will it?

Serenaphic•10mo ago

Do a backup, always best practice. But no you shouldn't

CtaethOP•10mo ago

i mean... as you can tell I'm a very newbie... I'm just gonna Leeroy it and if it breaks I'll just re-add things back

Serenaphic•10mo ago

It's best if you use the same docker compose as you already have, simply add this line under volumes: - ./homarr/data:/data This way you make sure you're not changing the other mounts.

Serenaphic•10mo ago

You mentioned portainer earlier, maybe this line is more representative: - <your-path>/data:/data Just change "<your-path>" to the same paths used on the lines above. https://homarr.dev/docs/getting-started/installation#-portainer-ce

🚀 Installation | Homarr documentation

We provide multiple installation methods. Are you a newbie to Docker? We recommend Docker Compose for beginners.

CtaethOP•10mo ago

I dont know which path i've used before, but in any case a fresh start will get me tinkering again and the volume is still there somewhere (i think) so all good I've updated it and it does now work. It was that auth issue

Serenaphic•10mo ago

Wonderful, make sure to update often, we post announcements here about breaking issues such as those

CtaethOP•10mo ago

Yeah i know.. I just sort of lost interest there for a little while (with my meagre self hosting I mean) and now for some reason decided to give it some updates lol Besides, it probably has so many new things that forcing me to set it up again will show me new things haha

Gaming

Programming

Error after updating (not sure which tag to assign to it)