Calendar error

OpenEMR Development
1

jcahn2 wrote on Monday, October 07, 2013:

v4.1.2 on Ubuntu 12.04LTS

Select a recurring appointment (workdays) and change length from 45 to 30 min. Save. Click on “current” produces 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,?,?)

Error: Unknown column ‘Array’ in ‘field list’

Thanks.

2

fsgl wrote on Monday, October 07, 2013:

I presume you are trying to set up your calendar.

Do the following:

  1. Administration/Globals/Calendar, choose start and end times and choose 30 minutes interval. See attachment 1.

  2. Click the time for start. In the Add Event dialog, click Provider; choose In Office, start time, Repeats and Save. See attachments 2 & 3.

  3. Click the time for end. In the Add Event dialog, click Provider; choose Out of Office, end time, Repeats and Save. See attachment 4 & 5.

The 4.1.3 Demo is a good place to practice. 4.1.2 Demo is locked out by a change of login.

3

jcahn2 wrote on Tuesday, October 08, 2013:

The calendar has been setup. I have entered a PATIENT appointment and made it repeat every workday so that the demo will look the same for any workday that is selected. Then I tried to change the length of time for the appointment. When that is saved it gives 4 options in a yellow box because it is repeating. It works fine if I select “all” or “future” but I get an error when selecting “current”.

BTW the appointments do not show on the patient summary screen. 003.png

4

yehster wrote on Tuesday, October 08, 2013:

I tried to reproduce this and can’t seem to get the same error you are reporting.

However, I can tell you that the patient summary screen doesn’t pay attention to the “repeating” portion of appointments.

It only uses the initial “event date.”

5

fsgl wrote on Tuesday, October 08, 2013:

When a recurring appointment is scheduled with one attempt, the yellow application box does not pop up on the Demo. With multiple attempts it will appear.

Why schedule a recurring event everyday to the end of the year, click “Current” and have it only apply to 10/7/13? The Demo did execute this task successfully by giving an appointment only for 10/7/13 but I fail to see the logic of telling the software: this is a one time event but I also want recurring events at the same time.

6

jcahn2 wrote on Tuesday, October 08, 2013:

@ fsgl
Mr Smith has an appt for check on diabetes, CHF, and A Fib, every 4th Tuesday at 0830h. The consistency of a repeating appointment helps him remember his appt and assures no one will trump his allotted time.

Next visit I also want to trim his onychomycotic toenails, so I tell the clerk to change his next appt length from 15 to 30 min (just for that visit).

Bad news: can’t log in to the official demo the last 2 days.

Good news: I can no longer reproduce this error, so I must have had a corrupted appointment, or I just didn’t hold my mouth right.

@ Kevin, any idea why we would want to ignore the next repeating appointment on the summary page. Can you fix that?

7

yehster wrote on Tuesday, October 08, 2013:

Dr. Cahn,
I doubt that the code’s original author explicitly decided to ignore repeating appointments in the patient summary. It’s much easier to write the logic and the database query if one assumes repeating events are only provider events.

I haven’t really looked in depth as to how repeating events work. I can just tell that the query currently being used on the demographics screen doesn’t take them into account.

8

fsgl wrote on Tuesday, October 08, 2013:

Hi Jack,

Antoniou Antonios has an appointment with you everyday at 9 am for the tête-à-tête about glycemic control until 12/31/2013. On 10/15/13 the appointment was lengthened to 30 minutes because of toenail care. See 4.1.2 Demo.

Three of the appointments that I scheduled for him plus one that was given him for 10/17 at 8:45 are in his Summary.

In event that this escaped your notice, Rod’s thread about repeating periodic appointments. Is life good or what?

9

yehster wrote on Tuesday, October 08, 2013:

If the demo wasn’t going to reset before then, on Thursday, that “every day” appointment is likely going to disappear from the summary, but still be on the calendar when the “initial date” of the repeating event is going to be “in the past.”

10

jcahn2 wrote on Tuesday, October 08, 2013:

The appointments for Oct 8, 15, and 17 have been altered and are not in the repeating series and therefore the summary sheet displays them. However the Oct 10 apointment IS part of the repeating series - any idea why it is displayed?

11

yehster wrote on Tuesday, October 08, 2013:

A repeating event is basically treated as a “single event” that will occur on the “Initial Date.” As I said, it would likely disappear on Thursday, if the demo weren’t going to reset before then.

12

fsgl wrote on Tuesday, October 08, 2013:

Went over to the 4.1.3 Demo (resets at 7:02 am Pacific Time) where there is less traffic. Created an appointment for Jane Seymour, 3rd wife of Henry VIII, every Tuesday until end of 2013. The appointment on 10/15 was changed to 45 minutes.

Kevin is correct. Only the 10/8 appointment is in the Summary even after lengthening the 10/15 appointment. The extra appointments for Antoniou Antonios were scheduled by other users.

Nice feature to have every, 2nd, 3rd, 4th, 5th, 6th; workday, week, month, year options for recurring appointments.

Recurrent appointments, check. Modification of recurrent appointment, check. Display of multiple recurring appointments will require customization. Two out of three is not bad.