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) »
  • MySQL Triggers and binary logging
Pages: [1]

Author Topic: MySQL Triggers and binary logging  (Read 1547 times)

felixmartel

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 0
  • CiviCRM version: 3.4.7
  • CMS version: Drupal 6.31
  • MySQL version: 5.1.54
  • PHP version: 5.3.5
MySQL Triggers and binary logging
March 09, 2011, 11:45:44 am
Hello,

I'm building a Drupal/Civi site for my non-profit organization. We can't afford VPS or dedicated hosting. I'm relatively new to Drupal and CiviCRM, so my knowledge and understanding of localization is limited. We need our site to function primarily in French, but we'd like it to be bilingual (French/English). I've got Civicrm up and running (installed with primary files in French). Aside from the error about not being able to extend the schema without super priveledges or binary logging turned off, I've also got a mix of French and English in the civicrm administration and configuration pages. I haven't really started configuring anything yet. I'm afraid of what my forms will look like !

Is there any way to work around these issues? I'm just about ready to call it quits and move to Ubercart...

abarenbe

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal7
  • MySQL version: Mysql 5.1
  • PHP version: 5.2
Re: MySQL Triggers and binary logging
June 24, 2011, 12:30:38 pm
Hello, I wanted to bump this question up.  I'm in near identical situation - except we have been using Civic/Drupal for about two years now. We want to allow our partner organization in West Africa access CivicCase in French while we continue to use CIvic in english.  I have the message about Super privledges and logging enabled. Is there some way to to turn logging off? Or grant super privileges?  Any support pages to walk through the setup for mulitlingual setup?

Thank You
Andy

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: MySQL Triggers and binary logging
June 25, 2011, 01:59:23 am
Hi,

In any case, you need some extra  privilege to have triggers. In mysql 5.1, you only need to give trigger privilege, not super (that was the only option on 5.0).

Try to grant that privilege to the user, it should get rid of the error message.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • MySQL Triggers and binary logging

This forum was archived on 2017-11-26.