• Status Confirmed
  • Percent Complete
  • Task Type Bug Report
  • Category Database Queries
  • Assigned To No-one
  • Operating System All
  • Severity Medium
  • Priority Low
  • Reported Version 1.0 devel (github master)
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray
Opened by protonotarios - 26.10.2016

FS#2304 - Greek letters crash tags

When adding a tag in Greek letters (e.g. “Δοκιμή”) I get:

Query {SELECT tag_id FROM `flyspray_list_tag` WHERE (project_id=0 OR project_id=?) AND tag_name LIKE ? ORDER BY project_id} with params {5,Δοκιμή} Failed! (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’)
This task is a sub task of FS#2222 - Greek translation issues
Project Manager

Mmmh, happens probably if default database server settings are not utf8 / utf8_general_ci.

My test on a shared hosting:

mysql> status
Server version:         5.x.xx-log Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /xxx

mysql> show create table fsphp7_list_tag;

CREATE TABLE `fsphp7_list_tag` (
  `tag_id` int(5) NOT NULL AUTO_INCREMENT,
  `project_id` int(5) NOT NULL DEFAULT '0',
  `tag_name` varchar(40) COLLATE latin1_german1_ci NOT NULL,
  `list_position` int(3) NOT NULL DEFAULT '0',
  `show_in_list` int(1) NOT NULL DEFAULT '0',
  `class` varchar(100) COLLATE latin1_german1_ci DEFAULT NULL,
  PRIMARY KEY (`tag_id`),
  UNIQUE KEY `fsphp7_project_id_tag` (`project_id`,`tag_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci


So the list_tag table isn't created with the right charset and collation.

Marked the related task FS#2044 for discussion.


Available keyboard shortcuts


Task Details

Task Editing