CiviCRM Community Forums (archive)

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.

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.

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.

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. 

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?