Deleted patients name/title etc.in error

Management and Administration
1

jimibrez wrote on Wednesday, July 04, 2012:

Was attempting to delete persons identifier from form in administration.

Whole group has now gone…

ERROR: query failed: SELECT pnotes.id, pnotes.user, pnotes.pid, pnotes.title, pnotes.date, pnotes.message_status, IF(pnotes.user != pnotes.pid,users.fname,patient_data.fname), IF(pnotes.user != pnotes.pid,users.lname,patient_data.lname), patient_data.fname, patient_data.lname FROM ((pnotes LEFT JOIN users ON pnotes.user = users.username) JOIN patient_data ON pnotes.pid = patient_data.pid) WHERE pnotes.message_status != ‘Done’ AND pnotes.deleted != ‘1’ AND pnotes.assigned_to LIKE ?

Error: Unknown column ‘patient_data.fname’ in ‘field list’

2

jimibrez wrote on Wednesday, July 04, 2012:

P.S.
I can still see the deleted entries on the db, and imy guess is they can somehow be added again.
But which ones do i add to restore the original list and how?

3

bradymiller wrote on Thursday, July 05, 2012:

Hi,
Do you have a backup before doing this. My guess is that you are missing fields/data (such as fname in the patient_data table). If really didn’t lose data, then could replace the fields in layout_options via phpmyadmin that you removed by comparing to the original install database file:
http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=sql/database.sql;hb=3d4d206e9ab2635eeaecbc2cf21c6c83b690300f
(search for layout_options and will want to replace the entries with DEM and 1Who)

-brady
OpenEMR

4

jimibrez wrote on Friday, July 06, 2012:

Thanks for the feedback.
I did’nt have a backup as it was a fresh installation, so it was easier to re-install.
Besides, it gives me a bit of an experience on the program itself, trial and error!

5

jimibrez wrote on Friday, July 06, 2012:

Now somehow, changes i make in administration/layouts dont save.

What i have done so far is… Uploaded a fresh install of 4.1.0, uploaded the patch for ver 4.1.0, ran the patch.php with my browser (Firefox 13.0.1. I am using XP Professional.

6

bradymiller wrote on Saturday, July 07, 2012:

Hi,

Which package/instructions are you using:

XAMPP/OpenEMR package - http://www.open-emr.org/wiki/index.php/OpenEMR_4.1_XAMPP_Package_Installation

OR

OpenEMR package - http://www.open-emr.org/wiki/index.php/OpenEMR_4.1_Windows_Installation

And if you are using the OpenEMR package, did you ensure you followed this section:
http://www.open-emr.org/wiki/index.php/OpenEMR_4.1_Windows_Installation#Required_Software_Installation

-brady
OpenEMR

7

jimibrez wrote on Thursday, July 12, 2012:

Problem Solved!
It was an issue with my browser Firefox.