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

VeighNa Trader 3.2.0报错,找不到列 turnover。只是启动了行情记录功能,还没跑策略呢,就报这个错误,请问如何解决???

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

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy_datarecorder\ui\widget.py", line 157, in process_exception_event
raise exc_info[1].with_traceback(exc_info[2])
File "C:\veighna_studio\lib\site-packages\vnpy_datarecorder\engine.py", line 86, in run
self.database.save_bar_data(data)
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 159, in save_bar_data
DbBarData.insert_many(c).on_conflict_replace().execute()
File "C:\veighna_studio\lib\site-packages\peewee.py", line 1927, in inner
return method(self, database, args, **kwargs)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 1998, in execute
return self._execute(database)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2798, in _execute
return super(Insert, self)._execute(database)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2511, in _execute
cursor = database.execute(self)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3210, in execute
return self.execute_sql(sql, params, commit=commit)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3194, in execute_sql
with exception_wrapper:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2970, in exit
reraise(new_type, new_type(exc_value,
exc_args), traceback)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 191, in reraise
raise value.with_traceback(tb)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3197, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: table dbbardata has no column named turnover

Member
avatar
加入于:
帖子: 4544
声望: 276

数据库更新了turnover字段,但是你的sqlite没有更新字段,删除用户名目录下的.vntrader目录下的database.db再运行即可,删除前可以做好数据库的备份。

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

沪公网安备 31011502017034号

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