CiviCRM Community Forums (archive)

For this feature, we did make a conscious decision to use triggers. Helped get this into production much sooner. We plan on using more trigger related code in 2.2 (for civicase) and later. so searching for a host that gives u these privileges might be useful for the future

lobo

The general reasoning is the following:

1. Doing what the multi-language MySQL triggers do on the PHP side would be tons of work resulting in complicated and very hard to maintain code.
2. MySQL 5.1, which is in release candidate stage now, will have separate trigger privileges and so you won’t need the SUPER privilege for CiviCRM any more.

The response I received from my hosting (shared) is that they don't and do not plan to allow triggers. My current MySQL version is 5.0.45.

Well, it means they’re a decent shared hosting – they would be really irresponsible if they gave the SUPER privilege to any of their clients, and CREATE TRIGGER privilege is currently in a not-yet-stable version of MySQL (and it would be irresponsible to deploy it).

1. Can I do a multi-site installation - one in English and one in French, sharing the same database?

You can try, but I can’t envision doing it easily – and it depends on what you want internationalised. We have plans for/coded something towards making this easier in 2.2, though (multiple CMS instances sharing the same CiviCRM database).

2. Feel free to recommend a hosting company that I could look up.

Unfortunately, our current recommendation for multilingual sites is to host it yourself (you can do that on a shared virtual server, of course). Due to the MySQL 5.0 requiring the SUPER privilege to create triggers we can’t really recommend anything else until MySQL 5.1 stable comes out.