1. 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.

Discussion in 'Troubleshooting and Problems' started by timetraveler, May 2, 2015.

  1. timetraveler

    timetraveler Member

    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:

    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.
  2. Tracy Perry

    Tracy Perry Well-Known Member

    Disable your New User Conversation add-on.
    timetraveler likes this.
  3. timetraveler

    timetraveler Member

    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..?
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You will need to post in the resource thread for support with it.
    timetraveler likes this.

Share This Page