user warning: Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT query: SELECT DISTINCT nc.nid FROM iht_node_comment_statistics nc INNER JOIN iht_node_access na ON na.nid = nc.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 0 AND na.realm = 'node_privacy_byrole_user'))) AND ( nc.comment_count > 0 )ORDER BY nc.last_comment_timestamp DESC LIMIT 0, 10 in /home/s0574a8b/public_html/iht/modules/comment/comment.module on line 313.

Problem activation?

Sin respuestas
Imagen de shaggy_machine
Integró: 14/02/2009

"Hi there, I dont know if I am writing in a proper board but I have got a problem with activation, link i receive in email is not working... (Edited link)"


We have received five identical comments like this on differents parts of the site made for an anonymous user, telling us about a problem on the registration process. None of them in a correct place.

Well, anonymous comments are not shown by default while an IHT's admin don't publish it, so I would like to tell this user a few things:

Please, no more spam! If you have not an account and are not logged in, your comments will not be public. Next time, if you have a problem and don't have an IHT account, it is more quickly if you send us an email using the contact form of this website.

Now, your problem.

When anybody request a new account, there is a proccess to validate this registry.

IHT will send an email to confirm the user mail. In this mail, there is a link to confirm that this mail it is valid. This link will expire in 24 hours if it is not used.

Probably this was your problem.

After checking the mail, IHT will send a new email explaining the identity verification process through Hattrick, in order to verify the registry data.

Finally, our Access manager will activate the account.

Probably, the link included on first email was expired when you clicked it.

There are two solutions:

  1. Repeat the account request and follow correctly every step explain on the mails. (Recommended)
  2. Send us an email through the contact form with your registry data to restart the registry process at the fail point.

Best regards, Shaggy.
IHT Admin