LBF Update Problem with OpenEMR 4.1.1

OpenEMR Development
1

mangaleshjoshi wrote on Sunday, September 09, 2012:

Hi!

I created a OP template using LBF. Now, whenever I try to update it with any change, I am unable to do so and get SQL error messages like the following one:

ERROR: query failed: UPDATE layout_options SET title = ‘Procedure Date’, group_name = ‘1General’, seq = ‘1’, uor = ‘2’, fld_length = ‘’, fld_rows = ‘’, max_length = ‘0’, titlecols = ‘1’, datacols = ‘1’, data_type= ‘4’, list_id= ‘’, edit_options = ‘D’, default_value = ‘’, description = ‘Date of Procedure’ WHERE form_id = ‘LBFop’ AND field_id = ‘dop’

Please advise.

– Mangalesh :slight_smile:

2

bradymiller wrote on Monday, September 10, 2012:

Hi,

Can’t reproduce this bug on Xampp-openemr 4.1.1 (basically created an LBF form with some entries and then updated it with no errors; used the settings that you had in above sql query also). Will need more specific details on what brings on this bug.
Here’s the query that worked which is similar to above (just so you know, I pulled this out of the Adminsitration->Other->Logs):

UPDATE layout_options SET title = 'Procedur eDate', group_name = '1hmm', seq = '1', uor = '1', fld_length = '', fld_rows = '', max_length = '0', titlecols = '1', datacols = '1', data_type= '4', list_id= '', edit_options = 'D', default_value = '', description = 'Date of Procedure' WHERE form_id = 'LBFheynow' AND field_id = 'dop'

-brady
OpenEMR