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
can you try rebuilding the index of your mysql ??
@mozzy for the suggestion, I followed
to rebuild the index, but mysql said that the table is OK.
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...
Do you want me to dump the database and import it again?
Or is there another suggestion?
@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
FTR that actually rebuilds the Lucene search index, rather than the indices in MySQL, but that is the step that’s needed here.
@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.