sszz11123 wrote:

18:59:07 IF88.CFFEX-d开始下载历史数据
18:59:08 数据下载失败，触发异常：
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_ctabacktester\engine.py", line 410, in run_downloading
self.database.save_bar_data(data)
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 176, 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
已解决，这是因为vn.py版本老导致的，删除C:\users\administrator.vntrader\database.db文件，然后重启即可

sszz11123 wrote:

18:56:19 初始化CTA回测引擎
18:56:19 策略文件strategies.temp_strategy加载失败，触发异常：
Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy_ctabacktester\engine.py", line 114, in load_strategy_class_from_module
module: ModuleType = importlib.import_module(module_name)
File "C:\veighna_studio\lib\importlib__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Users\64247\strategies\temp_strategy.py", line 1, in <module>
from vnpy.app.portfolio_strategy import (
ModuleNotFoundError: No module named 'vnpy.app'

18:56:19 策略文件加载完成
18:56:19 数据服务初始化成功
已解决，测试策略是根据旧版本视频写的，因此加载不出来

18:59:07 IF88.CFFEX-d开始下载历史数据
18:59:08 数据下载失败，触发异常：
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_ctabacktester\engine.py", line 410, in run_downloading
self.database.save_bar_data(data)
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 176, 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

18:56:19 初始化CTA回测引擎
18:56:19 策略文件strategies.temp_strategy加载失败，触发异常：
Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy_ctabacktester\engine.py", line 114, in load_strategy_class_from_module
module: ModuleType = importlib.import_module(module_name)
File "C:\veighna_studio\lib\importlib__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Users\64247\strategies\temp_strategy.py", line 1, in <module>
from vnpy.app.portfolio_strategy import (
ModuleNotFoundError: No module named 'vnpy.app'

18:56:19 策略文件加载完成
18:56:19 数据服务初始化成功

17:11:17 策略文件strategies.temp_strategy加载失败，触发异常：
Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy_ctabacktester\engine.py", line 114, in load_strategy_class_from_module
module: ModuleType = importlib.import_module(module_name)
File "C:\veighna_studio\lib\importlib__init__.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 883, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "C:\Users\64247\strategies\temp_strategy.py", line 1, in <module>
from vnpy.app.portfolio_strategy import (
ModuleNotFoundError: No module named 'vnpy.app'