I get error after running a report in KenyaEMR

If you run a report and it throws an error then check the following;

• Clear report queue by running the following scripts;

Log into mysql using the terminal; mysql –uroot –p (Enter)  then enter password when prompted

delete from reporting_report_request; (Enter)

Exit (Enter)

Restart MySQL by typing  sudo service mysql restart (Enter)

Re-run the report