Hi,
I'm trying without success to migrate my user pootle database from SQLite
to MySQL. I'm running Pootle 2.0.3, so I first upgraded to 2.0.6, then try
do migrate the DB:
$ # stop pootle server
$ ./manage.py dumpdata -n > data.json
$ # create the pootle mysql db
$ # change localsettings.py to use MySQL
$ ./manage.py syncdb
$ ./manage.py loaddata ./data.json
Installing json fixture './data' from absolute path.
Problem installing fixture './data.json': Traceback (most recent call last):
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/core/management/commands/loaddata.py",
line 174, in handle
obj.save(using=using)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/core/serializers/base.py",
line 165, in save
models.Model.save_base(self.object, using=using, raw=True)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/db/models/base.py",
line 524, in save_base
rows = manager.using(using).filter(pk=pk_val)._update(values)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/db/models/query.py",
line 502, in _update
return query.get_compiler(self.db).execute_sql(None)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 866, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 732, in execute_sql
cursor.execute(sql, params)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py",
line 86, in execute
return self.cursor.execute(query, args)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/MySQLdb/cursors.py",
line 201, in execute
self.errorhandler(self, exc, value)
File
"/home/martin/dev/pootle-env/local/lib/python2.7/site-packages/MySQLdb/connections.py",
line 36, in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry 'pootle_notifications-notice' for
key 'app_label'")
I'm using:
Pootle-2.0.6
Django-1.2.7
lxml-3.1beta1
MySQL_python-1.2.4c1
South-0.7.6
I tried the DB migration with different versions of Pootle (2.1.6,
git-HEAD) and they all fail with similar errors. What could it be?
Regards,
Martin
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Translate-pootle mailing list
Translate-pootle@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/translate-pootle
