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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • "CiviCRM 4.3.1 requires MySQL trigger privileges." error
Pages: [1]

Author Topic: "CiviCRM 4.3.1 requires MySQL trigger privileges." error  (Read 2031 times)

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
"CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 06:32:50 am
Good morning,

We're attempting to upgrade our existing Wordpress installation of CiviCRM to 4.3.1 (PHP5.3.22 and MySQL5.1.68-cll), and we're running into the following error:

Sorry but we are not able to provide this at the moment.
CiviCRM 4.3.1 requires MySQL trigger privileges.

This page comes up when I go to run the upgrade script (step 4 in these instructions: http://wiki.civicrm.org/confluence/display/CRMDOC43/Upgrade+WordPress+Sites+to+4.3).

I've upgraded three sites so far and I've only gotten this error on two of the three. The third upgraded with no issues at all.

Help greatly appreciated. Thanks.

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: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 06:51:03 am

are all 3 sites on the same server using the same mysql server with the same DB user name / password / permissions?

seems like from the error, this is not the case

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

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 06:54:21 am
Quote from: Donald Lobo on April 22, 2013, 06:51:03 am

are all 3 sites on the same server using the same mysql server with the same DB user name / password / permissions?

seems like from the error, this is not the case

lobo

Yes, all three sites are using the same versions of PHP and MySQL.

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: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 07:06:05 am

but are they on the same physical server and are they using the same instance of mysql

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

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 07:18:17 am
Quote from: Donald Lobo on April 22, 2013, 07:06:05 am

but are they on the same physical server and are they using the same instance of mysql

lobo

As far I know, yes - same physical server, same instance.

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: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 09:07:43 am

that wierd if it is on the same instance. sorry, dont know what can cause this

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

Gorentz

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.7
  • CMS version: WordPress
  • MySQL version: 5.5.21
  • PHP version: 5.3.10
Re: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 22, 2013, 11:08:11 pm
I'm getting this same error tonight when upgrading a site from 4.2.7 to 4.3.1.   I have other sites on the same server, but haven't  tried them yet.   My database user has trigger privilege.  My php, mysql versions all are well past the minimum required version number. 

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: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 23, 2013, 06:55:00 am

might want to debug the code @

CRM_Core_DAO::checkTriggerViewPermission

and see what part is failing and the error messages that mysql spits out

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

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 23, 2013, 07:25:54 am
Quote from: Donald Lobo on April 23, 2013, 06:55:00 am

might want to debug the code @

CRM_Core_DAO::checkTriggerViewPermission

and see what part is failing and the error messages that mysql spits out

lobo

What are the specific steps to doing this? Sorry, the coding is not strong with this one. Is it through MySQL or something in Civi?

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: "CiviCRM 4.3.1 requires MySQL trigger privileges." error
April 23, 2013, 09:38:23 am
I downgraded one of the sites back down to 4.2.9. Attempted to downgrade to 4.3, but I received the same trigger error. 4.2.9 seems to have installed correctly.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • "CiviCRM 4.3.1 requires MySQL trigger privileges." error

This forum was archived on 2017-11-26.