mardi 20 janvier 2015

Trac migrate from sqlite to mysql

I'm trying to migrate our trac database from sqlite to mysql using the TracMigratePlugin (http://ift.tt/1BxQkkO) but I get the following error:



File "plugins/tracmigrateplugin/trac-migrate.py", line 55, in <module>
sys.exit(main(sys.argv[1:]) or 0)
File "plugins/tracmigrateplugin/trac-migrate.py", line 51, in main
return TracMigrationCommand(env)._do_migrate(dest, dburi)
File "/var/lib/stej/plugins/tracmigrateplugin/tracmigrate/admin.py", line 36, in _do_migrate
return self._do_migrate_to_env(env_path, dburi)
File "/var/lib/stej/plugins/tracmigrateplugin/tracmigrate/admin.py", line 52, in _do_migrate_to_env
self._copy_tables(src_db, dst_db, src_dburi, dburi)
File "/var/lib/stej/plugins/tracmigrateplugin/tracmigrate/admin.py", line 132, in _copy_tables
@self._with_transaction(dst_db)
File "/var/lib/stej/plugins/tracmigrateplugin/tracmigrate/admin.py", line 221, in wrapper
fn(db)
File "/var/lib/stej/plugins/tracmigrateplugin/tracmigrate/admin.py", line 146, in copy
"name='initial_database_version'", row)
File "/usr/lib/python2.7/dist-packages/trac/db/util.py", line 66, in execute
return self.cursor.execute(sql)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s WHERE name='initial_database_version'' at line 1")


Running trac 1.0.1 on debian wheezy, I get the error when running the following command:



path/to/trac-migrate.py /path/to/excisting/env /path/to/new_env tracmysql mysql://dbusername:dbpassword@localhost/trac

Aucun commentaire:

Enregistrer un commentaire