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

Alex Tingle alex at firetree.net
Thu Sep 14 07:18:17 UTC 2006 

On Wed, 13 Sep 2006 16:58:22 -0700
"Pat Yuen" wrote:

> I am getting the same error. My host is running version 4.0.25. I just
> ignore the error and the post will still publish. Are there any consequences
> to just leaving it this way?
> 

Pat, (and Nick)

Try just removing the "IGNORE" keyword and see if it still works. If it does, then post a patch so that others can benefit from the idea.

-Alex

--

> -----Original Message-----
> From: Alex Tingle [mailto:alex at firetree.net] 
> Sent: Wednesday, September 13, 2006 2:20 PM
> To: eventcalendar at firetree.net
> Subject: Re: [EventCalendar] RE: EventCalendar Digest, Vol 11, Issue 15
> 
> 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 
> 
> _______________________________________________
> 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

More information about the EventCalendar mailing list