在Synology上运行CouchPotato,我相信CouchPotato最近尝试自动更新自己,因为它突然停止工作。我试过这里推荐的解决方案,但那不起作用。从日志判断,似乎有些SQL更新正在尝试运行,但它返回了一个错误:
07:09:56 CRITICAL [ __main__] Traceback (most recent call last):
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/CouchPotato.py", line 128, in <module>
l.run()
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/CouchPotato.py", line 83, in run
runCouchPotato(self.options, base_path, sys.argv[1:], data_dir = self.data_dir, log_dir = self.log_dir, Env = Env)
File "/volume1/@appstore/couchpotatoserver/share/CouchPotatoServer/couchpotato/runner.py", line 207, in runCouchPotato
upgrade(db, repo)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<string>", line 2, in _migrate
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/versioning/util/__init__.py", line 159, in with_engine
return f(*a, **kw)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/versioning/schema.py", line 91, in runchange
change.run(self.engine, step)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/versioning/script/py.py", line 145, in run
script_func(engine)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/couchpotato/core/migration/versions/001_Releases_last_edit.py", line 15, in upgrade
create_column(last_edit_column, release)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/schema.py", line 38, in create_column
return table.create_column(column, *p, **kw)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/schema.py", line 426, in create_column
column.create(table=self, *p, **kw)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/schema.py", line 528, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 2302, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 1972, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/ansisql.py", line 53, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/sql/visitors.py", line 106, in traverse_single
return meth(obj, **kw)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/databases/sqlite.py", line 75, in visit_column
super(SQLiteColumnGenerator,self).visit_column(column)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/ansisql.py", line 101, in visit_column
self.execute()
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/migrate/changeset/ansisql.py", line 42, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 1449, in execute
params)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 1628, in _execute_text
statement, parameters
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 1698, in _execute_context
context)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/base.py", line 1691, in _execute_context
context)
File "/usr/local/couchpotatoserver/share/CouchPotatoServer/libs/sqlalchemy/engine/default.py", line 331, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) duplicate column name: last_edit '\nALTER TABLE release ADD last_edit INTEGER' ()最后一行似乎是关键.错误“重复列名: last_edit‘\n发行版添加last_edit整数’()”。
对如何解决这个问题有什么想法吗?
发布于 2014-01-21 15:11:13
最后一个解决方案是卸载它,然后安装自定义的CouchPotato包,指定RuudBurger回购如前所述。如果您不使用RuudBurger回购,那么您将得到法国的CouchPotato。
https://stackoverflow.com/questions/21234078
复制相似问题