Missing User Activation Key in MySQL DB

This forum will support your queries about the pricerr theme.

Moderators: seogawd, SiteMile Support Team

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Tue Mar 06, 2018 3:32 pm

Only 4 users have some code under column for User Activation Key and I'm asking for info about it. The next column right in my DB is "Status" and those listed are "0" (zero). I've searched these forums and found nothing so I'm asking for any and all info you can supply.

User avatar
andreisaioc
Site Admin
Posts: 17743
Joined: Wed Feb 09, 2011 7:16 pm
User Type: SiteMile Support
Location: Europe
Contact:

Re: Missing User Activation Key in MySQL DB

Post by andreisaioc » Tue Mar 13, 2018 1:03 pm

the users table comes from wordpress itself, so i think thats pretty much secure. You have nothing to worry about.

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Re: Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Fri Apr 13, 2018 1:24 pm

So is it normal for the PhpMySQL admin to show only 3-4 users and not show the keys for all the other users?

User avatar
andreisaioc
Site Admin
Posts: 17743
Joined: Wed Feb 09, 2011 7:16 pm
User Type: SiteMile Support
Location: Europe
Contact:

Re: Missing User Activation Key in MySQL DB

Post by andreisaioc » Sat Apr 14, 2018 7:28 pm

what keys ? nothing makes sense. Please provide actual facts and details, and screenshots if you have. The database is designed by wordpress people itself, they are not wrong. And if anything in the user table, take it with them. I really think they have done a good job and the system works fine.

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Re: Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Sun Apr 15, 2018 6:59 am

OK here is a copy of part of the database and notice the user activation keys are missing.
Attachments
sitemile-userkeys.jpg
sitemile-userkeys.jpg (260.26 KiB) Viewed 45 times

User avatar
andreisaioc
Site Admin
Posts: 17743
Joined: Wed Feb 09, 2011 7:16 pm
User Type: SiteMile Support
Location: Europe
Contact:

Re: Missing User Activation Key in MySQL DB

Post by andreisaioc » Sun Apr 15, 2018 10:13 am

thats because the accounts are activated right off, since the user doesnt choose his password at first, and its sent to their email. And if they provide a bad email address then its a good way to verify they provide a valid email address, otherwise they dont get the password

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Re: Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Sun Apr 15, 2018 5:17 pm

1.) So we are to DELETE everyone without a user_activation_key, because they are not valid?
2.) Is there someplace to require they CONFIRM EMAIL when registering?
3.) Do you believe sending each one an email asking to confirm his registration is good idea?
4.) If sending another email asking for confirmation is good idea, do we just delete them then say they must register again?
5.) HOW is it that some have keys and how did the others become registered WITHOUT user_activation_keys?

If there is some coding that guarantees ALL registered users have valid activation keys appearing in this DB, please share the code.

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Re: Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Sun Apr 15, 2018 5:22 pm

Because you have said our host is disabling the RESET PASSWORD function, I'm confused how they received any password in the 1st place. It appears to me the mail function DID INDEED work but later has been shut off by some coding. Some assistance here would be appreciated as the theme is not working correctly with this function blocked. You can test it yourself by visiting the site, registering, and later asking about LOST PASSWORD. https://asianhighway26.com is where to begin.

User avatar
andreisaioc
Site Admin
Posts: 17743
Joined: Wed Feb 09, 2011 7:16 pm
User Type: SiteMile Support
Location: Europe
Contact:

Re: Missing User Activation Key in MySQL DB

Post by andreisaioc » Sun Apr 15, 2018 7:47 pm

i do think this discussion is pointless and you totally messed things up, interchanging different post replies, and assuming things i didnt say.
i do think you need to check if the host allows emails or not from the server thats all

AsianHighwayNetwork
Posts: 136
Joined: Thu Sep 03, 2015 4:35 pm
User Type: Standard User
Location: ASIA
Contact:

Re: Missing User Activation Key in MySQL DB

Post by AsianHighwayNetwork » Wed Apr 18, 2018 8:20 pm

I'm asking HOW DID THOSE few names obtain an activation key?

Post Reply

Return to “Pricerr Theme Support”