from db.mysql_db import pool

class NewsDao:
   #查询待审批新闻列表
   def search_unreview_list(self, page):
       try:
           con = pool.get_connection()
           cursor = con.cursor()
           sql = "SELECT n.id,n.title, t.type, u.username " \
                 "FROM t_news n JOIN t_type t ON n.type_id=t.id " \
                 "JOIN t_user u ON n.editor_id=u.id " \
                 "WHERE n.state=%s " \
                 "ORDER BY n.create_time DESC " \
                 "LIMIT %s,%s"
           cursor.execute(sql, ("待审批", (page-1)*10, 10))
           result = cursor.fetcheall()
           return result
       except Exception as e:
           print(e)
       finally:
           if "con" in dir():
               con.close()


service = NewsDao()
result = service.search_unreview_list(1)
print(result)

出现了下方的错误：

Traceback (most recent call last):

  File "D:/pycharmworkspace/vega/db/news_dao.py", line 26, in <module>

    result = service.search_unreview_list(1)

'MySQLCursor' object has no attribute 'fetcheall'

  File "D:/pycharmworkspace/vega/db/news_dao.py", line 22, in search_unreview_list

    con.close()

  File "D:\Program Files\Python35\lib\site-packages\mysql\connector\pooling.py", line 117, in close

    cnx.reset_session()

  File "D:\Program Files\Python35\lib\site-packages\mysql\connector\connection.py", line 709, in reset_session

    raise errors.OperationalError("MySQL Connection not available.")

mysql.connector.errors.OperationalError: MySQL Connection not available.