Hi, ar., 2013.eko urtren 01a 08:20(e)an, Martin André(e)k idatzi zuen: > 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?
This might be related to this: http://stackoverflow.com/questions/7384689/integrityerror-1062-duplicate-entry-3-add-author-for-key-2 FWIW, 'app_label' is a column set by the Django's 'ContentType' model. ------------------------------------------------------------------------------ Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery and much more. Keep your Java skills current with LearnJavaNow - 200+ hours of step-by-step video tutorials by Java experts. SALE $49.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122612 _______________________________________________ Translate-pootle mailing list Translate-pootle@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/translate-pootle
