Renaming Attachments, browser hang/crash


(Richard Torres) #1

Situation
When a file is attached to a patient record and the doctor wants to go in and rename the attachment the option to rename is there but after clicking the Update (Submit) link the page does nothing and will eventually hang and openemr no longer works. You close browsers and reload and no changes have been made and system is fine. This happens on Chrome, Firefox and Internet Explorer

OpenEMR Version
v5.0.1 (4)

Browser:
I’m using:
Chrome Version 77.0.3865.90 (Official Build) (64bit)
Fire Fox version 69.0.2 (64bit)
Internet Explorer version 11.388

Operating System
I’m using: Windows 10 1903

Logs
Did you check the logs? Was there anything pertinent in them? Paste them here (surround with three backticks (```) for readability


(Stephen Waite) #2

hi @richbcph, can’t reproduce on development, 5.0.3, on 5.0.2 having trouble uploading any type of document, pdf or txt so far at https://seven.openemr.io/f/openemr/interface/login/login.php?site=default

may just be a security setting for the demos though but then 5.0.3 shouldn’t work


(Richard Torres) #3

Thanks for following up. No we can upload seemingly everything like Office 2016 formats, PDF, Bat, Txt, Image formats …). I will try to update to 5.0.3 and see if that resolves the issue and report back.

Thanks


(Stephen Waite) #4

Hi @richbcph, it’s safer to stick with 5.0.2 since it’s the production release vs 5.0.3, development. We can file a bug report for the issue on 5.0.2 and follow up.


(Richard Torres) #5

Just spent the better part of 2 hours trying to upgrade php… grrr. When replacing the php with 7.1.32 trying to upgrade to 5.0.2 the system will not load apache service anymore. Running Xampp is there any articles explaining how to upgrade php inside xampp? Using the xampp package for openemr?


(Stephen Waite) #6

haven’t used in a while, but since the newest xampp uses mariadb you might want to wait until patch 1 comes out to fix a bug

ps it’s going to be any day now after Brady can figure out how to pull over 100 files into it :slight_smile:
https://www.open-emr.org/wiki/index.php/Ongoing_5.0.2_Patch_Trail


(Richard Torres) #7

So is it being recommended that I wait until the patch is released and see if it resolves my issues without the upgrade?


(Stephen Waite) #8

Hi @richbcph, patch has been released so feel free to give it another shot


(Richard Torres) #9

Good morning,

Thanks for the link. Will this patch require me to upgrade PHP? When trying to run the upgrade for 5.0.2 the database portion states I must be on php 7.1 and won’t continue further.

Thanks


(Stephen Waite) #10

yes, upgrade php, think you need to download a new bundled xampp and move the database in like you move the codebase in per the instructions, see step 2 of downloading package https://www.open-emr.org/wiki/index.php/OpenEMR_5.0.2_Windows_Installation


(Richard Torres) #11

Based on this information would it be better to just rebuild or wait for the new xampp package? I enjoy the ease of use with the package but it seems like php is problematic when trying to upgrade?

Windows: Pre-installed OpenEMR with the XAMPP Package
Windows/Xampp OpenEMR 5.0.2 package is currently under construction.


(Stephen Waite) #12

package may not be built any time soon, have you tried docker for windows?


(Brady Miller) #13

Hi,

Now that patch/updated packages are out, xampp package is next on my list (it’s high priority since the concern is windows users will not properly secure their documents directory via apache even though the setup provides guidance on this). That being said, I hit some snags on this package previously, so could be out anywhere from a couple days to couple weeks depending on how smooth the build process goes. It’s currently at item 2 on my STAT todo list :slight_smile:
https://www.bradymd.com/todo/

-brady


Windows to Linux migration
(Richard Torres) #14

Brady,
Thanks for doing that. While this bug is not a show stopper I’m inclined to wait for the new package release and see if this resolves it. That said has anyone ever documented the upgrade of php inside the xampp package?


(Stephen Waite) #15

looks like a fairly common search,https://duckduckgo.com/?q=upgrade+php+xampp&t=ffab&ia=web


(Richard Torres) #16

Yup read all of those. The issue I believe is PHP in the 5.01 package is running on version 5.6.20. The current version is 7.3. Thats a massive jump. When you edit the httpd-xampp.conf and edit the lines:

LoadFile “/xampp/php/php5ts.dll”
LoadFile “/xampp/php/libpq.dll”
LoadModule php5_module “/xampp/php/php5apache2_4.dll”

with the new lines
LoadFile “/xampp/php/php7ts.dll”
LoadFile “/xampp/php/libpq.dll”
LoadModule php5_module “/xampp/php/php7apache2_4.dll”

Then the httpd process crashes.
Log Name: Application
Source: Application Error
Date: 10/22/2019 2:45:51 PM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: xxxxxx
Description:
Faulting application name: httpd.exe, version: 2.4.17.0, time stamp: 0x561cc534
Faulting module name: libapr-1.dll, version: 1.5.2.0, time stamp: 0x561cc6a2
Exception code: 0xc0000005
Fault offset: 0x00006c10
Faulting process id: 0x9e4
Faulting application start time: 0x01d58922129edad5
Faulting application path: E:\xampp\apache\bin\httpd.exe
Faulting module path: E:\xampp\apache\bin\libapr-1.dll
Report Id: 5073eea4-f515-11e9-8101-000af7a5f937
Faulting package full name:
Faulting package-relative application ID:
Event Xml:



1000
2
100
0x80000000000000

474431
Application
xxxxxxxxxxx



httpd.exe
2.4.17.0
561cc534
libapr-1.dll
1.5.2.0
561cc6a2
c0000005
00006c10
9e4
01d58922129edad5
E:\xampp\apache\bin\httpd.exe
E:\xampp\apache\bin\libapr-1.dll
5073eea4-f515-11e9-8101-000af7a5f937





If I comment out the new lines:
LoadFile “/xampp/php/php7ts.dll”
LoadFile “/xampp/php/libpq.dll”
LoadModule php5_module “/xampp/php/php7apache2_4.dll”

Apache starts immediately. Seeing as the Apache version in the xampp package is:
Server version: Apache/2.4.17 (Win32)
Apache Lounge VC11 Server built: Oct 13 2015 10:54:clock1130:

I believe that apache has some issues with the required version of php 7.1.xx. The frustrating part is that the 5.02 requires the new version of PHP and will not upgrade the database at all without the change. My other worries are that when the new xampp package is released that the database will not port over to the new package. Or will it?

Thanks


(Richard Torres) #17

So today I went add a second instance using (https://www.open-emr.org/wiki/index.php/OpenEMR_Multiple_Sites_Module) and when I went to the http://serveraddress/openemr/admin.php I get the “PHP version needs to be at least 7.1.2.” even when trying to access the admin page. This is driving me insane. Is 7.1.2 required upgrade on the default 5.0.1 package installer?


(Stephen Waite) #18

xampp upgrade = :crazy_face: ? :slight_smile:

if i had a windows box i would download the latest xampp and then install a fresh openemr 5.0.2.1 then bring in your old database and run the upgrade