This forum is archived. Posts are preserved for historical reference. For current help, join us on Discord.

first verify Email send with register do not work

In UserSpice 4.3 and Below · Started by SirAirHard on 2018-08-28 1:47 pm · 18908 views · 4 replies

Hello :)
i have tryed tu report a bug, but it doesn´t work...

i have a problem with the verification email.

if a user registers the system sends an verfy email and he gets an error and is asked to send another verify Email.
and this email gets verifyed.

i had a look at the code and i can´t realy find a differenc...

thanks for your help

Hello :)
i have tryed tu report a bug, but it doesn´t work...

i have a problem with the verification email.

if a user registers the system sends an verfy email and he gets an error and is asked to send another verify Email.
and this email gets verifyed.

i had a look at the code and i can´t realy find a differenc...

thanks for your help

Can you edit /users/helpers/helpers.php find the function "function email($to,$subject,$body,$opts=[],$attachment=false){"
and add this code 
$mail->SMTPOptions = array(
                        	'ssl' => array(
                            'verify_peer' => false,
                            'verify_peer_name' => false,
                            'allow_self_signed' => true
                        	)
                    	);
 It's perfect for me. Have a good luck.


Can you edit /users/helpers/helpers.php find the function "function email($to,$subject,$body,$opts=[],$attachment=false){"
and add this code 
$mail->SMTPOptions = array(
                        	'ssl' => array(
                            'verify_peer' => false,
                            'verify_peer_name' => false,
                            'allow_self_signed' => true
                        	)
                    	);
 It's perfect for me. Have a good luck.

Thanks for your quick reply.

i have tryed it but it did not work
my code looks like this now:
function email($to,$subject,$body,$opts=[],$attachment=false){
/*you can now pass in
$opts = array(
  'email' => 'from_email@aol.com',
  'name'  => 'Bob Smith'
);
*/
	$db = DB::getInstance();
	$query = $db->query("SELECT * FROM email");
	$results = $query->first();

	$mail = new PHPMailer;
        $mail->SMTPOptions = array(
                           'ssl' => array(
                           'verify_peer' => false,
                           'verify_peer_name' => false,
                           'allow_self_signed' => true
                           )
                       );
	$mail->SMTPDebug = $results->debug_level;
and i get this on my homepage:

We were unable to verify your account. Please try again.
(and a button that says: Resend Verification Email)

is it maybe becouse i have https now?
The problem is related to the last_verify column in the database. We set this to timestamp, which means most databases are updating this on every action. If the user logs in, or is modified before they verify, it renders the verification URL invalid. The fix for it is running the following SQL:
ALTER TABLE users DROP COLUMN vericode_expiry;
ALTER TABLE users ADD COLUMN vericode_expiry datetime;

Thank you,
Brandin.
Thanks for your quick answer that fixed the Problem
I love this software =)