Recurring events : not saving and display bug

Hello everybody ! :slight_smile:

First, sorry for my poor english, I come from France, I’ll try to do my best! :slight_smile:

I’m trying to configure the Scheduler. The regular events works perfectly, but I have a problem with recurring events. When I want to add an event, I have the right lightbox with recurring parameters, I click the save button, the event displays at the right place, but when I refresh the page, it appears as a multi-day event, at the top of the Scheduler. The mouseover event show the end date as “NaN/NaN/NaN at NaNhNaN” and when I click on the event, it disappears. Anyone as an idea of a solution for this problem ?

I’m not the author of this development, so I try to understand it with the online documentation of DHTMLX but it’s a little difficult…

I precise : some fields had been added in the event, we have a contact field and a place field, it works perfectly.
The database table has the following fields : event_id, start_date, end_date, text, contact, rec_type, lieu.
When I read the documentation, it seems to miss some fields (event_pid and event_length). Am I right ? What can I add them ?

Thank you very much for your help !

Have a good day :slight_smile:

Sylvain.

When I read the documentation, it seems to miss some fields (event_pid and event_length). Am I right ? What can I add them ?

Yes you need to have those fields in database
And, if you are using connector - you need to have them all in the connector line as well

docs.dhtmlx.com/scheduler/recurr … ntegration

The error, which you have described, is similar to the case when rec_type was not saved to DB

Hi Stanislav, thanks for your quick help :slight_smile:

Now, in the connector.php file, I have remplaced

"$scheduler->render_table("events_rec");" (where events_rec is the name of the table in my database) 

by "$scheduler->render_table("events_rec","event_id","start_date,end_date,text,contact,rec_type,lieu,event_pid,event_length");"

Now, I have a javascript error when I save my event, it says “TypeError: this.getEvent(…) is undefined”

Is event_id set as autoincrement in DB ?
Try to use FF or Chrome dev tools, and check what is returned from the server side after saving operation.

Hello !

Back to work after the week-end ! Thank you for your message :slight_smile:

Event_id is set as autoincrement in DB. So I took a look in the log file, I copy the SQL Insert and paste it in my phpmyadmin interface, and there is an error on the event_pid et event_length fields. So I put those 2 fields on varchar and it works !

So my problem is resolved ! Thank you very much for your help, rapidity and efficiency !!

Have a very good day ! :slight_smile: