Support Forum

Support for my OSS Projects

1. 

   Binny V A
   Key Master

   Hello,
   
   i have just installed Wordpress 2.7 and Eventr. Installation works fine!
   But after adding an event the event list is still empty: "No events found"
   
   I looked up in the database ... there are all events I have added. But they do not show up in the list ... do you have an ideo what is the reason for this?
   
   Greetings and thanks a lot!!
   Sideshore

   Posted 3 years ago #
2. 

   Anonymous
   Unregistered

   What is the version of your MySQL server? Eventr uses sub-query in some SQL - so it need atleast MySQL 5

   Posted 3 years ago #
3. 

   Binny V A
   Key Master

   Thanks a lot! A have now to change my databes to mysql5!

   Posted 3 years ago #
4. 

   Binny V A
   Key Master

   Hi,
   
   Any tweak that one can do to make it MySQL 4 compatible?
   
   //Emil

   Posted 3 years ago #
5. 

   Anonymous
   Unregistered

   You will have to change a couple of queries -
   
   File eventr/events.php, line 41
   

   $all_event = $wpdb->get_results("SELECT E.ID,E.name,E.event_date,E.status,(SELECT COUNT(*) FROM {$wpdb->prefix}eventr_event_attendee WHERE event_ID=E.ID) AS attendee_count
FROM `{$wpdb->prefix}eventr_event` AS E");


   
   
   Change it to...
   
   

   $all_event = $wpdb->get_results("SELECT E.ID,E.name,E.event_date,E.status, 'Unknown' AS attendee_count
FROM `{$wpdb->prefix}eventr_event` AS E");

   
   
   That should do the trick. Now it should work in older versions of MySQL - but the number of attendees will always be shown as 'Unknown' - you'll have to live with it.
   
   One last thing - I have not tested this fix(my database server is 5) - so report back if if has solved the issue or not.

   Posted 3 years ago #
6. 

   Binny V A
   Key Master

   You my good sir are a true wiz! Works perfect. -Thanks very much!

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.