[EventCalendar] first post

[Alex Tingle]

On Tue, 5 Sep 2006 01:43:31 EDT
TIGA31328 at cs.com wrote:

> Thanks SO MUCH for figuring out my problem.  I have made the modification 
> that you suggested and the calendar navigation is back to normal.  I also emailed 
> the programmer of the online script to advise them of your suggested fix for 
> their software.

Great.

> I have a new problem, I am sorry, I was getting the duplicate dates problem 
> in the calendar(the documented one where you move an event post to another 
> category and back and it duplicates it with another day.  I did the fix mentioned 
> in the mailing list but the duplicate didnt' go away.  So...I thought that I 
> would be smart and just delete the wp_ec3_schedule database and let the script 
> rebuild it...wrong, I did it and after going into options it does not rebuild 
> that table so the calendar is dead.  Any ideas as to how to replace the table?

To force the upgrade:

SQL> DELETE FROM wp_options WHERE option_name='ec3_version';

However, I don't think this will have the desired effect. Your event
posts will now have their dates set to their last modification times. So
the upgrade will make a bunch of schedule entries with the wrong times.

If you have no backup of the table, you'll just have to re-schedule
everything by hand I'm afraid.

If you just want to create an empty table:

 CREATE TABLE wp_ec3_schedule (
           sched_id BIGINT(20) AUTO_INCREMENT,
           post_id  BIGINT(20),
           start    DATETIME,
           end      DATETIME,
           allday   BOOL,
           rpt      VARCHAR(64),
           PRIMARY KEY(sched_id)
         )

-Alex

-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763