Multilingual system

[amigosespana]

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]

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

[amigosespana]

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]

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

lobo

[Piotr Szotkowski]

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.

[manilodisan]

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.