Integrity error on django-cms 3.1.2

[Martin Kjellberg]

I'm maintaining and older version of django-cms and today my client couldn't publish, edit or do anything without generating an error:

Traceback (most recent call last):

  File "manage.py", line 10, in <module>

    execute_from_command_line(sys.argv)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/core/management/__init__.py", line 385, in execute_from_command_line

    utility.execute()

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/core/management/__init__.py", line 377, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/core/management/base.py", line 288, in run_from_argv

    self.execute(*args, **options.__dict__)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/core/management/base.py", line 338, in execute

    output = self.handle(*args, **options)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/management/commands/subcommands/base.py", line 24, in handle

    handle_command.handle(*args[1:], **options)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/core/management/base.py", line 533, in handle

    return self.handle_noargs(**options)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/management/commands/subcommands/publisher_publish.py", line 61, in handle_noargs

    for page, add in publish_pages(include_unpublished, language, site):

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/api.py", line 476, in publish_pages

    if not page.publish(lang):

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/models/pagemodel.py", line 609, in publish

    self._copy_contents(public_page, language)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/models/pagemodel.py", line 309, in _copy_contents

    copy_plugins_to(plugins, ph, no_signals=True)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/utils/copy_plugins.py", line 18, in copy_plugins_to

    for old in old_plugins]

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/models/pluginmodel.py", line 311, in copy_plugin

    new_plugin.save()

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/models/pluginmodel.py", line 238, in save

    self.add_root(instance=self)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/treebeard/mp_tree.py", line 593, in add_root

    return MP_AddRootHandler(cls, **kwargs).process()

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/treebeard/mp_tree.py", line 317, in process

    newobj.save()

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/cms/models/pluginmodel.py", line 240, in save

    super(CMSPlugin, self).save()

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/base.py", line 589, in save

    force_update=force_update, update_fields=update_fields)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/base.py", line 617, in save_base

    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/base.py", line 698, in _save_table

    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/base.py", line 731, in _do_insert

    using=using, raw=raw)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/manager.py", line 92, in manager_method

    return getattr(self.get_queryset(), name)(*args, **kwargs)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/query.py", line 921, in _insert

    return query.get_compiler(using=using).execute_sql(return_id)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 921, in execute_sql

    cursor.execute(sql, params)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute

    return self.cursor.execute(sql, params)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/home/fysiografen/.virtualenvs/fysiografen/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute

    return self.cursor.execute(sql, params)

django.db.utils.IntegrityError: duplicate key value violates unique constraint "cms_cmsplugin_path_7692c19a7d5df9d5_uniq"

DETAIL:  Key (path)=(00W0) already exists.

I've tried to remove the faulty cms_cmsplugin row in the database, but it keeps setting that 00W0 path on something else as soon as I publish or update.

Also tried manage.py cms fix-tree (thought it might be that, but no).

I am at loss here, what to do? At the moment I can't update to a more recent version.

Thanks,

/Martin