Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: mod_dt_upcoming_event SQL error

mod_dt_upcoming_event SQL error 14 years 5 days ago #10871

  • allenyu
  • allenyu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
I got the following error when mod_dt_upcoming_event was enabled. Does anyone know how to fix it? Thanks!

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 4 SQL=select distinct(b.slabId), if(concat(b.startdate,' ',b.starttime) >= '2011-01-05 15:58:21' and b.startdate is not null,'y','n') as future_event , if(cut_off_date = 0000-00-00,'n',if('2011-01-05 15:58:21'> concat(cut_off_date,' ',cut_off_time),'y','n')) as cut_off ,a.*,b.cut_off_date, waiting_list , b.* from jos_dtregister_group_event b where b.publish=1 and b.dtstart >= '2011-01-05' ORDER by b.dtstart asc limit 0,-1

Please Log in or Create an account to join the conversation.

mod_dt_upcoming_event SQL error 14 years 5 days ago #10875

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Hello. Make sure you are using the latest version of BOTH the component and the module. If you are and the issue remains, submit a ticket please.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.129 seconds