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 »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Super Privileges Problem
Pages: [1]

Author Topic: Super Privileges Problem  (Read 1596 times)

FredJones

  • Guest
Super Privileges Problem
April 30, 2010, 08:02:27 am
My host said that they don't provide SUPER privileges but that they could run the query to create triggers for me.

Is this possible? Is it possible to obtain the queries necessary so that they could run them manually?

Thank you.

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Super Privileges Problem
April 30, 2010, 08:26:45 am
In MySQL 5.1, they can grant only the "trigger" privileges (this is new to 5.1).

Running the queries manually is a bit risky. Every time you will want to change a custom field, it will need to add new triggers.
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

FredJones

  • Guest
Re: Super Privileges Problem
May 01, 2010, 02:22:37 pm
Quote from: mlutfy on April 30, 2010, 08:26:45 am
In MySQL 5.1, they can grant only the "trigger" privileges (this is new to 5.1).

Host has 5.0. :(

Quote from: mlutfy on April 30, 2010, 08:26:45 am
Running the queries manually is a bit risky. Every time you will want to change a custom field, it will need to add new triggers.

Dat's what I figured.

OK, thanks.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Super Privileges Problem

This forum was archived on 2017-11-26.