Openemr 5.0.1 calendar has become very slow in the last two days

Day-to-Day Users
#22

Hi @vambati,

Another option is to copy your current instance into a testing instance and play around on that. I am curious what would happen if you then dropped all the appt in the openemr_postcalendar_events sql table on the testing instance (I am taking a wild guess that there is a rogue/corrupt recurrent appt in there).

-brady

#23

@brady.miller I am trying to reproduce the slowness in my calendar. We notice that the first column is showing the appointments as half. as you can see from the screenshot. All the other columns are fine, it is only the first column.

image.png1920×1080 117 KB

#24

Since I updated/upgraded to 5.0.1 I experience the same: The appointments in the leftmost column get scrambled. I do not see any system in the transverse displacement op the appointments. Furthermore the blue marking extends over the left side of the field covering the time field partially.

#25

Hi,

Wow, that is a mess. Looks like there is definitely a bug going on since being reported by 2 folks so far. Quick question:

  1. Is it really slow like @vambati has reported?
  2. Does it get better if do Administration->Other->Calendar->Clear Smarty Cache

-brady

#26

Also, I should of mentioned to also ensure clear browser cache/cookies.

#27

I do not feel any speed impediment only the transverse rearrangement of the appointments.
I have tried both now.
Neither clearing the smarty cache nor clearing browser cache made any visible difference.
Thks Morten

#28

@mborchorst,

Here’s a fix by epsdky that will hopefully fix this(the pertinent changes are in the interface/themes/ajax_calendar.css script - let us know if the changes in that script fix your issues):

-brady

#29

Thks. Is there at place to find a quick reading about how to implement the fix in my running system?

#30

Hi,

Just make the two changes noted here (interface/themes/ajax_calendar.css with 2 changes within the #times class) and then clear your browser cookies/cache:

-brady

Calendar needs fixing (see pic)
#31

To clarify, link above is:
https://github.com/openemr/openemr/pull/896/files#diff-83fe5c46797fbd5336dacaad984d86f6

#32

Changing those two files definitely made it better. The first column is still pretty scrambled, though

Skærmbillede_2017-07-04_12-35-18.png323×698 23.8 KB

#33

@Vambati, Did changing the 2 files solve the scrambling of appointments in the leftmost column for you?

#34

Hi ,

I have not been able to reproduce the scrambling of appointments. Are they all correctly mapped to the provider of column 1?

-brady

#35

They were originally (before the upgrade to 5.0.0). Is there any way I can check if they are?

#36

Hi @mborchorst ,

@epsdky contributed a fix for the scrambled column. Let me know if this fixes your issues:
calendar bug fix 2 · openemr/openemr@9b6f56d · GitHub

-brady

Calendar needs fixing (see pic)
V5.0.1(6) slow patient load times on Windows Server
#37

Heureka. Many thanks

Skærmbillede_2017-07-11_10-53-47.png541×509 77.5 KB

/Morten Borchorst

1 Like
#38

I just made a fresh install on my backup machine; version 5.0.0, patch 5. It seems that the abovementioned fix is not part of patch 5 … Is that true? I see the problems back on my backup server :frowning:

#39

@mborchorst,
Yes, its true.
These fixes are not part of the patch 5.

Thanks,
ViSolve

#40

Hi,

They are in a queue for a non-urgent patch, however, have had several critical patches that have taken up the patching resources (ie. my time :slight_smile: ). Hopefully will get out the non-urgent patch over the next couple weeks.

-brady

#41

NP, no urgency from my point of view. I was just curious about if I had understood the patching procedures right.
/Morten