Back

Can'r recover admin password

  • 0
  • Self Hosted
ftp27
3 Oct, 2023, 21:25

Hello. I'm trying to change admin password because for some reason I can't login with old one. Here is part of logs:

TypeScript
[Error] Timestamp: 2023-10-03T21:22:19+00:00
[Error] Method: PUT
[Error] URL: /v1/account/recovery
[Error] Type: Utopia\Database\Exception\Structure
[Error] Message: Invalid document structure: Unknown attribute: "labels"
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 3056

Could you help me with the issue or advice how to change the password using console?

p.s. I made migrations and I can see labels column in the database table. It's null

TL;DR
User is unable to recover the admin password and is unable to login with the old password. They received an error mentioning an invalid document structure related to the "labels" attribute. They are looking for a solution to change the password using the console. Solution: It is suggested to restore from a backup instead of trying to fix the issue on-site. Deleting columns won't work and could potentially make the situation worse.
Drake
4 Oct, 2023, 02:01

Did you upgrade recently?

ftp27
4 Oct, 2023, 08:14

I did. But the reason of my update was this issue.

ftp27
4 Oct, 2023, 11:51

Is it possible to fix it on place? May be add/remove some columns in the database and run migration over again? I had migration issue while update to 1.4.x and fixed it by removing project columns (database, smtp and templates) which suppose to be added while the migration and after that it was finished without errors.

Drake
4 Oct, 2023, 14:27

Oye...to go back from migration, you need to restore from a backup ...deleting columns won't work and could make things worse

ftp27
4 Oct, 2023, 15:15

The server works at least. So it's better then nothing. May be I should try to make clean install and move all data with API πŸ™‚ But it looks quite challenging

Drake
4 Oct, 2023, 16:31

that would be best. if you're the database schema is in an inconsistent state, future upgrades could be problematic

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more