UgandaEMR Reports Error at St. Benedict HC III in Jinja City

[Simon_Niwamanya]

Hello Team
I have tried to run various sql files to solve this error but all in vain.
Kindly help me out

[dbaluku]

@Simon_Niwamanya please run the script here Troubleshooting Report Tips - UgandaEMR User Manual in heidi or on mysql command and restart the computer

[Simon_Niwamanya]

Good afternoon @dbaluku
This cannot solve the error

[dbaluku]

@Simon_Niwamanya It might be that your reports module is not actually running. Signs that it is not runnning as expected include Start all modules every after a restart of the machine. If that is the case, it means no reports can run

[Simon_Niwamanya]

@dbaluku What can I do to make them run?
Thank you…

[nmayanja]

@Simon_Niwamanya Kindly share your server logs so that we can look at the cause of this error.

Ensure read and implement number 5 in this post

Don't forget this as you post

To quicken the process of getting support, kindly have this in mind. First search through the topics available before you make a new post. What you are looking for might have been answered already. Provide the version of UgandaEMR, this is found on the login page Providing a screenshot is desired In case you have to share server logs, copy them into a text file (.txt) and upload Ensure your server logs are precise. You can do this by stopping Tomcat, delete all the server logs, start Tomcat, a…

[Simon_Niwamanya]

Thank you so much @dbaluku for the support.
This was solved by running the following SQL script: ALTER TABLE serialized_object CONVERT TO CHARACTER SET UTF8;