UPDATE alle_newsletter
SET status = 1, newsletter = 1, updatedate = NOW(), active = 1,
clang_id = 2, group_ids = "|1|", subscriptiontype = "web"
WHERE activationkey = "" AND email = "" AND status = 0
The registration has failed. Please try a new registration and confirm the link we send in an email.