Referal input not working

Management and Administration
1

rickou812 wrote on Tuesday, February 07, 2012:

When trying to put in an referal:  Pt > transaction > referal>
The calender will not allow input and whe trying to save I get error message:
"ERROR: insert failed: INSERT INTO transactions SET title=?, user = ?, groupname = ?, authorized = ?, date = NOW(), refer_date = ?, refer_from = ?, refer_external = ?, refer_to = ?, body = ?, refer_diag = ?, refer_risk_level = ?, refer_vitals = ?, refer_related_code = ?, reply_date = NULL, reply_from = ?, reply_init_diag = ?, reply_final_diag = ?, reply_documents = ?, reply_findings = ?, reply_services = ?, reply_recommend = ?, reply_rx_refer = ?, pid = ?

Error: Unknown column ‘refer_date’ in ‘field list’"

This is using Oemr v4.1.0 (3).

Thanks

2

yehster wrote on Tuesday, February 07, 2012:

an error like this usually means that your database needs to be updated for changes introduced with patches.
go to
http://127.0.0.1/openemr/admin.php
and you should be able to tell if your system has been appropriately updated.
Alternately go to
http://127.0.0.1/openemr/sql_upgrade.php
and  choose the 4.1.0 upgrade script.

3

rickou812 wrote on Tuesday, February 07, 2012:

How can I determine which version the current database installed is?

4

aethelwulffe wrote on Tuesday, February 07, 2012:

openemr\version.php  read it in a text editor, look near the bottom.

5

aethelwulffe wrote on Tuesday, February 07, 2012:

…or just run a much earlier sql_upgrade.php version…after you have backed everything up

6

bradymiller wrote on Tuesday, February 07, 2012:

Hi,

This field was brought in during the 2.8.3->2.9.0 upgrade, so if you started on a version since this (which is likely), then this is not likely your issue.

Guessing you may of modified this in Administration->Layouts->Referrals. Note mods here are not forgiving. For example, if you deleted the refer_date entry then it will remove it from the database, which will then break queries.

Also, versioning can be found in two places:
The codebase version is as version.php
The database version is Administration->Database->'Click ‘Version’ table->Click ‘Browse’
These are not always the same; the admin.php script (which yehster links to above) compares the two and then directs you to run the database upgrade or patch script if needed.

-brady

7

rickou812 wrote on Wednesday, February 08, 2012:

It was a data base issue and I have that resolved.  But now there seems to be an input bug.
When doing the referal:
select patient>transaction>Add>
The referal Date feild “Click here to choose date” calender is not working.  This is true for the live demo version also…
This “choose date” calender IS functional in other areas.

8

bradymiller wrote on Thursday, February 09, 2012:

Hi,
Can not confirm this bug on the online demos. What operating system, browser, and demo are you using?
May want to try removing history/cookies from your browser.
-brady

9

rickou812 wrote on Thursday, February 09, 2012:

Your right, I just tried the demo (4.1.0) from my home computer, and it worked.  My work computer is running windows 7 professional.  I.E. browser, not sure which build…I will see tomorrow.

10

rickou812 wrote on Friday, February 10, 2012:

Still not sure what the issue is, but the browser is I.E. 9.

11

bradymiller wrote on Friday, February 10, 2012:

Hi,

See if you can get the browser to report any javascript errors:
http://www.ehow.com/how_8290513_enable-javascript-errors-ie.html

-brady

12

rickou812 wrote on Monday, February 13, 2012:

There are no java error pop ups…
What else can I look at.
1.  Patient > transactions > referral > “Click here to choose date” calender not working.
2. When the print page pop up, the print screen is not being displayed when in the patients file, but works when going to >Reports > Blank Forms > Referrals.  The print screen displays on the blank form properly…

13

yehster wrote on Monday, February 13, 2012:

I suggest that you try Firefox and/or Chrome and see if you can reproduce the problem.

14

rickou812 wrote on Monday, February 13, 2012:

That’s a problem, the agency will not allow install of any other browser…

I did find looking at the Java error console logs, a line stating “Script blocked”, which is probably the issue, but No script blocking is turned on, but it seems IE9 does some of what it wants…

15

tmccormi wrote on Monday, February 13, 2012:

Don’t install it.  :slight_smile: Get yourself a copy of PortalApps and run it (and lots of other stuff) off a thumb drive.   http://portableapps.com/

-Tony

16

rickou812 wrote on Tuesday, February 14, 2012:

Not sure if I should initiate another post for this, but I will try here first… While working in this area, I also have to modify the referral_template.html file to get information on the form I need.
The problem I have is the inability to save the changes to the referral_template.html file using the administration>files>referral_template.html path.  The changes do not save, and the same goes for the online demo.
Currently I have to email my IT dept. my modified html file to replace the file on the server, I do not have access to the server files.
How can I enable the ability to save the modifications using the built in Files area?

17

bradymiller wrote on Tuesday, February 14, 2012:

Hi,
Just ask your IT folks to give the web server (apache) write permission to the referral_template.html file (along with any other of the configuration files you want to be able to edit in Administration->Files). Then you’ll be able to modify them from within OpenEMR.
-brady

18

rickou812 wrote on Tuesday, February 14, 2012:

What is the exact steps to do this.  He said he tried and could not get it work, even for himself.

BTW, thanks for all your help

19

bradymiller wrote on Tuesday, February 14, 2012:

Hi,
What operating system is the server on?
-brady

20

rickou812 wrote on Tuesday, February 14, 2012:

Not sure, will try and find out tomorrow.