web端可视化展示，大部分数据无显示，如何解决？

[zolt168]

只有行业，概念资金流向数据表以及每日ETF数据三张数据表正常展示，其他数据web端可视化无法展示，如何解决？比如综合选股，stock-web.log 错误如下：Uncaught exception GET /instock/api_data?name=cn_stock_selection&date=2025-01-17 (::1)
HTTPServerRequest(protocol='http', host='localhost:9988', method='GET', uri='/instock/api_data?name=cn_stock_selection&date=2025-01-17', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
File "C:\Users***\AppData\Roaming\Python\Python313\site-packages\tornado\web.py", line 1788, in _execute
result = method(*self.path_args, **self.path_kwargs)
File "d:\stock-master\instock\web\dataTableHandler.py", line 69, in get
data = self.db.query(sql,date)
File "d:\stock-master\instock\lib\torndb.py", line 140, in query
self._execute(cursor, query, parameters, kwparameters)
~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "d:\stock-master\instock\lib\torndb.py", line 245, in _execute
return cursor.execute(query, kwparameters or parameters)
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 153, in execute
result = self._query(query)
File "D:\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)
~~~~~~~~~~^^^
File "D:\Python\Python313\Lib\site-packages\pymysql\connections.py", line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Python\Python313\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
result.read()
~~~~~~~~~~~^^
File "D:\Python\Python313\Lib\site-packages\pymysql\connections.py", line 1199, in read
first_packet = self.connection._read_packet()
File "D:\Python\Python313\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "D:\Python\Python313\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "D:\Python\Python313\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'instockdb.cn_stock_attention' doesn't exist")

[whphper]

相同问题

[eqiverson]

相同问题

[dividduang]

相同问题

[bunniestech]

去close那边找issue，手动跑一下初始化脚本和新建一张表就好了

[dividduang]

解决了
docker run -d --name InStockDbService
-v /data/mariadb/data:/var/lib/instockdb
-e MYSQL_ROOT_PASSWORD=root
library/mariadb:latest
大概率是 用了自己的 mysql 但是没有mariadb
实际会有两个镜像