Answers.Body: <p>This is related to a general issue with updating CiviCRM under Joomla in a non-US environment, where the views are not updating correctly.  The error was only flagged up when I tried to create an event.  This pointed me to the log file that then showed what the issue was.</p>
  
  <p>I solved the issue by adding the following lines to the definition of, in our case, the view civicrm_uf_group_en_GB:</p>
  
  <pre><code>   `civicrm_uf_group`.`frontend_title_en_GB` AS `frontend_title`,
      `civicrm_uf_group`.`cancel_button_text_en_GB` AS `cancel_button_text`,
      `civicrm_uf_group`.`submit_button_text_en_GB` AS `submit_button_text`
  </code></pre>
  
  <p>It seems that the update process isn't applying that change.  My knowledge of the update process isn't sufficient to work out how to do it automatically.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-19T19:50:01.763Z
Answers.Text: Are you certain this is Joomla related rather than multilingual related?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-22T11:03:15.400Z
Answers.Text: You are probably right - it is multilingual related, but it may have manifested itself in Joomla rather than Drupal (or maybe it is because I was upgrading from a much older system in Drupal).  In general, I have seen a number of issues in the views after upgrading to a new version of CiviCRM which have required manual intervention.
Answers.UserDisplayName: Stephen Palmstrom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-19T08:35:02.453Z
Answers.LastActivityDate: 2018-06-19T08:35:02.453Z
Answers.UserDisplayName: Stephen Palmstrom
Body: <p>Selecting Events -> Find Participants under CiviCRM 5.1.2, Joomla 3.8.8, PHP 7.2.5 under IIS displays the event ID and not event name in the Event Name field.  This is a bug introduced after 4.7.31.  It may be relevant, but the CiviCRM menu drop downs also disappear.</p>
  
  <p>4.7.31:</p>
  
  <p><a href="https://i.sstatic.net/zcdd4.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/zcdd4.jpg" alt="enter image description here"></a></p>
  
  <p>5.1.2:</p>
  
  <p><a href="https://i.sstatic.net/8YM4j.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8YM4j.jpg" alt="enter image description here"></a></p>
  
  <p>I've tried looking at what has changed, but the obvious files aren't showing any such changes.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-03T08:11:14.313Z
Comments.Text: Strange, I cleared the caches and everything under ../media/civicrm/templates_c except the directory en_GB, but to no avail.  I even reset the custom paths to eliminate custom code.  Are you sure it was on a Joomla instance that you tested it?
Comments.UserDisplayName: Stephen Palmstrom
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-14T08:20:31.677Z
Comments.Text: Has anyone tried the update under Joomla?  I updated a local Drupal installation and the problem doesn't appear.  Is that why @PradeepNayak couldn't reproduce the problem?  Is Joomla still supported, or should we move our CiviCRM environment to Drupal?
Comments.UserDisplayName: Stephen Palmstrom
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-22T20:11:03.193Z
Comments.Text: I couldn't replicate the issue on 5.1.2. Could try after deleting template_c and also clear CiviCRM cache
Comments.UserDisplayName: Pradeep Nayak
Tags: <civievent>
Title: Event -> Find Participants displays event id, not event name in event name field
ThreadText: # Event -> Find Participants displays event id, not event name in event name field
  
  (Asked by: username_0 on 2018-05-22)
  
  Selecting Events -> Find Participants under CiviCRM 5.1.2, Joomla 3.8.8, PHP 7.2.5 under IIS displays the event ID and not event name in the Event Name field. This is a bug introduced after 4.7.31. It may be relevant, but the CiviCRM menu drop downs also disappear.
  
  4.7.31:
  
  [![enter image description here](https://i.sstatic.net/zcdd4.jpg)](https://i.sstatic.net/zcdd4.jpg)
  
  5.1.2:
  
  [![enter image description here](https://i.sstatic.net/8YM4j.jpg)](https://i.sstatic.net/8YM4j.jpg)
  
  I've tried looking at what has changed, but the obvious files aren't showing any such changes.
  
  **Tags:** civievent
  
  > **Comments:**
  > **username_1**: I couldn't replicate the issue on 5.1.2. Could try after deleting template_c and also clear CiviCRM cache  
  > **username_0**: Strange, I cleared the caches and everything under ../media/civicrm/templates_c except the directory en_GB, but to no avail.  I even reset the custom paths to eliminate custom code.  Are you sure it was on a Joomla instance that you tested it?  
  > **username_0**: Has anyone tried the update under Joomla?  I updated a local Drupal installation and the problem doesn't appear.  Is that why @PradeepNayak couldn't reproduce the problem?  Is Joomla still supported, or should we move our CiviCRM environment to Drupal?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2018-06-19. Score: 1
  
  This is related to a general issue with updating CiviCRM under Joomla in a non-US environment, where the views are not updating correctly.  The error was only flagged up when I tried to create an event.  This pointed me to the log file that then showed what the issue was.
  I solved the issue by adding the following lines to the definition of, in our case, the view civicrm_uf_group_en_GB:
     `civicrm_uf_group`.`frontend_title_en_GB` AS `frontend_title`,
      `civicrm_uf_group`.`cancel_button_text_en_GB` AS `cancel_button_text`,
      `civicrm_uf_group`.`submit_button_text_en_GB` AS `submit_button_text`
  
  It seems that the update process isn't applying that change.  My knowledge of the update process isn't sufficient to work out how to do it automatically.
  
  > **Comments:**
  > **username_2**: Are you certain this is Joomla related rather than multilingual related?  
  > **username_0**: You are probably right - it is multilingual related, but it may have manifested itself in Joomla rather than Drupal (or maybe it is because I was upgrading from a much older system in Drupal).  In general, I have seen a number of issues in the views after upgrading to a new version of CiviCRM which have required manual intervention.  
  
  ---
  
  