More clear activation failure message

When a new account activation fails, include suggestions of possible
reasons for the failure including miscopying the link and having
already clicked the link.

Addresses #836