[EventCalendar] ec3_get_calendar() (was ec3_get_events() ) not translating ampersands into character entities

[Alex Tingle]

ejm wrote:
> What exactly am I looking for with the SQL " SELECT post_title FROM
> wp_posts;"? 
> 
> Is it this sort of thing?
> 
> RECONCILATION – TELECONFERENCES

Yes. That's a UTF-8 ndash character. How does that appear in WordPress?

In your e-mail it looks something like aE" - the three bytes are 
interpreted as ISO-8859-1 because your e-mail program has set the 
encoding incorrectly.

I've introduced that character into an event title in my test blog, and 
everything seems to work fine.

Some of your post titles come out with "&amp " - what do they look like 
in MySQL?


> There are a number of instances of this character "–" in the titles.
> Is there some way that I can globally fix those using phpMyAdmin? Or
> is it unlikely that they are what is causing this strangeness?
> 
> -E
> 
> P.S. It has to be something to do with the way I have installed either
> wp or ec. This strangeness is also reproduced on my other wordpress
> (the one that I author) etherwork.net/blog/  I just changed a title to
> include an ampersand instead of the word "and".  Look for "apple &amp
> lavender combination revisited" in the source code. Note that there
> are two spaces between "&amp" and  "lavender" in the title spec. Is it
> possible that ec is changing the semicolon into a nonbreaking space?

Send me a copy of your eventcalendar3/day.php and template-functions.php 
files, so I can see what you are running.

-Alex

--
> On Thu, 11 Oct 2007 15:52:07 +0100, Alex Tingle <alex at firetree.net>
> wrote:
> 
>> I CANNOT reproduce your problem with missing ';' in the 
>> calendar. I see the behaviour on your blog, but I can't reproduce it in 
>> my test set-up.
>>
>>>> I think you should have a look into your database and check the
>>>> offending entry to know for sure
>>> When (if) I figure out how to look into my database  (and what to look
>>> for), I'll report back.
>> Do you have PHPMyAdmin? With that, you can "export" the database into 
>> SQL - just zip it up and send it to me and I'll have a look. (If you 
>> don't mind me seeing all of your data, that is.)
>>
>> Failing that, just send me what you get with this SQL:
>>  SELECT post_title FROM wp_posts;
>> Again, zip it up before you send it - that helps to ensure that the data 
>> survives the e-mailing process intact.
>>
>> Oh, and don't send large attachments to the list - they'll get rejected. 
>> Just send them directly to me.
>>
>> -Alex
> 
> 
> 
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar


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