Re: Strange account activation problem

Hi, Daniel O'Connor wrote:

I just tried to posted a contribution to PHP_CodeSniffer (see [0]) If I try to visualize the bug I get the message: "The user who submitted this bug has not yet confirmed their email address." This is however not true. My email address (jerico.dev@gmail.com) has been verified and activated for the account jerico. If I click on "click here to resend" in [0] I get the message "Error: handle is either already verified or does not exist" Can you please help me to get the bug report out of the doors? Florian [0] http://pear.php.net/bugs/bug.php?id=16465

Ah sorry about that Florian, it's been an long standing issue and we aren't sure on how to reproduce it re the confirmation oddities. The bug report is successfully added, so should be visible by the maintainer. Hopefully both will end up fixed in the not too distance future!

I had a brief look at pearweb code, there are some obvious problems. First, confirmation of account on bug page is checked via a flag in bugdb table, while it is checked via absence of record in bug_account_request table on resend-request page. Next, the biggest problem is related to pearweb using The Most Popular Open Source Database: My$QL doesn't allow having fulltext index on a transactional table, so bugdb table has no constraints and / or foreign keys. Therefore confirmRequest() method is extremely fragile, with a large amount of updates outside a transaction block and without any constraint checking. Also there is that strange PEAR_Bug_Accountrequest::cleanOldRequests() method that probably does not work as expected, since the unconfirmed bug linked above is still here.