TOPIC: [SOLVED] UPCOMING EVENTS BROKEN (after you save) - with latest release ...

With the latest update, if you had an UPCOMING EVENTS module on your site, it works fine. That is, until you make a change to the module and hit save.

Then you are presented with this error (which I've verified on a live site and on my test site).

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 ') group by b.slabId ORDER by b.dtstart asc limit 0,6' at line 15 SQL=select distinct(b.slabId), if(concat(b.startdate,' ',b.starttime) >= '2016-01-04 19:50:31' and b.startdate is not null,'y','n') as future_event , if(cut_off_date = 0000-00-00,'n',if('2016-01-04 19:50:31'> concat(cut_off_date,' ',cut_off_time),'y','n')) as cut_off ,b.cut_off_date, if('2016-01-04 19:50:31' < concat(bird_discount_date,' ',bird_discount_time) and bird_discount_type<>0 and bird_discount_type <> 3,'y','n') as bird , waiting_list ,a.* ,r.rp_id , b.* , c2.categoryId , c2.categoryName from ixn1e_dtregister_group_event b left join ixn1e_dtregister_event_categories ec on ec.event_id = b.slabId left join ixn1e_dtregister_categories as c2 on c2.categoryId = ec.category_id left join ixn1e_dtregister_categories as c on c2.lft >= c.lft and c2.lft <= c.rgt left join ixn1e_jevents_vevdetail a on a.evdet_id = b.eventId left join ixn1e_jevents_repetition r on r.eventdetail_id = a.evdet_id where if(ec.event_id IS not NUll, (c2.published = 1 and c2.access in(1,1,2,3,6,8,10,11,12)),1) and b.publish=1 and b.dtend >= '2016-01-04' and c.categoryId in() group by b.slabId ORDER by b.dtstart asc limit 0,6

The fix seems to be to select a specific category. If you leave it to display all categories, it breaks.

The same problem, I can't set only one category. I've sent admin acces ticket.

With the latest DT Register 3.1.6e, this issue is resolved. Thanks!

Not solved, I think.

I´ve updated DT Register, and it's all the same:

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 ') group by b.slabId ORDER by b.dtstart asc limit 0,15' at line 14 SQL=select distinct(b.slabId), if(concat(b.startdate,' ',b.starttime) >= '2016-01-20 08:42:30' and b.startdate is not null,'y','n') as future_event , if(cut_off_date = 0000-00-00,'n',if('2016-01-20 08:42:30'> concat(cut_off_date,' ',cut_off_time),'y','n')) as cut_off ,b.cut_off_date, if('2016-01-20 08:42:30' < concat(bird_discount_date,' ',bird_discount_time) and bird_discount_type<>0 and bird_discount_type <> 3,'y','n') as bird , waiting_list , b.* , c2.categoryId , c2.categoryName from mmp_j25_dtregister_group_event b left join mmp_j25_dtregister_event_categories ec on ec.event_id = b.slabId left join mmp_j25_dtregister_categories as c2 on c2.categoryId = ec.category_id left join mmp_j25_dtregister_categories as c on c2.lft >= c.lft and c2.lft <= c.rgt where if(ec.event_id IS not NUll, (c2.published = 1 and c2.access in(1,1)),1) and b.publish=1 and b.dtend >= '2016-01-20' and c.categoryId in() group by b.slabId ORDER by b.dtstart asc limit 0,15

You can go into my backend to probe. The module is "proximos eventos".
Please, leave the module unpublished, there is a lot of persons using this web.
Thank you

Ok, yes, it is working. It’s necessary to delete all in the module field “categories”, to show all categories. If there is "select categories", then brings the 1064 error.
Thank you