Possible bug in Demographics Layout screen (Editing Demographics)

OpenEMR Development
1

arnabnaha wrote on Tuesday, April 08, 2014:

Hi…
While working on Openemr, I tried to edit the demographics using the layout screen (which I used to edit earlier too and it was a breeze),i found that it is throwing errors at me… pecularity of the error is, it is only showing error when i am trying to add a field or simply edit a field in the “MISC” portion of the demographics layout screen. If I edit or add anything in anyother section like “WHO” or “CONTACT” or “CHOICES”, it is perfectly ok and takes the changes well.

The error which is showing is as follows:

ERROR: query failed: INSERT INTO layout_options ( form_id, field_id, title, group_name, seq, uor, fld_length, fld_rows, titlecols, datacols, data_type, edit_options, default_value, description, max_length, list_id ) VALUES ( ‘DEM’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’ )

C:\xampp\htdocs\openemr\interface\super\edit_layout.php at 131:sqlStatement

The php log (error) file:

Fri Apr 04 01:36:05.055948 2014] [access_compat:error] [pid 1956:tid 1792] [client 66.249.76.173:42033] AH01797: client denied by server configuration: C:/xampp/htdocs/xampp/
[Fri Apr 04 01:46:52.932651 2014] [:error] [pid 1956:tid 1776] [client 66.249.64.166:39643] script ‘C:/xampp/htdocs/oscwishlist.php’ not found or unable to stat
[Fri Apr 04 02:06:38.223172 2014] [access_compat:error] [pid 1956:tid 1776] [client 209.222.18.83:59040] AH01797: client denied by server configuration: C:/xampp/htdocs/xampp/, referer: http://nahahealthclinic.dyndns.org/xampp/
[Fri Apr 04 20:21:05.929956 2014] [core:warn] [pid 1780:tid 504] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten – Unclean shutdown of previous Apache run?
[Fri Apr 04 20:21:06.164342 2014] [ssl:warn] [pid 1780:tid 504] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Apr 04 20:21:07.930057 2014] [mpm_winnt:notice] [pid 1780:tid 504] AH00455: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4 configured – resuming normal operations
[Fri Apr 04 20:21:07.930057 2014] [mpm_winnt:notice] [pid 1780:tid 504] AH00456: Server built: May 13 2012 14:10:15
[Fri Apr 04 20:21:07.930057 2014] [core:notice] [pid 1780:tid 504] AH00094: Command line: ‘C:\xampp\apache\bin\httpd.exe -d C:/xampp/apache’
[Fri Apr 04 20:21:07.945684 2014] [mpm_winnt:notice] [pid 1780:tid 504] AH00418: Parent: Created child process 2000
[Fri Apr 04 20:21:09.305121 2014] [ssl:warn] [pid 2000:tid 384] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Apr 04 20:21:09.398877 2014] [mpm_winnt:notice] [pid 2000:tid 384] AH00354: Child: Starting 150 worker threads.
[Mon Apr 07 01:09:41.744027 2014] [access_compat:error] [pid 2000:tid 1788] [client 66.249.76.71:48465] AH01797: client denied by server configuration: C:/xampp/htdocs/xampp/
[Tue Apr 08 01:15:31.529597 2014] [access_compat:error] [pid 2000:tid 1788] [client 66.249.64.65:63464] AH01797: client denied by server configuration: C:/xampp/htdocs/xampp/

The apache error log is not showing any other info or any specific info regarding the error…

PLz help

2

alejandroh wrote on Tuesday, May 06, 2014:

I have the same issue in Demographic. I can create a new group, when adding a second field on the group, get

ERROR: query failed: INSERT INTO layout_options ( form_id, field_id, title, group_name, seq, uor, fld_length, fld_rows, titlecols, datacols, data_type, edit_options, default_value, description, max_length, list_id ) VALUES ( ‘DEM’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’,’’ )

3

blankev wrote on Tuesday, May 06, 2014:

Lay-out in http://demo.open-emr.org:2109/openemr adding a field gives also the error LabCols must be between 1 999. Even a nuber of 111 is not accepted but gives the same error code.

Changing an existing field label does not give an error.

4

cmswest wrote on Tuesday, May 06, 2014:

did you notice in the demo that the headers don’t look right and are altered with the addition of “Backup List” in the add group or add field

so a work around for now is to shift everything over one to the left in your mind, so backup list = label cols, label cols = data cols, etc.

not having this issue on my local development instance, ie running 4.1.3-dev

5

blankev wrote on Tuesday, May 06, 2014:

Yes this worked fine! Tnx for the explanation.