Changeset 12227 for extensions/UserAdvManager/trunk/ConfirmMail.php

Timestamp:

Sep 25, 2011, 9:55:57 PM (13 years ago)

Author:

Eric

Message:

bug 2445 fixed : Duplicate key MySql error when a registered user tries to validate his registration twice

File:

• extensions/UserAdvManager/trunk/ConfirmMail.php (modified) (1 diff)

extensions/UserAdvManager/trunk/ConfirmMail.php

@@ -44 +44 @@
 /* We have to get the user's language in database */
     $query = '
-SELECT '.USER_INFOS_TABLE.'.language
-FROM '.USER_INFOS_TABLE.','.USER_CONFIRM_MAIL_TABLE.'
-WHERE (('.USER_INFOS_TABLE.'.user_id ='.$userid.') AND ('.USER_INFOS_TABLE.'.user_id = '.USER_CONFIRM_MAIL_TABLE.'.user_id))
+SELECT language
+FROM '.USER_INFOS_TABLE.'
+WHERE '.USER_INFOS_TABLE.'.user_id ='.$userid.'
 ;';
     $data = pwg_db_fetch_assoc(pwg_query($query));