Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-9746

Unable to switch demo sites back to English.

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.2
    • Labels:
      None

      Description

      There are problems on the demo sites with regard to language switching that have been preventing them from being put back to English.

      I am unsure of the details but since 4.1 is out it is not possible to switch back to English from other languages. Note that the demo sites - Drupal and Joomla at least - are not in multi-language mode, but there is an error where it appears the db have at some point been put into multi-language mode since the table names in the error message about running out of memory have the locale at their end. See a pastebin message in irc from me last Friday that dgg responded to.

      On WordPress demo site just now trying to enable English in addition to Italian, before turning off Italian, led to a permissions error (see below). This permissions error - different than previous memory alloc errors - may be related to changes in 4.1 or very possible to changes in MySQL version or config if we have changed demo server.
      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -26
      [message] => DB Error: insufficient permissions
      [mode] => 16
      [debug_info] => CREATE TRIGGER civicrm_location_type_before_update BEFORE UPDATE ON civicrm_location_type FOR EACH ROW BEGIN IF NEW.display_name_en_US IS NOT NULL THEN IF NEW.display_name_it_IT IS NULL THEN SET NEW.display_name_it_IT = NEW.display_name_en_US; END IF; ELSEIF NEW.display_name_it_IT IS NOT NULL THEN IF NEW.display_name_en_US IS NULL THEN SET NEW.display_name_en_US = NEW.display_name_it_IT; END IF; END IF; END [nativecode=1142 ** TRIGGER command denied to user 'drupal'@'localhost' for table 'civicrm_location_type']
      [type] => DB_Error
      [user_info] => CREATE TRIGGER civicrm_location_type_before_update BEFORE UPDATE ON civicrm_location_type FOR EACH ROW BEGIN IF NEW.display_name_en_US IS NOT NULL THEN IF NEW.display_name_it_IT IS NULL THEN SET NEW.display_name_it_IT = NEW.display_name_en_US; END IF; ELSEIF NEW.display_name_it_IT IS NOT NULL THEN IF NEW.display_name_en_US IS NULL THEN SET NEW.display_name_en_US = NEW.display_name_it_IT; END IF; END IF; END [nativecode=1142 ** TRIGGER command denied to user 'drupal'@'localhost' for table 'civicrm_location_type']
      [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_location_type_before_update BEFORE UPDATE ON civicrm_location_type FOR EACH ROW BEGIN IF NEW.display_name_en_US IS NOT NULL THEN IF NEW.display_name_it_IT IS NULL THEN SET NEW.display_name_it_IT = NEW.display_name_en_US; END IF; ELSEIF NEW.display_name_it_IT IS NOT NULL THEN IF NEW.display_name_en_US IS NULL THEN SET NEW.display_name_en_US = NEW.display_name_it_IT; END IF; END IF; END [nativecode=1142 ** TRIGGER command denied to user 'drupal'@'localhost' for table 'civicrm_location_type']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              deepak Deepak Srivastava
              Reporter:
              joemurray Joe Murray
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: