TOPIC: [SOLVED] Events not showing

I have just installed JEvents and Dt Register

I have an event created, but when I try and set up the DT register the event is not showing up in the pull down menu. Any help on this would be great.

Also when I create a custom field it does not save and will not appear on the list.

This has already been discussed in this forum AND I have answered your support ticket already. A little searching would\'ve found this answer, however, here you go...

Make sure your events in JEvents are:
- published
- not already past
- not a recurring event. DT Register does not recognize recurring events. Make it a one-time event and it will show.

One of these items will be the reason why your events do not show. Thanks.

Hi,

I have the same issue and I meet all the requirements you mentioned. I also get the following error when I do a search for the event:
Unknown column \\\'eventtitle\\\' in \\\'where clause\\\' SQL=SELECT count(*) from jos_dtregister_group_event a, jos_events b \\nWHERE a.eventid=b.id AND eventtitle LIKE \\\'%test%\\\' OR member LIKE \\\'%test%\\\' OR amount LIKE \\\'%test%\\\' OR amounti LIKE \\\'%test%\\\' OR late_fee LIKE \\\'%test%\\\'DB function failed with error number 1054
Unknown column \'eventtitle\' in \'where clause\' SQL=SELECT a.*, b.title,b.publish_up from jos_dtregister_group_event a, jos_events b Where a.eventid=b.id AND eventtitle LIKE \'%test%\' OR member LIKE \'%test%\' OR amount LIKE \'%test%\' OR amounti LIKE \'%test%\' OR late_fee LIKE \'%test%\' LIMIT 30.


Also... I\'m wondering.. is it possible to then setup a event, let the user see the available dates and register?

Thanks for your help

turismoa - what do you mean when you \"search for the event\"? What are you trying to do? Sounds like you may need to submit a support ticket. Your issue appears unrelated to this thread.

Hi and thanks for your help.
When I go to Registration Management trough the component menu, I get a screen when I can choose the event from a drop down menu, right next to it there is a SEARCH field. If I type anything in there, including the title from one of my events I get the error below.
Now... I have made sure all the requirements for the event are met. By looking at the SQL error it seems that the query cannot find the field called \"eventittle\" witch would explain maybe why they don\'t show on the drop down menu to begin with.
I checked the table in MySQL and it does not have a field called \"eventittle\".


I hope this clarifies things a bit more.

Thanks

Please download the patch for 2.2.2 from this forum. We just updated it and it will now address your SQL error. Upload the admin.dtregister.php file to:

/administrator/components/com_dtregister/admin.dtregister.php