Project

General

Profile

Mysql::Error: #HY000Incorrect string value while getting repository commints

Added by Johannes Koch over 15 years ago

Hi there

I am running Redmine 0.8.4 with MySQL, set up a project etc

now I am trying to add the repository to the project
-> ruby script/runner "Repository.fetch_changesets" -e production

gives out a long list of "cvs rlog" things etc for all folders

then i get the "stacktrace" below.

anayone got an idea?

C:/redmine-0.8.4/vendor/rails/railties/lib/commands/runner.rb:47: C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abs
tract_adapter.rb:147:in `log': Mysql::Error: #HY000Incorrect string value: '\xFCrs De...' for column 'comments' at row 1: INSERT INTO `changesets` (`c
ommit_date`, `committed_on`, `comments`, `revision`, `scmid`, `user_id`, `repository_id`, `committer`) VALUES('2005-07-06 06:36:45', '2005-07-06 06:36
:45', 'Sourcen zu tbutils eingetragen f³rs Debugging in Eclipse', '_9', NULL, NULL, 2, 'eb') (ActiveRecord::StatementInvalid)
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:302:in `execute'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:161:in `insert_sql'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:312:in `insert_sql'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_qu
ery_dirty'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/base.rb:2517:in `create_without_callbacks'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/callbacks.rb:220:in `create_without_timestamps'
from C:/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/timestamp.rb:29:in `create'
... 34 levels...
from C:/redmine-0.8.4/vendor/rails/railties/lib/commands/runner.rb:47
from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
from script/runner:3

The table "changesets" has the following information:

CREATE TABLE "redmine"."changesets"
(
id int PRIMARY KEY NOT NULL,
repository_id int NOT NULL,
revision varchar(255) NOT NULL,
committer varchar(255),
committed_on timestamp NOT NULL,
comments longtext,
commit_date date,
scmid varchar(255),
user_id int
)
;
CREATE UNIQUE INDEX changesets_repos_rev ON changesets
(
repository_id,
revision
)
;
CREATE UNIQUE INDEX PRIMARY ON changesets(id)
;


Replies (1)

RE: Mysql::Error: #HY000Incorrect string value while getting repository commints - Added by Johannes Koch over 15 years ago

The Problem is a "ü" in the comment.

I guess I have to fix my MySQL Setup for it to work?

What do i have to do?

    (1-1/1)