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) »
  • Multilingual system
Pages: [1]

Author Topic: Multilingual system  (Read 3580 times)

amigosespana

  • Guest
Multilingual system
July 07, 2009, 09:25:44 am
Hello

In the config of localisation it tells me at the end , about multilingual:

In order to use this functionality, the installation's database user must have privileges to create triggers (in MySQL 5.0 this means the SUPER privilege). This install does not seem to have the required privilege enabled.

What am I supose to do?

Triggers is activated in Drupal and still nothing

Sorry if this sounds stupid, but i just geting in Drupal and traight with Civicrm

Regrds to all

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: Multilingual system
July 07, 2009, 11:59:33 am

your database user needs to have trigger privileges. If you are seeing that message, it means the database user does not have trigger privileges

this has nothing to do with the trigger module in drupal

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

amigosespana

  • Guest
Re: Multilingual system
July 08, 2009, 06:17:00 am
Thanks Lobo,

I checked my user privilege list in Mysql and it looks kike trigger is not in the list even if all privileges are turned on. 

I will check that out unless you have an answar to this.

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: Multilingual system
July 08, 2009, 10:15:40 am

in mysql 5.0 and under you need to be a SUPER user to get the trigger privilege

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

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Multilingual system
August 14, 2009, 01:30:37 am
To clarify a bit, in case someone else finds this thread: multilingual functionality needs the ability to create triggers. In MySQL 5.0 this means that the MySQL user needs to have the SUPER privilege; in MySQL 5.1 there is a separate TRIGGER privilege for this.

In general, if you’re on a shared hosting, there’s little chance that the hosting provider will give you the SUPER privilege; still, there’s a chance they upgrade to MySQL 5.1, and then the TRIGGER privilege will be enough.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

manilodisan

  • Guest
Re: Multilingual system
August 21, 2009, 01:02:58 pm
The only host I found so far to support mysql triggers on shared packages is at placehost.net. I hope more will come. This is probably because hosting providers wait for plesk or cpanel to support such versions of PHP/MySql and those two are moving slower than anything else. PHP 5.2.9 came out recently and a lot of bugs were fixed yet nor cpanel or plesk supports this version.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Multilingual system

This forum was archived on 2017-11-26.