Loading...
 
Skip to main content

Preview with on a wiki-page named with german umlauts leads to an error

Status
Closed
Subject
Preview with on a wiki-page named with german umlauts leads to an error
Version
6.x
Category
  • Error
  • Usability
  • Patch
Feature
Wiki (page view, edit, history, rename, etc)
Submitted by
bubi
Lastmod by
Ushindi Gedeon
Rating
(0)
Description

trying to preview a wiki-page with an name containing german umlauts (e. g. "Grafikdesign - Abschlüsse") leads to the following SQL-Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

for (likely) the following query:

SELECT `page_id`, `pageName`, `hits`, `description`, `lastModif`, `comment`, `version`, `version_minor`, `user`, `ip`, `flag`, `points`, `votes`, `wiki_cache`, `cache_timestamp`, `pageRank`, `creator`, `page_size`, `lang`, `lockedby`, `is_html`, `created`, `wysiwyg`, `wiki_authors_style`, `comments_enabled` FROM `tiki_pages` WHERE `pageName`='Grafikdesign - Abschl�sse'

it seems that the request handling of the char-encoding for preview is not propper.

Solution
Workaround
Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
3873
Created
Monday 09 May, 2011 08:49:04 UTC
by bubi
LastModif
Tuesday 30 June, 2026 16:56:14 UTC


Show PHP error messages