biller2 wrote on Monday, May 21, 2012:
I have a question about dev 4.1.1. I am testing it out on ubuntu 11.10 with MySQL version 5.1.58 and PHP 5.3.6-13. The question/issue I seem to be having is with recurring appointments. Take for instance I have a recurring appointment and edit it. If I save the changes to all appointments everything seems to work fine however, If I choose to save the changes to just the current appointment I receive the following
ERROR: insert failed: INSERT INTO openemr_postcalendar_events ( pc_catid, pc_multiple, pc_aid, pc_pid, pc_title, pc_time, pc_hometext, pc_informant, pc_eventDate, pc_endDate, pc_duration, pc_recurrtype, pc_recurrspec, pc_startTime, pc_endTime, pc_alldayevent, pc_apptstatus, pc_prefcatid, pc_location, pc_eventstatus, pc_sharing, pc_facility,pc_billing_location ) VALUES (?,?,?,?,?,NOW(),?,?,?,?,?,?,?,?,?,?,?,?,?,1,1,?,?)
then the current appointment vanishes leaving any previous and later appointments. Is this a known issue or possibly something I’m doing incorrectly. Thanks in advancey for any help guidance. John