The activation link is only for new accounts. Based on the screenshot from before of the query with the errors the recovery link was what you needed, this is confirmed by it asking you for your recovery kit.
Since you don’t have your recovery kit you won’t be able to log in with that account, you’ll need to make a new admin account and then log in with that one to correct the issue. You can do this by running:
su -m -c "/usr/share/php/passbolt/bin/cake \
passbolt register_user \
-u your@email.com \
-f yourname \
-l surname \
-r admin" -s /bin/sh www-data
You’ll want to use a valid email address here and it will have to be different from your original account but once you are in you could delete your old admin account and then recreate it with the email address you were using