Hi
Try this:
Kieran
It is an excellent plugin and the developer is superb in response and requests.
Rich
Thread Starter
jdcfsu
(@jdcfsu)
This looks great, but on the calendar page I get nothing but Database errors:
WordPress database error: [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 ‘(‘2007-04-1′,event_end) ORDER BY event_id’ at line 1]
SELECT * FROM wp_calendar WHERE event_recur = ‘W’ AND ‘2007-04-1’ >= event_begin AND event_repeats != 0 AND (event_repeats*7) >= DATEDIFF(‘2007-04-1’,event_end) ORDER BY event_id
When I first went into manage the plugin it told me the table had been created. Is there something else it needs to do?
Hi
Sorry for the delay in responding. I have asked Kieran to respond but I wonder whether you have entered the date correctly. It has to be year-month-day with the dash in between.
Rich
This problem is to do with using MySQL 4.0 or below, as one of the queries in the plugin requires 4.1 or above.
I have fixed this problem and released a new update on my website.
All you need to do to upgrade is swap out the old calendar.php in your plugins directory with the new one provided in the archive.
Thread Starter
jdcfsu
(@jdcfsu)
Thanks for the suggestion and to Kieran for helping with the SQL error. This is a great little script.
