Suddenly being asked to Confirm My Email Address??? Doesn't work

[scooke]

So I've been using Vikunja for awhile. Tonight I decided to try out the Teams. I logged out, and went to register a new user. But, the email confirmation never came.

Suddenly, my regular user is being asked to "Confirm my email address", but the app is not sending any emails.

Any ideas what happened?

This is convulted, but when I was trying to confirm or reset, I mistyped the regular users email address, so now the problem is Cloudron tells me there is no way to send to that address. I actually did an UPDATE in the PostgreSQL db, but the changes didn't stick.

Typing in the correct email address for the user in the Reset PAssword box gives me the same error in the logs.

And the worst part is, I just spent about 8 hours making a really nice Task list, boards, tags, everything, and then this!

Help!

[scooke]

@scooke Ok, I figured out how to get back in but I still don't know why this change in my regular user's status happened.

Thankfully Cloudron allows access to all kinds of background goodies. In this case, what was important is the PostgreSQL db. So, off to learn to some psql commands!

I figured out I had to deal with two bits of info in two columns. The is_active column and the email_confirm_token.

Using the following I could UPDATE the is_active from 'f' to 't':
UPDATE users SET is_active='t' WHERE id='1';

I thought this would be enough to get me in, but when the login page was still asking for the email confirmation, I looked in the db and realized that the email_confirm_token still had something. So, I checked the earlier confirmation email, which was
https://myvikunja.install.com?userEmailConfirm=longstring, and replaced the longstring with the data still in the db column., and put that into the browser. Voila, I was then (re)confirmed, and could log in. Phew. I was really worried a good day's work was lost.

But, WHY this reset on my user??

[girish]

For future readers, adding a link to the upstream discussion here - https://community.vikunja.io/t/long-time-regular-main-user-being-asked-to-confirm-email-address/195/