Answers.Body: <p>We had similar problem this before and had to manually run mysql commands to fix the indices. This <a href="https://civicrm.stackexchange.com/questions/18739/problem-fixing-missing-indexes-after-upgrade-to-4-7">link</a> might be useful to solve the problem.</p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-26T16:35:14.287Z
Answers.LastActivityDate: 2018-06-26T16:35:14.287Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>With successful update from 4.7.25 to 4.7.29 there is a <strong>Performance warning: Missing Indices</strong> in CiviCRM System Status. When I click the <em>Update Indices</em> button, the error appears </p>
  
  <p><code>Operation failed: Update Indices
  DB Error: unknown error</code></p>
  
  <p>Enabling debug mode does not provide any additional info.</p>
  
  <p><a href="https://i.sstatic.net/xLom4.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xLom4.png" alt="Operation failed: Update Indices"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-27T08:31:14.300Z
Comments.Text: Just wondering why you are only upgrading to 4.7.29 ?  There are lots of fixes since then in later versions.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-28T15:44:54.210Z
Comments.Text: @Aidan, I was trying to do step by step upgrade, because upgrading to 4.7.30 (or later) got me into these problems: https://civicrm.stackexchange.com/questions/25098/db-error-after-upgrading-4-7-x-to-5-1-drupal
Comments.UserDisplayName: Aivars
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-06-28T16:28:48.960Z
Comments.Text: Ok, that makes sense if 4.7.29 is an intermediate step.  However, you can leave the Update Indices thing - that changed several times in releases around that time.  It was a warning that indices were less than optimal but is not an error.  When you eventually get to current versions you can fix it then if the warning still shows.
Comments.UserDisplayName: Aidan
Tags: <issues><upgrade><indices>
Title: Update Indices fails on 4.7.29
ThreadText: # Update Indices fails on 4.7.29
  
  (Asked by: username_0 on 2018-06-26)
  
  With successful update from 4.7.25 to 4.7.29 there is a **Performance warning: Missing Indices** in CiviCRM System Status. When I click the *Update Indices* button, the error appears
  
  `Operation failed: Update Indices
  DB Error: unknown error`
  
  Enabling debug mode does not provide any additional info.
  
  [![Operation failed: Update Indices](https://i.sstatic.net/xLom4.png)](https://i.sstatic.net/xLom4.png)
  
  **Tags:** issues, upgrade, indices
  
  > **Comments:**
  > **username_1**: Just wondering why you are only upgrading to 4.7.29 ?  There are lots of fixes since then in later versions.  
  > **username_0**: @username_1, I was trying to do step by step upgrade, because upgrading to 4.7.30 (or later) got me into these problems: https://civicrm.stackexchange.com/questions/25098/db-error-after-upgrading-4-7-x-to-5-1-drupal  
  > **username_1**: Ok, that makes sense if 4.7.29 is an intermediate step.  However, you can leave the Update Indices thing - that changed several times in releases around that time.  It was a warning that indices were less than optimal but is not an error.  When you eventually get to current versions you can fix it then if the warning still shows.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-06-26. Score: 1
  
  We had similar problem this before and had to manually run mysql commands to fix the indices. This [link](https://civicrm.stackexchange.com/questions/18739/problem-fixing-missing-indexes-after-upgrade-to-4-7) might be useful to solve the problem.
  
  HTH
  
  username_2
  
  
  ---
  
  