Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12052

Member dashboard fails where previously working

    Details

      Description

      D. Lobo asked me to start this as an issue. Please also let me know what else anyone may need to help with the beta. I don't know what else you may need. Any tips on what is going wrong or where to find the issue would be very appreciated.

      The environment is:

      CiviCRM 4.3 beta 1
      Wordpress 3.5.1
      CiviMember
      CiviContribute
      Custom template (converted by gconverter)

      A previously working member dashboard bombs with the following backtrace:

      Member Dashboard

      backTrace

      #0 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
      #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
      #2 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #3 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #4 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #5 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "SELECT id, title, description, visibility, parents\n FROM civicrm_gro...", "DB_Error", TRUE)
      #6 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
      #7 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
      #8 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #9 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #10 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #11 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...")
      #12 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...", TRUE)
      #13 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Group.php(923): CRM_Core_DAO::executeQuery("SELECT id, title, description, visibility, parents\n FROM civicrm_gro...", (Array:1))
      #14 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/GroupContact.php(104): CRM_Contact_BAO_Group::getGroupsHierarchy("IN ()", NULL, "  ", TRUE)
      #15 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(349): CRM_Contact_Form_GroupContact->buildQuickForm()
      #16 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm()
      #17 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_GroupContact), "display")
      #18 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_GroupContact), "display")
      #19 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("display")
      #20 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/UserDashBoard/GroupContact.php(127): CRM_Core_Controller->run()
      #21 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/UserDashBoard/GroupContact.php(138): CRM_Contact_Page_View_UserDashBoard_GroupContact->edit()
      #22 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/UserDashBoard.php(192): CRM_Contact_Page_View_UserDashBoard_GroupContact->run()
      #23 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Page/View/UserDashBoard.php(208): CRM_Contact_Page_View_UserDashBoard->buildUserDashBoard()
      #24 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(292): CRM_Contact_Page_View_UserDashBoard->run((Array:2), NULL)
      #25 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:14))
      #26 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
      #27 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm.php(322): CRM_Core_Invoke::invoke((Array:2))
      #28 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm.php(426): civicrm_wp_invoke()
      #29 /home/pffco/public_html/wp-content/plugins/civicrm/civicrm.php(874): civicrm_wp_frontend(TRUE)
      #30 [internal function](): civicrm_shortcode_handler((Array:1), "", "civicrm")
      #31 /home/pffco/public_html/wp-includes/shortcodes.php(236): call_user_func("civicrm_shortcode_handler", (Array:1), "", "civicrm")
      #32 [internal function](): do_shortcode_tag((Array:7))
      #33 /home/pffco/public_html/wp-includes/shortcodes.php(151): preg_replace_callback("/[([?)(embed|wp_caption|caption|gallery|civicrm|contact_form|contact-form\...", "do_shortcode_tag", "[civicrm component=\"user-dashboard\"]\n")
      #34 [internal function](): do_shortcode("[civicrm component=\"user-dashboard\"]\n")
      #35 /home/pffco/public_html/wp-includes/plugin.php(173): call_user_func_array("do_shortcode", (Array:1))
      #36 /home/pffco/public_html/wp-includes/post-template.php(166): apply_filters("the_content", "[civicrm component=\"user-dashboard\"]")
      #37 /home/pffco/public_html/wp-content/themes/gconverter/page.php(42): the_content("Read more ›")
      #38 /home/pffco/public_html/wp-includes/template-loader.php(47): include("/home/pffco/public_html/wp-content/themes/gconverter/page.php")
      #39 /home/pffco/public_html/wp-blog-header.php(16): require_once("/home/pffco/public_html/wp-includes/template-loader.php")
      #40 /home/pffco/public_html/index.php(22): require("/home/pffco/public_html/wp-blog-header.php")
      #41

      {main}

      Sorry but we are not able to provide this at the moment.

      --------------------------------------------------------------------------------

      DB Error: syntax error

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              rjm Rob Malerman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: