Admin>config> Save> halts openemr with Template Error

When trying to goto Admin> settings. Openemr freeses after showing the error

Then only choice i am left with is to restore from a backup sql.

Some template bug …

Pl help.

The moment you goto admin >> config and hit save the template error freezes openemr.

this can be reproduced again and again.

I think its a bug.

any help pl @sjpadgett

What version open EMR? Any custom modules turned on?
Let me know and I’ll look into this afternoon.

1 Like

Openemr 8. Something gets written to the database when i click admin>config> save ( even when i dont even click on any of the settings in admin page). Then i am just not able to login.

What patch for v8? I’m running (3) and works for me.
Try clearing Smarty and browser cache.
What modules are turned on such as Context Dashboard etc..?
I believe that saving Config regardless if any changes are made we rewrite entire Config. I’ll have to look but I don’t thing we track dynamic changes and save them only.
I’d suspect a portal template but first I’d like to recreate so please give me more details. Also turn on User Debug to All in Config.
Updates

  • Looks like we compare data form points to existing values in DB then write if different.

Sorry @Robert_James but I’m just guessing at what could be the issue. I need more info so I can try to duplicate your environment to be of any help.
Be sure you’ve ran sql_upgrade.

Let me know when you can be available to work with me (P.M or reply here) and please reply to my previous questions.
I’m usually up late, EST, so check with me if late.

1 Like

No link is clickable in admin config. its a blank page, the hyper links on the left side are just there, not clickable. just save works, and when clicked we get the template error. So cant switch on the debug too :frowning:

Will give u access to my test server where you can replicate the error also Jerry , thank you so much. I will PM u the server root details etc. Thank u so much.

Getting ready to sit down to dinner, so we’ll look at afterwards if you get the credential sent to me

Hi Robert,
First issue I see is all URL IP’s need to be https:// and not http:// so once I logged in as secure things straighten out. However on stuff like sql_upgrade I’m getting redirected to your domain and not the IP you gave me.

Even with using http://, Admin->Config was working okay but Module Manager and Portal Dashboard fail suggesting you may need to clear all cookies and cache in browser. I used both Chrome and FF. You can do a quick search to find instruction for clearing in browser of choice.

Also be sure you get a success run of sql_upgrade.php using version 8.0.0 or 7.0.4 but looks like you have because about is showing 8.0.0(3) but can’t hurt to run again.

Let me know and if need a cal P.M me phone. I’ll be up for a few more hours.

Hope this gets it done for you.
Jerry

Jerry, I have cleared the browser cache many times and tried. Even tried incognito mode.
It is looking for the upgrade file outside open72 (openemr) folder.

my whatsapp no is 0091-7432001215
we can text and call also that would be great if it doesnt get solved.

Regards

What is the exact URL you are using?
Are you using IP? Or a domain address?

yes on this server it used to work with ip address also.

my main official site is at jhcpl.in/open72 there also same template error had arisen when i visited admin and saved it.
now scared to use the admin section till it gets sorted out on the test install here :smiley:

I can run https://142.54.185.218/open72/interface/login/login.php?site=default

All Config work. The issue with running sql_upgrade I believe to be a virtual host issue perhaps or file permissions.

I’m super tired Robert and wish I could hang in there with you but I’ll reach out in morning EST to pick up.

I don’t understand why works for me and not you!
Is anything else showing up in error log?
I’m using FF

It just occurred to me to try running on local host

Hi Jerry
i tried a few things which chat gpt suggested and it worked

https://chatgpt.com/s/t_69eda44de7b48191be6f8b5226cf7680
The 2 lines in the sql_upgrade.php
The upgrade worked and now no template error. :slight_smile:
Regards

Glad you got it to work out. I’m gonna take a closer look because I didn’t have that issue on my sites.
Anyway have a good week.

1 Like