CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions »
  • CiviVolunteer (Moderators: GinkgoFJG, Michael Z Daryabeygi) »
  • CiviVolunteer Install Fails With Error Related to Mysqli
Pages: [1]

Author Topic: CiviVolunteer Install Fails With Error Related to Mysqli  (Read 2506 times)

dwfriederichs

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 1
CiviVolunteer Install Fails With Error Related to Mysqli
November 23, 2013, 01:25:56 pm
I've downloaded CiviVolunteer on 4.4.2-Joomla.  When I try to install it, I get the following error:

Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php on line 182

Has anyone else experienced this?  Any ideas on the cause?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 23, 2013, 01:57:26 pm
Just tried it on a fresh install of J! 2.5 and it worked fine.
Can you enable backtrace?
Try asking your question on the new CiviCRM help site.

dwfriederichs

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 1
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 23, 2013, 08:33:05 pm
I found out that it's true of all extensions, not just CiviVolunteer, so something bigger is going on.

I've not used backtrace before.  Can you tell me how I would enable it?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 23, 2013, 09:45:16 pm
In the CiviCRM menu: Administer -> System Settings -> Debugging
Try asking your question on the new CiviCRM help site.

dwfriederichs

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 1
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 24, 2013, 09:00:32 am
Here's what I get from backtrace when I try to install CiviVolunteer:

backTrace

#0 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#4 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#5 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...", "DB_Error", TRUE)
#6 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1347 ** 'C168529_CareerEp17.civicrm_value_joomla_data_9' is not BASE TABLE")
#7 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#9 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#10 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#11 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...")
#12 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(905): CRM_Core_DAO->query("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...", FALSE)
#13 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1665): CRM_Core_DAO::executeQuery("CREATE TRIGGER civicrm_value_joomla_data_9_after_insert after insert ON civic...", (Array:0), TRUE, NULL, FALSE, FALSE)
#14 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1544): CRM_Core_DAO::createTriggers((Array:6))
#15 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(500): CRM_Core_DAO::triggerRebuild()
#16 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Extension/Manager.php(231): CRM_Core_Invoke::rebuildMenuAndCaches(TRUE)
#17 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/api/v3/Extension.php(191): CRM_Extension_Manager->install((Array:1))
#18 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/api/api.php(87): civicrm_api3_extension_download((Array:2))
#19 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Admin/Form/Extensions.php(206): civicrm_api("Extension", "download", (Array:2))
#20 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(261): CRM_Admin_Form_Extensions->postProcess()
#21 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#22 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next")
#23 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next")
#24 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next")
#25 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("next")
#26 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Page/Basic.php(381): CRM_Core_Controller->run()
#27 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Page/Basic.php(178): CRM_Core_Page_Basic->edit(2, NULL)
#28 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Admin/Page/Extensions.php(127): CRM_Core_Page_Basic->run()
#29 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#30 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#31 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#32 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:3))
#33 /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#34 /hsphere/local/home/c168529/careerep.net/libraries/joomla/application/component/helper.php(383): require_once("/hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm...")
#35 /hsphere/local/home/c168529/careerep.net/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm...")
#36 /hsphere/local/home/c168529/careerep.net/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#37 /hsphere/local/home/c168529/careerep.net/administrator/index.php(46): JAdministrator->dispatch()
#38 {main}
Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in /hsphere/local/home/c168529/careerep.net/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php on line 182

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 24, 2013, 09:47:28 am

seems like the civicrm database user (in your settings files) does not have trigger privileges. Recent versions of civi require trigger privileges

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

GinkgoFJG

  • Moderator
  • I post frequently
  • *****
  • Posts: 135
  • Karma: 4
    • Ginkgo Street Labs
Re: CiviVolunteer Install Fails With Error Related to Mysqli
November 24, 2013, 04:41:01 pm
Thought I'd chime in that the installer will not create the "register to volunteer" permission automatically for Joomla installations. As a result, the public sign-up form will not be accessible to most users.

This is a bigger issue, and does indeed affect all extensions. See CRM-12059.
Are you a CiviVolunteer user? Join the CiviVolunteer 2.0 Matching Grant effort to help the project win $15,000 in grant funding.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions »
  • CiviVolunteer (Moderators: GinkgoFJG, Michael Z Daryabeygi) »
  • CiviVolunteer Install Fails With Error Related to Mysqli

This forum was archived on 2017-11-26.