Details
- 
    Type:Bug 
- 
    Status: Done/Fixed
- 
    Priority:Critical 
- 
    Resolution: Fixed/Completed
- 
    Affects Version/s: 4.6, 4.7
- 
    Fix Version/s: 4.7.21
- 
    Component/s: Core CiviCRM, NYSS
- 
    Labels:
- 
        Versioning Impact:Patch (backwards-compatible bug fixes)
- 
        Documentation Required?:None
- 
        Funding Source:Core Team Contract
Description
A fatal error happens in the CRM-Core_InnoDBIndexer class when the CiviCRM database user is not super-privileged (ie. just a regular user with all privileges on the database itself).
debug_info:
      SELECT i.name as index_name
      FROM information_schema.innodb_sys_tables t
      JOIN information_schema.innodb_sys_indexes i USING (table_id)
      WHERE t.name = concat(database(),'/civicrm_address')
      AND i.name like 'civicrm_fts_%'
      [nativecode=1227 ** Access denied; you need (at least one of) the PROCESS privilege(s) for this operation]
I do not know if this is really critical as I have never seen the message on screen, so maybe it is triggered during a cronjob and never shown to a real user.
But still, we should at minimum trap this error if not redesign the mechanism of getting FTS indexes another way (maybe a SHOW CREATE or other unprivileged statement).
Assigning to Tim since he is the creator of this file.
Attachments
Issue Links
- links to