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
Bug in Freetag Plugin w/ Flash and üöä
-
- Regular
- Posts: 474
- Joined: Mon Mar 27, 2006 12:32 am
Re: Bug in Freetag Plugin w/ Flash and üöä
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
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
-
- Regular
- Posts: 474
- Joined: Mon Mar 27, 2006 12:32 am
Re: Bug in Freetag Plugin w/ Flash and üöä
Thanks Judebert !