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

[Zeeben, Nick]

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
*********************************************