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

TOPIC: [SOLVED] 2.7.2 module depends on JEvents

[SOLVED] 2.7.2 module depends on JEvents 13 years 11 months ago #11158

  • allenyu
  • allenyu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
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

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

[SOLVED] 2.7.2 module depends on JEvents 13 years 11 months ago #11162

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
No, this should not be the case. I know I have sites running the latest build of everything with no JEvents in the database at all.

Make sure you have the latest module. You have to upgrade that... not just the component. Also make sure you have run the JEvents Unsync tool in DT Register. If not, then your events are still trying to connect with JEvents. If all is unsynced and all parts of DT Register (component, module, plugins) are updated, then there is no problem to run without JEvents.

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

[SOLVED] 2.7.2 module depends on JEvents 13 years 11 months ago #11165

  • allenyu
  • allenyu's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Thanks for your quick reply. The module is now working charmingly.

The support for this product is really great!

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

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