XF 1.3 Confirmation links are not working

Hi I have a problem with confirmation links not working.

The user gets the confirmation email ok but when you click it goes to the forum but it still says:
Your account is currently awaiting confirmation. Confirmation was sent to [users email].
Resend Confirmation Email

I have the latest version 1.3.4

Any idea what the problem could be?

Also I have about 30 unconfirmed users, any advice on how i could bulk manually change their state to approved? Run an sql query?