G01_0345/log/error.log.2021-10-12

2021-10-07 12:59:50,446 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'serial = '2021100700001'' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'serial = '2021100700001'' at line 1")
Stack (most recent call last):
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\_pydev_bundle\pydev_monkey.py", line 773, in __call__
    ret = self.original_func(*self.args, **self.kwargs)
  File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    self._bootstrap_inner()
  File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    self.run()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 554, in run
    self.air_work_pro()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 280, in air_work_pro
    self.update_airdata(True)
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 235, in update_airdata
    self.update_data_tbl(stat)
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 306, in update_data_tbl
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-10 23:25:58,934 - D:\git_workspace\sanoh\G01_0345\sql.py[line:61] - ERROR: mysql查询异常: (1054, "Unknown column 'stat' in 'where clause'")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 56, in sql_inquire
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'stat' in 'where clause'")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 292, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 230, in input_param
    self.get_sel_product_idx_value(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 131, in get_sel_product_idx_value
    paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    result = self.sql_inquire(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 61, in sql_inquire
    self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-10 23:27:33,402 - D:\git_workspace\sanoh\G01_0345\sql.py[line:61] - ERROR: mysql查询异常: (1054, "Unknown column 'stat' in 'where clause'")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 56, in sql_inquire
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'stat' in 'where clause'")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 292, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 230, in input_param
    self.get_sel_product_idx_value(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 131, in get_sel_product_idx_value
    paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    result = self.sql_inquire(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 61, in sql_inquire
    self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-10 23:29:51,562 - D:\git_workspace\sanoh\G01_0345\sql.py[line:61] - ERROR: mysql查询异常: (1054, "Unknown column 'stat' in 'where clause'")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 56, in sql_inquire
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'stat' in 'where clause'")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 292, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 230, in input_param
    self.get_sel_product_idx_value(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 131, in get_sel_product_idx_value
    paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    result = self.sql_inquire(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 61, in sql_inquire
    self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 01:24:05,767 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL, '17700-STD-0345', '17720-STD-0345', True)' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL, '17700-STD-0345', '17720-STD-0345', True)' at line 1")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 690, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 670, in input_param
    self.input_frame.mainloop()
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 366, in input_enter
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 01:34:12,552 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 691, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 671, in input_param
    self.input_frame.mainloop()
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 386, in input_enter
    self.update_param_tbl(17700)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 285, in update_param_tbl
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 01:34:12,570 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Stack (most recent call last):
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 691, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 671, in input_param
    self.input_frame.mainloop()
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 402, in input_enter
    self.update_param_tbl(17720)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 285, in update_param_tbl
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 01:35:03,667 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Stack (most recent call last):
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 2141, in <module>
    main()
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 2132, in main
    globals = debugger.run(setup['file'], None, None, is_module)
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 1441, in run
    return self._exec(is_module, entry_point_fn, module_name, file, globals, locals)
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 1448, in _exec
    pydev_imports.execfile(file, globals, locals)  # execute the script
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
    exec(compile(contents+"\n", file, 'exec'), glob, loc)
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 691, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 671, in input_param
    self.input_frame.mainloop()
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 386, in input_enter
    self.update_param_tbl(17700)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 285, in update_param_tbl
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 01:35:03,680 - D:\git_workspace\sanoh\G01_0345\sql.py[line:46] - ERROR: mysql执行异常: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 41, in sql_action
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE product_name='STD-0345-ALL'' at line 1")
Stack (most recent call last):
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 2141, in <module>
    main()
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 2132, in main
    globals = debugger.run(setup['file'], None, None, is_module)
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 1441, in run
    return self._exec(is_module, entry_point_fn, module_name, file, globals, locals)
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\pydevd.py", line 1448, in _exec
    pydev_imports.execfile(file, globals, locals)  # execute the script
  File "D:\Program Files\JetBrains\PyCharm Community Edition 2020.2.2\plugins\python-ce\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
    exec(compile(contents+"\n", file, 'exec'), glob, loc)
  File "D:/git_workspace/sanoh/G01_0345/main.py", line 8, in <module>
    app.gui_start()
  File "D:\git_workspace\sanoh\G01_0345\app.py", line 809, in gui_start
    init_window.mainloop()          #父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 691, in <lambda>
    command=lambda: self.product_sel_button_event(0))
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 102, in product_sel_button_event
    self.input_param(idx)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 671, in input_param
    self.input_frame.mainloop()
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1280, in mainloop
    self.tk.mainloop(n)
  File "D:\Python\Python36-32\lib\tkinter\__init__.py", line 1702, in __call__
    return self.func(*args)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 402, in input_enter
    self.update_param_tbl(17720)
  File "D:\git_workspace\sanoh\G01_0345\production.py", line 285, in update_param_tbl
    self.sqlclient.sql_action_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 76, in sql_action_all
    result = self.sql_action(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 46, in sql_action
    self.log_file.logger.error('mysql执行异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-11 16:26:24,211 - D:\git_workspace\sanoh\G01_0345\sql.py[line:61] - ERROR: mysql查询异常: (1054, "Unknown column 'stat' in 'where clause'")
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 56, in sql_inquire
    cursor.execute(sql)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 148, in execute
    result = self._query(query)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\cursors.py", line 310, in _query
    conn.query(q)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
    result.read()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'stat' in 'where clause'")
Stack (most recent call last):
  File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    self._bootstrap_inner()
  File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    self.run()
  File "D:\git_workspace\sanoh\G01_0345\output_file.py", line 225, in run
    self.get_product_param()
  File "D:\git_workspace\sanoh\G01_0345\output_file.py", line 40, in get_product_param
    results = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    result = self.sql_inquire(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 61, in sql_inquire
    self.log_file.logger.error('mysql查询异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-12 13:57:31,231 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect
    database=self.database)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
    self.connect()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
    self._request_authentication()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
    auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth
    data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt
    "'cryptography' package is required for sha256_password or caching_sha2_password auth methods"
RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
Stack (most recent call last):
  File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    self._bootstrap_inner()
  File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    self.run()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 584, in run
    self.product_name_set()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 503, in product_name_set
    paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    self.connect()
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect
    self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)
2021-10-12 13:57:50,168 - D:\git_workspace\sanoh\G01_0345\sql.py[line:24] - ERROR: mysql连接异常: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
Traceback (most recent call last):
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 21, in connect
    database=self.database)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
    self.connect()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
    self._request_authentication()
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
    auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth
    data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key)
  File "D:\git_workspace\sanoh\G01_0345\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt
    "'cryptography' package is required for sha256_password or caching_sha2_password auth methods"
RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
Stack (most recent call last):
  File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    self._bootstrap_inner()
  File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    self.run()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 584, in run
    self.product_name_set()
  File "D:\git_workspace\sanoh\G01_0345\pro.py", line 503, in product_name_set
    paramresult = self.sqlclient.sql_inquire_all(sqlstr)
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 68, in sql_inquire_all
    self.connect()
  File "D:\git_workspace\sanoh\G01_0345\sql.py", line 24, in connect
    self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)