Defect #6996
closedMigration trac(sqlite3) -> redmine(postgresql) doesnt escape ' char
0%
Description
During migration:
krtek:/opt/redmine/redmine-1.0# export LANG=C; rake redmine:migrate_from_trac RAILS_ENV="production" (in /opt/redmine/redmine-1.0) WARNING: a new project will be added to Redmine during this process. Are you sure you want to continue ? [y/N] y Trac directory []: /var/lib/trac/dm_library/ Trac database adapter (sqlite, sqlite3, mysql, postgresql) [sqlite]: sqlite3 Trac database encoding [UTF-8]: Target project identifier []: dmlibrary Migrating components.............. Migrating milestones......... Migrating custom fields.. Migrating tickets................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ Migrating wiki..................................................................................rake aborted! SQLite3::SQLException: near "a": syntax error: SELECT DISTINCT attachment.* FROM attachment WHERE attachment.type = 'wiki' AND attachment.id = 'Jak nauczyć Visual Studio obsługiwać Boost'a' (See full trace by running task with --trace) 2010-11-28 17:17:46-17:26:20 export LANG=C; rake redmine:migrate_from_trac RAILS_ENV="production" # 1
current software:
2010-11-28 17:43:30 export RAILS_ENV="production"
krtek:/opt/redmine/redmine-1.0# ruby script/about
About your application's environment
Ruby version 1.8.7 (i486-linux)
RubyGems version 1.3.4
Rack version 1.0
Rails version 2.3.5
Active Record version 2.3.5
Active Resource version 2.3.5
Action Mailer version 2.3.5
Active Support version 2.3.5
Application root /opt/redmine/redmine-1.0
Environment production
Database adapter postgresql
Database schema version 20100705164950
About your Redmine plugins
Redmine Charts 0.1.0
Screenshot Paste 1.1.0
Stuff To Do Plugin 0.4.0
Redmine Graphs plugin 0.1.0
2010-11-28 17:43:37 ruby script/about
I use 8.3.11-0lenny1 version of postgresql.
Files
Updated by Jean-Philippe Lang about 14 years ago
- File migrate_from_trac.patch migrate_from_trac.patch added
Can you try with the attached patch?
Updated by Marek Hobler about 14 years ago
Jean-Philippe Lang wrote:
Can you try with the attached patch?
thanks! it helped :)
Updated by Jean-Philippe Lang about 14 years ago
- Status changed from New to Closed
- Affected version (unused) set to 1.0.4
- Resolution set to Fixed
- Affected version set to 1.0.4
Committed in r4449.