请稍等 ...
×

采纳答案成功!

向帮助你的同学说点啥吧!感谢那些助人为乐的人

运行给到的代码提示错误

Traceback (most recent call last):
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 3160, in execute_sql
cursor.execute(sql, params or ())
File “D:\Python\spider\venv\lib\site-packages\pymysql\cursors.py”, line 148, in execute
result = self._query(query)
File “D:\Python\spider\venv\lib\site-packages\pymysql\cursors.py”, line 310, in _query
conn.query(q)
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 775, in _read_query_result
result.read()
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “D:\Python\spider\venv\lib\site-packages\pymysql\protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “D:\Python\spider\venv\lib\site-packages\pymysql\err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘t1.jtl’ in ‘field list’”)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “D:\Python\spider\csdn_spider\spider.py”, line 177, in
parse_list(url)
File “D:\Python\spider\csdn_spider\spider.py”, line 162, in parse_list
extract_topic(data[“pageData”][“data”][“baseInfo”][“dataList”])
File “D:\Python\spider\csdn_spider\spider.py”, line 126, in extract_topic
if existed_topics:
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 2012, in len
self._ensure_execution()
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 1994, in _ensure_execution
self.execute()
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 1911, in inner
return method(self, database, *args, **kwargs)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 1982, in execute
return self._execute(database)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 2155, in _execute
cursor = database.execute(self)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 3173, in execute
return self.execute_sql(sql, params, commit=commit)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 3167, in execute_sql
self.commit()
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 2933, in exit
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 191, in reraise
raise value.with_traceback(tb)
File “D:\Python\spider\venv\lib\site-packages\peewee.py”, line 3160, in execute_sql
cursor.execute(sql, params or ())
File “D:\Python\spider\venv\lib\site-packages\pymysql\cursors.py”, line 148, in execute
result = self._query(query)
File “D:\Python\spider\venv\lib\site-packages\pymysql\cursors.py”, line 310, in _query
conn.query(q)
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 775, in _read_query_result
result.read()
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “D:\Python\spider\venv\lib\site-packages\pymysql\connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “D:\Python\spider\venv\lib\site-packages\pymysql\protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “D:\Python\spider\venv\lib\site-packages\pymysql\err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
peewee.OperationalError: (1054, “Unknown column ‘t1.jtl’ in ‘field list’”)

运行这个章节给到的最终代码,出现这个错误是什么原因呢?

正在回答 回答被采纳积分+3

1回答

bobby 2021-12-11 12:18:45

“Unknown column ‘t1.jtl’ in ‘field list’”) 这里提示很清楚, mysql表中没有定义 jtl这个列

0 回复 有任何疑惑可以回复我~
问题已解决,确定采纳
还有疑问,暂不采纳
微信客服

购课补贴
联系客服咨询优惠详情

帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

公众号

扫描二维码
关注慕课网微信公众号