Linked Questions
13 questions linked to/from How to find and/or fix missing indices?
1
vote
2answers
38 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-...
0
votes
2answers
205 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 ...
2
votes
0answers
66 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 ...
1
vote
0answers
50 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 ...
5
votes
2answers
695 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
...
4
votes
1answer
41 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 ...
5
votes
1answer
707 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, ...
1
vote
1answer
85 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 ...
2
votes
2answers
76 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
362 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
314 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: "...
3
votes
1answer
172 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. ...
6
votes
5answers
325 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 ...