[EventCalendar] first post

[Alex Tingle]

> 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 'IGNORE FROM wp_ec3_schedule WHERE post_id=14' at  
> line 1]
> DELETE IGNORE FROM wp_ec3_schedule WHERE post_id=14

What version of MySQL are you using?

Have you tried the patch that prevents double-saving?
(Go to http://sf.net/projects/wpcal and click "Patches".)

BTW, could you reply to the list, so everyone can benefit from the  
conversation.

-Alex

--
Dammit Jim, I'm a programmer... not a mind reader!

On 5 Sep 2006, at 15:45, TIGA31328 at cs.com wrote:

>
> Alex,
>
> Thanks again, that fixed it and the Calendar is working again.
>
> I did run into one oddity, if I edit a category, and or, a time stamp  
> of a post(whether it is in the my 'CALENDAR' events directory, or  
> not), I get the following error when I save:
>
> 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 'IGNORE FROM wp_ec3_schedule WHERE post_id=14' at  
> line 1]
> DELETE IGNORE FROM wp_ec3_schedule WHERE post_id=14
>
>
> Warning: Cannot modify header information - headers already sent by  
> (output started at  
> /homepages/29/d92127831/htdocs/patrickmaloneus/blog/wp-includes/wp- 
> db.php:104) in  
> /homepages/29/d92127831/htdocs/patrickmaloneus/blog/wp-includes/ 
> pluggable-functions.php on line 272
>
>
>
> The changes I am saving still apply and the post is fine, I just get  
> this error everytime now.
>
> Patrick
>
>
>
>> 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
>>