thymus3 wrote on Tuesday, June 05, 2012:
Installed v4.1.0 (10) with calendar turned off whilst testing and formatting reports for last month - all good
Now have turned on calendar and find only month view works correctly.
- Day view shows name of doctor at top only - no time slots
- Week view shows name of doctor and days/dates underneath - no time slots
Have upgraded to v4.1.0 (11) - no change
Please advise where to look
bradymiller wrote on Wednesday, June 06, 2012:
Hi,
How did you install 4.1.0 (10) ? (ie. did you install 4.1.0 and then run the patch via instructions at: http://www.open-emr.org/wiki/index.php/OpenEMR_Patches)
Also, ensure you remove the calendar cache by removing all files/directories within the following directory:
openemr/interface/main/calendar/modules/PostCalendar/pntemplates/compiled/
If still issues, then suggest looking through the php error log.
-brady
OpenEMR
thymus3 wrote on Wednesday, June 06, 2012:
Dear Brady,
Thank you for your reply.
I removed all the files from openemr/interface/main/calendar/modules/PostCalendar/pntemplates/compiled/ but this made no difference. However perhaps I missed this step when I upgraded to 4.1.0 (10) but I cannot remember.
I tried a fresh install of 4.1.0 and then upgraded to 4.1.0 (11). It worked perfectly. I then copied the database across and the fault appeared so the problem is in the sql data.
The site has been live for three days with 1 x doc entering data so I would prefer to fix the data rather than rekey all his work. Do you have an idea what table the problem is likely to be in and do you believe it is possible to manually fix with phpmyadmin?
Kind Regards
Michael Kelly
www.StBenedictsHealthCare.com
bradymiller wrote on Wednesday, June 06, 2012:
Hi Michael,
Couple things (ordered by way I would go about debugging):
(Also, ensure you have a back up)
1. Check the php error log
2. Check for corruption for of the mysql tables (via mysqlcheck command):
http://docs.moodle.org/22/en/How_to_check_your_database_for_corruption
3. Try out a previous database backup (for example, if have a backup from day before)
let us know how it goes,
-brady
OpenEMR
thymus3 wrote on Thursday, June 07, 2012:
Dear Brady,
1. The only entry in the php error log is Session site ID has been set to 'default’
2. # mysqlcheck -u openemr -p -auto-repair openemr reports all database tables as OK
3. Will try several backups and then report
Kind Regards
Michael
bradymiller wrote on Thursday, June 07, 2012:
Hi,
One other simple thing I should of mentioned is to remove all browser cookies (unlikely to help, but never know).
-brady
OpenEMR
thymus3 wrote on Thursday, June 07, 2012:
Dear Brady,
I decided to backup each table individually and copy from the problem site to the new install and test viewing the calendar after each table copy. As fate would have it the last table I copied over was globals as I had checked this several times through the global admin screen.
Unfortunately I had failed to recognize that the calendar ending hour had been set to 3AM instead of PM. When I activated the calendar some weeks after setting the times my mind missed the pattern and continued to do so until logical elimination finally made it stand out.
With the calendar ending hour being set to prior to starting hour the calendar operated correctly and did not display any hours - only days in the month view of course.
Kind Regards
Michael Kelly