I get the following error when displaying the upcoming events module. I tried to install jEvents, yet the following message still exist:
No valid database connection 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 '-1' at line 5 SQL=select distinct(b.slabId), if(concat(b.startdate,' ',b.starttime) >= '2011-01-14 04:08:01' and b.startdate is not null,'y','n') as future_event , if(cut_off_date = 0000-00-00,'n',if('2011-01-14 04:08:01'> concat(cut_off_date,' ',cut_off_time),'y','n')) as cut_off ,a.*,b.cut_off_date, waiting_list ,a.* ,r.rp_id , b.* from jos_dtregister_group_event b left join jos_jevents_vevdetail a on a.evdet_id = b.eventId left join jos_jevents_repetition r on r.eventdetail_id = a.evdet_id where b.publish=1 and b.dtstart >= '2011-01-14' ORDER by b.dtstart asc limit 0,-1