VeighNa量化社区
你的开源社区量化交易平台
Member
avatar
加入于:
帖子: 25
声望: 0

刚刚更新好vnpy,通过GUI界面打开行情记录模块,且重启多次,仍然是报错以下信息:

Traceback (most recent call last):
File "c:\vnstudio\lib\site-packages\peewee.py", line 3144, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: table dbtickdata has no column named turnover

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "c:\vnstudio\lib\site-packages\vnpy\app\data_recorder\ui\widget.py", line 155, in process_exception_event
raise exc_info[1].with_traceback(exc_info[2])
File "c:\vnstudio\lib\site-packages\vnpy\app\data_recorder\engine.py", line 80, in run
database_manager.save_tick_data(data)
File "c:\vnstudio\lib\site-packages\vnpy\database\sqlite\sqlite_database.py", line 207, in save_tick_data
DbTickData.insert_many(c).on_conflict_replace().execute()
File "c:\vnstudio\lib\site-packages\peewee.py", line 1907, in inner
return method(self, database, args, **kwargs)
File "c:\vnstudio\lib\site-packages\peewee.py", line 1978, in execute
return self._execute(database)
File "c:\vnstudio\lib\site-packages\peewee.py", line 2745, in _execute
return super(Insert, self)._execute(database)
File "c:\vnstudio\lib\site-packages\peewee.py", line 2474, in _execute
cursor = database.execute(self)
File "c:\vnstudio\lib\site-packages\peewee.py", line 3157, in execute
return self.execute_sql(sql, params, commit=commit)
File "c:\vnstudio\lib\site-packages\peewee.py", line 3151, in execute_sql
self.commit()
File "c:\vnstudio\lib\site-packages\peewee.py", line 2917, in exit
reraise(new_type, new_type(exc_value,
exc_args), traceback)
File "c:\vnstudio\lib\site-packages\peewee.py", line 190, in reraise
raise value.with_traceback(tb)
File "c:\vnstudio\lib\site-packages\peewee.py", line 3144, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: table dbtickdata has no column named turnover

请问是什么原因所致?谢谢!

Member
avatar
加入于:
帖子: 716
声望: 62

新版本更新了数据库字段,添加了turnover,删除用户名目录下.vntrader下的database.db再使用就行,如果数据库中有需要保留的数据记得先取出来

Member
avatar
加入于:
帖子: 25
声望: 0

郭易燔 wrote:

新版本更新了数据库字段,添加了turnover,删除用户名目录下.vntrader下的database.db再使用就行,如果数据库中有需要保留的数据记得先取出来
按照此方法,正常了。谢谢!

© 2015-2022 上海韦纳软件科技有限公司
备案服务号:沪ICP备18006526号

沪公网安备 31011502017034号

【用户协议】
【隐私政策】
【免责条款】