Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.0
-
Fix Version/s: 4.3.0
-
Component/s: CiviContribute, CiviEvent, CiviMember, Core CiviCRM
-
Labels:
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
Sorry but we are not able to provide this at the moment.
--------------------------------------------------------------------------------
DB Error: syntax error