Linked Questions

5
votes
1answer
675 views

4.7.20 upgrade — missing indices warning, but index already exists? [duplicate]

Upgraded to 4.7.20 today. As others on this thread have experienced in earlier release(s), I promptly got the "missing indices on some tables" warning. Of course, I tried the "Update Indices" button, ...
2
votes
0answers
65 views

CiviCRM Update 4.7.27 Operation failed: Update Indices Errno: 150 [duplicate]

I updated my CiviCRM version to 4.7.27 yesterday and got a Performance warning on my system status page that there are some Missing indices. Clicking the 'Update Indices' button doesn't fix the ...
5
votes
2answers
643 views

Problem fixing missing indexes after upgrade to 4.7

When I run cv ev 'print_r(CRM_Core_BAO_SchemaHandler::getMissingIndices())' I get the following output: Array ( [civicrm_case_contact] => Array ( [0] => Array ...
6
votes
5answers
304 views

Events 'missing' after upgrade to 4.7.19

On a civi 4.7.19 / joomla 3.70 installation I have problems accessing events after the 4.7.19 ugrade (events worked OK on 4.7.18/3.7.0). I have current events displaying on the front page via the ...
3
votes
1answer
325 views

How can I fix this problem with duplicate index in 4.7.21?

Upgraded from 4.7.17 to 4.7.21 and got the following message that I don't know how to fix. I don't have drush and the other answers to this problem don't include this index or don't fix this ...
2
votes
1answer
300 views

Update 4.7.22 : Operation failed: Update Indices DB Error: already exists

I'm just update to civicrm 4.7.22 on Drupal 7.56. After the update, I received a system status warning "Performance warning: Missing indices". I click to Update Indices and have these error: "...
2
votes
2answers
73 views

Thank-you Sent same as Recieved Date

I'm hoping someone can help me with this issue I'm having. All contributions on the Dashboard and Find Contributions screen have the exact same date and time for the Received date and Thank-you Sent ...
3
votes
1answer
167 views

Missing indices error followed by missing system status page

Trying to implement the solution that worked when I got the missing indices error after the 4.7.20 update, but can't hit the Update button because System Status page isn't populating with anything. ...
0
votes
2answers
201 views

Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8

I successfully upgraded to CiviCRM 4.7.21 (from 4.7.17), and everything seems to be working properly. However, I got a critical status error, "Performance warning: Missing indices". After reading How ...
4
votes
1answer
39 views

My Summary Overlays are bad after upgrading to 4.7

On two separate sites that were upgraded to 4.7, the "Summary Overlay" function seems to have been uglified. Specifically - in the past, when hovering over the person icon on the left of many contact ...
1
vote
1answer
77 views

Where can I see the database upgrade script?

I want to see which indices were supposed to be created in the last upgrade I ran because I get a status report message saying that some indices are missing, but when I click "Update Indices" I get an ...
1
vote
0answers
48 views

Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices. The table that fails is civicrm_case_contact, with the old index UI_case_contact_id. The error is identical to ...
1
vote
2answers
37 views

Errors only randomly on admin pages

I'm getting randomly the errors below when I go to an admin page. They don't always happen. Any idea what this is? Warning: Invalid argument supplied for foreach() in /home/sporti62/public_html/wp-...