TOPIC: 1064 Error when trying to repeat events

I recently updated all my clients' sites to Joomla 3.4.8 and the latest version of DT Register (3.1.6) and on one of the site I can no longer create repeating events. And to be clear, I can create a non-repeating event without issue.

When I try to create a repeating event this I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 34 SQL=select g.id as group_id , g.member as group_member , g.type as group_type , g.amount as group_amount , epc.prerequisite_id as prerequisitecategory_prerequisite_id, ep.prerequisite_id as prerequisite_prerequisite_id , f.id as file_id , f.path as file_path , f.event_id as file_event_id, fo.id as feeorder_id , fo.eventId as feeorder_eventId , fo.type as feeorder_type ,fo.reference_id as feeorder_reference_id , fo.title as feeorder_title , fo.ordering as feeorder_ordering , l.id as location_id , l.name as location_name , l.address as location_address , l.address2 as location_address2 , l.city as location_city , l.state as location_state , l.zip as location_zip , l.country as location_country , l.phone as location_phone , l.email as location_email , l.website as location_website , l.image as location_image , l.showimage as location_showimage from x3umf_dtregister_group_event e left join x3umf_dtregister_event_detail g on e.slabId = g.slabId left join x3umf_dtregister_prerequisite_category epc on epc.event_id = e.slabId left join x3umf_dtregister_prerequisite ep on ep.event_id = e.slabId left join x3umf_dtregister_files f on f.event_id = e.slabId left join x3umf_dtregister_feeorder fo on fo.eventId = e.slabId left join x3umf_dtregister_locations l on l.id = e.location_id where e.slabId =

And when I click on the link to return to the dashboard, it brings me to the Joomla dashboard. After browsing back to DT Register's events, the new event is there, but it is not repeating when I view the site in the front end.

So for now I had to manually create 2 events a month for the next 12 months, but would love to be able to go back to having the event automatically repeat.

Please advise; thanks!
Doreen

I am seeing the same error with DT Register 3.1.6 when trying to set repeating events.

Joomla 3.4.8
PHP 5.6.1
MySQL 5.6.25

I am noticing, that if I do a weekly recurring event, and only put the end date, but not the days of the week, I can save it, then return and add the days of the week.

I just did a test on our site and was able to create a repeating event without issue with these options:

- Weekly
- 6 repeats
- Friday checked

Please give details on what options you chose to get an error.

Hi Nathan:

Sorry for the delay in my response. I can now create repeating events (forgot to fill out the three criteria).

However, when I go to change something like the short description, after I hit the save or save & close buttons, I am brought to a confirmation message before the changes take place.

After I click the confirmation button to confirm that I want the changes to happen, nothing happens. It just hangs on the page. Please advise.

Thanks!
Doreen

Hi Nathan,
Here is where I am getting the error. If I create an event, choose weekly, put an ending date, then set the days of the week to repeat the event, it works.

My issue seems to be if I create an event for one day, then save it. The event gets created. It is when I go to change it to weekly, add the days of the week I want it to repeat, then save, the ending day does not stick, and the other days are not added.

Phil