Fixed Error on registration?

[PVO_Dave]

I'm trying to get a copy of what the user gets, but the server logs show:

Mysqli statement execute error : Duplicate entry 'stopForumSpam_3ab092f2d6474854749139bdae39fa80ff6e294e' for key 'PRIMARY'

Anything I can do or check whilst I wait for a copy of the user shown error? I believe the user is registering using an Android phone.

Dave.

 

[Jake Bunce]

Check the log and post the full error message including the stack trace:

Admin CP -> Tools -> Server Error Log

 

[PVO_Dave]

Thanks Jake.


#0 /var/www/vhosts/ukguitarforum.com/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/ukguitarforum.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/ukguitarforum.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/Model/SpamPrevention.php(465): Zend_Db_Adapter_Abstract->insert('xf_registration...', Array)
#4 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/Model/SpamPrevention.php(146): XenForo_Model_SpamPrevention->_cacheRegistrationDecision('stopForumSpam_3...', 0)
#5 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/Model/SpamPrevention.php(31): XenForo_Model_SpamPrevention->_checkSfsResult(Array, Object(Zend_Controller_Request_Http))
#6 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/Model/SpamPrevention.php(23): XenForo_Model_SpamPrevention->_allowRegistration(Array, Object(Zend_Controller_Request_Http))
#7 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/ControllerPublic/Register.php(267): XenForo_Model_SpamPrevention->allowRegistration(Array, Object(Zend_Controller_Request_Http))
#8 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/FrontController.php(335): XenForo_ControllerPublic_Register->actionRegister()
#9 /var/www/vhosts/ukguitarforum.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts/ukguitarforum.com/httpdocs/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(52) "http://ukguitarforum.com/index.php?register/register"
["_GET"] => array(1) {
["register/register"] => string(0) ""
}
["_POST"] => array(14) {
["username"] => string(5) "james"
["email"] => string(26) "ukguitarforum@musXXX"
["password"] => string(8) "********"
["password_confirm"] => string(8) "********"
["dob_month"] => string(2) "1"
["dob_day"] => string(2) "2"
["dob_year"] => string(4) "1"
["gender"] => string(0) ""
["timezone"] => string(13) "Europe/London"
["recaptcha_challenge_field"] => string(185) "03AHJ_Vuv1uXqtwMjGTFjyp5iR8IdN2ahv0laGrsVrCe6C_tbPFrKIVSGGBYpog2Xe4WoOZee5s-THmMxNmGuXgEVxLAEuCh6tTFcu9e5JpyFTb2sGpFuy7vpk51T9VnebrjhJ4fuRJIOz4wcc-SabAfA3C4gbtPHCkRp0kSinxmA1eGlQnVLITis"
["recaptcha_response_field"] => string(10) "are inotsv"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "a90d1c5cde7bd88ba6dcaf4d87c9104b"
}
}


I've amended the email address and DOB details.

 

[PVO_Dave]

What the user gets

 

[Mike]

Moved this to bugs to be looked at.

 

[PVO_Dave]

Thanks Mike, I'll test with "Check DNSBL on registration" disabled if i can and report back

 

[Mike]

Well, if you disable the StopForumSpam checks, it should prevent it. Some of the code surrounding this has changed for beta 2 though as is.

 

[PVO_Dave]

Hi Mike,

I tried disabling the option mentioned above, but he still got the error!

He then tried an email without a hyphen and he could then register, hope that helps with testing etc ...

Dave.

 

[Mike]

This is fixed now. Fixed the error in question and a logic bug surrounding it.

 

[PVO_Dave]

Thanks Mike - I'll try and get it tested with the next beta release

Dave.

 

[Sportsoutlaw]

Is there a temp fix we can apply for this?

 

[Jeremy]

Yes, update.

 

[PVO_Dave]

I was going to ask if this was fixed in the newly released Beta 2 - if so I'll update tonight and get it tested

 

[Sportsoutlaw]

Yes, update.

Yes, now that an update is available, LOL.

 

[Sportsoutlaw]

Just an FYI, registrations still didn't work after updating to beta3. Cleared out the error logs, and tried again to reregister. Turns out, my error was coming from Taigachat, which I had disabled, but not uninstalled. Uninstalling the product removed the error that was blocking registration.

 

[PVO_Dave]

Just to confirm this is now resolved after testing again on Beta3. Thanks for the swift work @Mike