[EventCalendar] 3.0.4 iCal DB corruption?

Jim Galley jim.galley at gmail.com
Thu Oct 12 13:25:10 UTC 2006


>I think it's a problem that happens when you use MySQL 5. Are the two
databases running different versions of MySQL?

Yes - new is running MySQL 5.0.19


>The 3.1 equivalent of this code is...
>
>      FROM $wpdb->posts p
>      LEFT  JOIN $wpdb->users   u ON p.post_author=u.ID
>      INNER JOIN $ec3->schedule s ON p.id=s.post_id
>
> So, try that for me. Replace everything from 'FROM' with...
>
>      FROM $wpdb->posts p,
>     LEFT  JOIN $wpdb->users    u   ON p.post_author=u.ID
>     INNER JOIN $wpdb->post2cat p2c ON p.id=p2c.post_id
>       AND p2c.category_id=$ec3->event_category

ok... I'll declare my noob status - where can I find this code
snippet?  I searched in eventcalendar3.php and couldn't find it.



More information about the EventCalendar mailing list