hany
(Hany Eskander)
February 3, 2020, 12:37am
1
Platform
2.2.0:
Question:
I installed platform 2.2.0
then added the legacyui module
then imported the large-demo-data-2-2-1.sql
I can query the demo data using mysql workbench, all the +5000 patients records are there
but the patient form does not show any one, except the newly added ones
the same happens when I took the following steps:
creating the database
importing the large demo set
Installing the platform
adding the legacyui module
please clarify
mozzy
(Moses Mutesasira)
February 3, 2020, 6:12am
2
can you try rebuilding the index of your mysql ??
1 Like
hany
(Hany Eskander)
February 3, 2020, 1:30pm
3
Thank you @mozzy for the suggestion, I followed
When a system error happens to a mySql database, or when a table simple receives a large amount of incorrectly formatted data, the table indexes may become corrupt. The mySql system will inform a user that the table needs to be repaired when a CHECK...
to rebuild the index, but mysql said that the table is OK.
Do you want me to dump the database and import it again?
Or is there another suggestion?
mozzy
(Moses Mutesasira)
February 3, 2020, 1:41pm
4
@hany , we alredy implemented that functionality in OpenMRS , you can go to the Administration -> Maintenance -> Search Index on Legacy ui , and simply do a click , to rebuild the index of the entire DB.
after there try again ,and we see
1 Like
ibacher
(Ian Bacher)
February 3, 2020, 1:54pm
5
FTR that actually rebuilds the Lucene search index, rather than the indices in MySQL, but that is the step that’s needed here.
2 Likes
hany
(Hany Eskander)
February 3, 2020, 2:02pm
6
@mozzy that did the trick, thank you so much
@ibacher thank you for showing the difference between these indices
Thank you guys for the great support.
1 Like