ben_1uk Posted November 21, 2013 Share Posted November 21, 2013 Hello everyone, Firstly, apologies if this has not been posted in the correct forum! I have a database containing details of visitors to our website who have registered an account. Upon registering for an account, they are first required to activate the account via a link contained within an E-mail. However, I have noticed there are an awful lot of accounts that have not been activated - presumably because they have not received the E-mail. Upon logging into PHPmyAdmin, I have a 'prune' option, which appears to allow me to verify user's registration attempts manually if they have not been authorised by users themselves via Email. The option to 'prune' covers inactive accounts going back as far as 1 month. I am a complete noob when it comes to working with database driven websites and wondered if there was any reason why I should NOT use the 'prune' option to verify these inactive accounts, i.e. in case of any spurious addresses, etc. Thanks in advance. Ben_1uk Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/ Share on other sites More sharing options...
BrodaNoel Posted November 21, 2013 Share Posted November 21, 2013 Wait... Prune option? You should be give us more information about this "option". Can you paste here some screenshot? I dont know some "prune option" in PHPMyAdmin, but, this function can be some function created for any database admin of your website. Please, give more information about this option. Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/#findComment-1459365 Share on other sites More sharing options...
QuickOldCar Posted November 23, 2013 Share Posted November 23, 2013 A lot of those registered accounts not activated are probably spammers. Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/#findComment-1459683 Share on other sites More sharing options...
BrodaNoel Posted November 26, 2013 Share Posted November 26, 2013 (edited) Or, the emails are landing in the SPAM folder. Edited November 26, 2013 by BrodaNoel Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/#findComment-1460204 Share on other sites More sharing options...
ben_1uk Posted December 5, 2013 Author Share Posted December 5, 2013 I think the reason there are so many inactive accounts is down to the emails landing in people's junk email. I have added a note advising people to add the email address used by the system to their list of 'safe senders' if they're experiencing difficulties in getting the email to come through. Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/#findComment-1461321 Share on other sites More sharing options...
sKunKbad Posted January 4, 2014 Share Posted January 4, 2014 If you want to get rid of records that have not been activated, then just use a DELETE query, like this: DELETE FROM the_table WHERE activated IS NULL You could of course customize that as needed, but whatever this prune feature is, you don't need it. Quote Link to comment https://forums.phpfreaks.com/topic/284134-phpmyadmin-question/#findComment-1463777 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.