Bug in Freetag Plugin w/ Flash and üöä

Creating and modifying plugins.
Post Reply
Harald Weingaertner
Regular
Posts: 474
Joined: Mon Mar 27, 2006 12:32 am

Bug in Freetag Plugin w/ Flash and üöä

Post by Harald Weingaertner »

Hello,

i recognized a bug in the Freetag 3.0 Plugin. When using special characters like üöä it works perfect in the now-Flash Version. But if you use the Flas-Version it stops with an error.

Query failed:

SELECT
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN serendipity_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')INNER JOIN serendipity_entrytags AS entrytags ON (e.id = entrytags.entryid)
WHERE isdraft = 'false' AND e.timestamp <= 1236891600 AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) AND entrytags.tag = 'k�hlregal'
GROUP BY e.id

ORDER BY orderkey DESC, timestamp DESC
LIMIT 4

/ Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='



I think it is a bug... ?

Regards, Harald
judebert
Regular
Posts: 2478
Joined: Sat Oct 15, 2005 6:57 am
Location: Orlando, FL
Contact:

Re: Bug in Freetag Plugin w/ Flash and üöä

Post by judebert »

It looks like your database is running a Swedish encoding, while Serendipity is using UTF-8. You should update them to match; we recommend UTF-8. New postings will then work properly, but old ones will probably have to be updated.

Here are a few links I searched up that relate to your problem:
http://board.s9y.org/viewtopic.php?f=2&t=10163
http://board.s9y.org/viewtopic.php?f=3&t=11335
Judebert
---
Website | Wishlist | PayPal
Harald Weingaertner
Regular
Posts: 474
Joined: Mon Mar 27, 2006 12:32 am

Re: Bug in Freetag Plugin w/ Flash and üöä

Post by Harald Weingaertner »

Thanks Judebert !
Post Reply