TOPIC: Error 1064 when Upcoming Events Active

I went through my 26 client web sites and updated DT Register to the latest version (3.1.6) last night. I had to replace an old template for one site this morning because it was no longer working with the newest Joomla 3.4.8 update (actually, it crashed with 3.4.7), but I rolled back the update and updated it today).

When I got everything up and running, I installed the new Template, RocketTheme Voxel Responsive, I began enabling the modules. When I enabled the DT Register Upcoming Events module, I got the error (prefix changed to protect the innocent):

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' at line 14 SQL=select distinct(b.slabId), if(concat(b.startdate,' ',b.starttime) >= '2015-12-27 20:05:42' and b.startdate is not null,'y','n') as future_event , if(cut_off_date = 0000-00-00,'n',if('2015-12-27 20:05:42'> concat(cut_off_date,' ',cut_off_time),'y','n')) as cut_off ,b.cut_off_date, if('2015-12-27 20:05:42' < 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 abc1_dtregister_group_event b left join abc1_dtregister_event_categories ec on ec.event_id = b.slabId left join abc1_dtregister_categories as c2 on c2.categoryId = ec.category_id left join abc1_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 >= '2015-12-27' and c.categoryId in() group by b.slabId ORDER by b.dtstart asc

No events were active, so I tried unpblishing all of them, then archiving them all, but it didn't seem to matter. I opened/saved the Configuration file, and then deleted the upcoming events module and re-created it - no change.

I also checked permissions and the categories (there are no categories except default). No change.

Finally, I re-installed DT Register, but that didn't help either.

As I worked through the other 25 web sites last night, I didn't see this come up, and some have active events. There are no events on this site after October, so none are active. Is there anything in the above SQL error that might shed light on what's wrong with this particular site?

Thanks,

Ernie

Is the upcoming events module itself updated on that site?

Do you have any modifications to that module in your template's /html directory?

I'm updating the "PKG" for DT Register - I assume it includes the module. I don't see it as a separate item in the Joomla3x directory.

I have not made any modifications.

Thanks,

Ernie

You'll need to submit a ticket with admin access then as we can't replicate it on our sites.

Same issue happening on my sites.

If I select a specific category in the Upcoming events module it works fine.

Definitely broke because of latest updates.

That solved it for me, Paul.

Thanks,

Ernie