[EventCalendar] RE: EventCalendar Digest, Vol 11, Issue 15

[Alex Tingle]

Hi Nick,

The doc page you found contains this:

> The IGNORE keyword causes MySQL to ignore all errors during the process
> of deleting rows. (Errors encountered during the parsing stage are
> processed in the usual manner.) Errors that are ignored due to the use
> of IGNORE are returned as warnings. This option first appeared in MySQL
> 4.1.1.

Sorry, but you'll have to upgrade to at least MySQL 4.1.1. I've now added
that to the readme.

-Alex

--

On Wed, 13 Sep 2006 12:37:28 -0400
"Zeeben, Nick" <nick.zeeben at eng-eff.com> wrote:

> Our host is running version 4.0 of MYSQL.  The documentation says it is
> supported?
> http://dev.mysql.com/doc/refman/4.1/en/delete.html
> 
> 
> 
> -----Original Message-----
> From: eventcalendar-bounces at firetree.net
> [mailto:eventcalendar-bounces at firetree.net] On Behalf Of
> eventcalendar-request at firetree.net
> Sent: Wednesday, September 13, 2006 5:00 AM
> To: eventcalendar at firetree.net
> Subject: EventCalendar Digest, Vol 11, Issue 15
> 
> Send EventCalendar mailing list submissions to
> 	eventcalendar at firetree.net
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
> or, via email, send a message with subject or body 'help' to
> 	eventcalendar-request at firetree.net
> 
> You can reach the person managing the list at
> 	eventcalendar-owner at firetree.net
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of EventCalendar digest..."
> 
> 
> Today's Topics:
> 
>    1. Posting Issues (Zeeben, Nick)
>    2. Re: Posting Issues (Alex Tingle)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 13 Sep 2006 01:18:50 -0400
> From: "Zeeben, Nick" <nick.zeeben at eng-eff.com>
> Subject: [EventCalendar] Posting Issues
> To: <eventcalendar at firetree.net>
> Message-ID:
> 	<02EC137718749D4E87E332DF7A80A10DA68A46 at ntxbeus07.exchange.xchg>
> Content-Type: text/plain; charset="us-ascii"
> 
> I activated my plugin and can post events without issue.  But now any
> posts that are not events return the following when trying to publish or
> 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/28/d151293874/htdocs/TEST/wp-includes/wp-db.php:104) in
> /homepages/28/d151293874/htdocs/TEST/wp-includes/pluggable-functions.php
> on line 272
> 
>  
> 
>  
> 
> Thanks
> 
> Nick
> 
>  
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060913
> /006d0801/attachment-0001.html
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 13 Sep 2006 08:05:29 +0100
> From: Alex Tingle <alex at firetree.net>
> Subject: Re: [EventCalendar] Posting Issues
> To: eventcalendar at firetree.net
> Message-ID: <20060913080529.5675a984 at localhost.localdomain>
> Content-Type: text/plain; charset=US-ASCII
> 
> Hi Nick,
> 
> What version of MySQL are you using? Perhaps you could go to the MySQL
> documentation site and check which version support the "DELETE
> IGNORE..." syntax.
> 
> If you come back and let me know, then I might be able to change the
> code to send SQL customised for that version.
> 
> -Alex
> 
> --
> 
> On Wed, 13 Sep 2006 01:18:50 -0400
> "Zeeben, Nick" <nick.zeeben at eng-eff.com> wrote:
> 
> > I activated my plugin and can post events without issue.  But now any
> > posts that are not events return the following when trying to publish
> or
> > 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/28/d151293874/htdocs/TEST/wp-includes/wp-db.php:104) in
> >
> /homepages/28/d151293874/htdocs/TEST/wp-includes/pluggable-functions.php
> > on line 272
> > 
> >  
> > 
> >  
> > 
> > Thanks
> > 
> > Nick
> > 
> >  
> > 
> 
> 
> -- 
> :: Let me solve your problems: http://www.firetree.net/consulting/
> :: alex.tingle AT firetree.net  +44-7901-552763 
> 
> 
> 
> ------------------------------
> 
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
> 
> 
> End of EventCalendar Digest, Vol 11, Issue 15
> *********************************************
> 
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar


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