Community

Forums » 3rd Party Product Discussions

Subscription Sign Up Issues

    • 1 posts
    October 8, 2018 5:44 PM EDT

    I am running into an issue where users cannot sign-up unless I disable all subscription plans.  If a subscription plan is enabled and a user tries to sign up they get an error message that says:  "Choose Plan.  Please provide a valid answer for this field."  (even though it was already selected).  

     

    <pre>2018-10-08T20:52:42+00:00 CRIT (2): exception 'Zend_Db_Statement_Mysqli_Exception' with message '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 ')) AND (user_id <> 1) LIMIT 3' at line 1' in /home/website/public_html/domain/application/libraries/Zend/Db/Statement/Mysqli.php:77 Stack trace: </code></p> <p><code>#0 /home/website/public_html/domain/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `engine4...') </code></p> <p><code>#1/home/website/public_html/domain/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `engine4...') </code></p> <p><code>#2/home/website/public_html/domain/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT `engine4...') </code></p> <p><code>#3/home/website/public_html/domain/application/libraries/Zend/Db/Table/Abstract.php(1577): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select)) </code></p> <p><code>#4/home/website/public_html/domain/application/libraries/Zend/Db/Table/Abstract.php(1392): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) </code></p> <p><code>#5/home/website/public_html/domain/application/modules/Sesmember/Api/Core.php(155): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) </code></p> <p><code>#6 /home/website/public_html/domain/application/modules/Sesmember/widgets/people-you-may-know/Controller.php(37): Sesmember_Api_Core->getMutualFriends('3') </code></p> <p><code>#7/home/website/public_html/domain/application/libraries/Engine/Content/Widget/Abstract.php(254): Sesmember_Widget_PeopleYouMayKnowController->indexAction() </code></p> <p><code>#8/home/website/public_html/domain/application/libraries/Engine/Content/Element/Widget.php(73): Engine_Content_Widget_Abstract->render(NULL) </code></p> <p><code>#9/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(583): Engine_Content_Element_Widget->_render() </code></p> <p><code>#10/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#11/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#12/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#13/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#14/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#15/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#16/home/website/public_html/domain/application/libraries/Engine/Content.php(219): Engine_Content_Element_Abstract->render() </code></p> <p><code>#17/home/website/public_html/domain/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(136): Engine_Content->render('user_index_home') </code></p> <p><code>#18/home/website/public_html/domain/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(38): Engine_Content_Controller_Action_Helper_Content->render() </code></p> <p><code>#19/home/website/public_html/domain/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Engine_Content_Controller_Action_Helper_Content->postDispatch() </code></p> <p><code>#20/home/website/public_html/domain/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch() </code></p> <p><code>#21/home/website/public_html/domain/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('homeAction') </code></p> <p><code>#22/home/website/public_html/domain/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) </code></p> <p><code>#23 /home/website/public_html/domain/application/modules/Core/Bootstrap.php(84): Zend_Controller_Front->dispatch() </code></p> <p><code>#24/home/website/public_html/domain/application/libraries/Engine/Application.php(160): Core_Bootstrap->run() </code></p> <p><code>#25 /home/website/public_html/domain/application/index.php(223): Engine_Application->run() </code></p> <p><code>#26 /home/website/public_html/domain/boot.php(47): include('/home/website/...') #27 /home/website/public_html/domain/index.php(24): Engine_Boot->boot() </code></p> <p><code>#28 {main}</pre>


    This post was edited by aarflo at October 8, 2018 9:20 PM EDT
    • 2459 posts
    October 9, 2018 5:32 AM EDT

    I'll move this to third party product discussions since this shows for the sesmember plugin in your error message.


    This post was edited by Donna at October 9, 2018 5:33 AM EDT
  • October 11, 2018 2:35 AM EDT
    aarflo said:

    I am running into an issue where users cannot sign-up unless I disable all subscription plans.  If a subscription plan is enabled and a user tries to sign up they get an error message that says:  "Choose Plan.  Please provide a valid answer for this field."  (even though it was already selected).  

     

    #0 /home/website/public_html/domain/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `engine4...') </code></p> <p><code>#1/home/website/public_html/domain/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `engine4...') </code></p> <p><code>#2/home/website/public_html/domain/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT `engine4...') </code></p> <p><code>#3/home/website/public_html/domain/application/libraries/Zend/Db/Table/Abstract.php(1577): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select)) </code></p> <p><code>#4/home/website/public_html/domain/application/libraries/Zend/Db/Table/Abstract.php(1392): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) </code></p> <p><code>#5/home/website/public_html/domain/application/modules/Sesmember/Api/Core.php(155): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) </code></p> <p><code>#6 /home/website/public_html/domain/application/modules/Sesmember/widgets/people-you-may-know/Controller.php(37): Sesmember_Api_Core->getMutualFriends('3') </code></p> <p><code>#7/home/website/public_html/domain/application/libraries/Engine/Content/Widget/Abstract.php(254): Sesmember_Widget_PeopleYouMayKnowController->indexAction() </code></p> <p><code>#8/home/website/public_html/domain/application/libraries/Engine/Content/Element/Widget.php(73): Engine_Content_Widget_Abstract->render(NULL) </code></p> <p><code>#9/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(583): Engine_Content_Element_Widget->_render() </code></p> <p><code>#10/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#11/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#12/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#13/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#14/home/website/public_html/domain/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render() </code></p> <p><code>#15/home/website/public_html/domain/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('') </code></p> <p><code>#16/home/website/public_html/domain/application/libraries/Engine/Content.php(219): Engine_Content_Element_Abstract->render() </code></p> <p><code>#17/home/website/public_html/domain/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(136): Engine_Content->render('user_index_home') </code></p> <p><code>#18/home/website/public_html/domain/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(38): Engine_Content_Controller_Action_Helper_Content->render() </code></p> <p><code>#19/home/website/public_html/domain/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Engine_Content_Controller_Action_Helper_Content->postDispatch() </code></p> <p><code>#20/home/website/public_html/domain/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch() </code></p> <p><code>#21/home/website/public_html/domain/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('homeAction') </code></p> <p><code>#22/home/website/public_html/domain/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) </code></p> <p><code>#23 /home/website/public_html/domain/application/modules/Core/Bootstrap.php(84): Zend_Controller_Front->dispatch() </code></p> <p><code>#24/home/website/public_html/domain/application/libraries/Engine/Application.php(160): Core_Bootstrap->run() </code></p> <p><code>#25 /home/website/public_html/domain/application/index.php(223): Engine_Application->run() </code></p> <p><code>#26 /home/website/public_html/domain/boot.php(47): include('/home/website/...') #27 /home/website/public_html/domain/index.php(24): Engine_Boot->boot() </code></p> <p><code>#28 {main}</pre>

    Hello Aarflo,

    Please send your issue to our support team so that we can look into the issue and fix it asap from here: https://www.socialenginesolutions.com/support/

     

    Regards

    Team SES (SocialEngineSolutions)