• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Registration confirmation fails with an error.

#1
Hi, I've a problem with my Xf installation.
I've registered some initial staffer accounts without problems, and recently I've opened the site to the public.
I noticed no one can confirm the account, clicking on the link received via mail.
The link route always to a generic "server error" (a xenforo themed error page), and inside the server error log I found this entry:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 AND conversation_id = 10' at line 4 -library/Zend/Db/Statement/Mysqli.php:77

Stack Analysis
#0 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('??????UPDATE xf...')
#1 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '??????UPDATE xf...')
#2 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('??????UPDATE xf...')
#3 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/Andy/NewUserConversation/DataWriter/User.php(185): Zend_Db_Adapter_Abstract->query('??????UPDATE xf...')
#4 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/XenForo/DataWriter.php(1409): Andy_NewUserConversation_DataWriter_User->_postSave()
#5 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/XenForo/ControllerPublic/AccountConfirmation.php(54): XenForo_DataWriter->save()
#6 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_AccountConfirmation->actionEmail()
#7 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /var/www/vhosts/035.uxapp03.myftp.it/httpdocs/forum/index.php(13): XenForo_FrontController->run()
#9 {main}

Request Status
array(3) {
["url"] => string(71) "http://website.com/forum/account-confirmation/11/email?c=ReGPmnTYjvrTbS-X"
["_GET"] => array(1) {
["c"] => string(16) "ReGPmnTYjvrTbS-X"
}
["_POST"] => array(0) {
}
}
Thank you in advance for ANY reply that can be useful to solve this problem.
 
#3
Thank you, now it works.
May I ask why NUC plugin is the cause of this problem if I've another XF forum with very similar configuration (but different hosting service) and everything works correctly..?