|Anonymous | Login | Signup for a new account||2012-09-13 19:32 PDT|
|Main | Blog | My View | View Issues | Change Log | Roadmap | IRC Chat | Repositories | Scrum Board|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|152||Source Integration||[All Projects] General||public||2010-05-18 01:47||2011-01-18 00:51|
|Target Version||Fixed in Version|
|Summary||152: unicode characters problem|
|Description||when committing comment includes non-English characters (such as Persian or Arabic) this error raises:|
Application Error #401
Database query failed Error #1366
Incorrect string value for column 'message'
|Steps To Reproduce||include a Persian or Arabic string in a commit comment.|
|Tags||No tags attached.|
Source Control Integration 0.16.1
Subversion Integration 0.16
Dennis Somerville (reporter)
I get this same issue as well. I received when setting up a new repo and doing an "Import Everything".
Database query failed. Error received from database was #1366: Incorrect string value: '\xD1OL' for column 'filename' at row 1 for the query: INSERT INTO mantis_plugin_Source_file_table ( change_id, revision, action, filename ) VALUES ( ?, ?, ?, ? ).
Thijs Putman (reporter)
Ran into the same issue; Mantis' DB abstraction layer doesn't seem to handle UTF-8 values that well in this situation...
I applied a quick-and-dirty fix for this problem in SourceChangeset::save() (Source/Source.API.php), added:
$message = iconv('ISO-8859-1', 'ASCII//TRANSLIT', $this->message);
below "$t_changeset_table = ..." (line 860)
Subsequently changed the two queries in the "save" method to utilise "$message" instead of "$this->message".
The above "solution" simply transliterates the SVN commit message back to ASCII (attempting to replace all "special" characters with "regular" ones) before attempting to query the database. Might not be the best long-term solution, but seeing as how commit messages with non-ASCII content are a big exception in my set-up it suffices...
|I believe this is a duplicate of 130|
|2010-05-18 01:47||Shahrooz||New Issue|
|2010-05-18 01:47||Shahrooz||File Added: Mantis Error.JPG|
|2010-05-18 01:52||Shahrooz||Note Added: 212|
|2010-06-14 13:24||Dennis Somerville||Note Added: 223|
|2010-08-09 06:33||Thijs Putman||Note Added: 236|
|2011-01-18 00:51||obones||Note Added: 257|
| Copyright © 2000 - 2012 MantisBT Group
Time: 0.1404 seconds.|
memory usage: 8,382 KB