Bagaimana untuk menangani ralat ini dalam python pymysql.err.ProgrammingError: (1064, ' pada baris 1")

Question

root@iZbp1iqn00z9x3jov6bas1Z:/data/wwwlogs/www# python log1.py
multiprocessing.pool.RemoteTraceback:
"""
Traceback (most recent call last):
  File "/usr/lib/python3.5/multiprocessing/pool.py", line 119, in worker
    result = (True, func(*args, **kwds))
  File "/usr/lib/python3.5/multiprocessing/pool.py", line 44, in mapstar
    return list(map(*args))
  File "log1.py", line 289, in main_loop
    create_table(table_name)
  File "log1.py", line 87, in create_table
    con_cur.execute(creat_table.format(t_name))
  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 166, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 856, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1057, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1340, in read
    first_packet = self.connection._read_packet()
  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1014, in _read_packet
    packet.check_error()
  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 393, in check_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 107, 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 '' at line 1")
"""

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "log1.py", line 326, in <module>
    p.map(main_loop, logs_list)
  File "/usr/lib/python3.5/multiprocessing/pool.py", line 260, in map
    return self._map_async(func, iterable, mapstar, chunksize).get()
  File "/usr/lib/python3.5/multiprocessing/pool.py", line 608, in get
    raise self._value
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 '' at line 1")

Bagaimana untuk menangani ralat ini

python3.5.2

Ralat dilaporkan seperti berikut

Format log

Answer 1

Nampaknya ralat anda adalah ralat dalam pernyataan SQL Ia sepatutnya disebabkan oleh watak baris baharu anda
Anda disyorkan untuk menggunakan tiga tanda petikan untuk baris baharu dalam pernyataan sql, seperti

.

create_table = """
    sql语句
"""

Answer 2

Nama pembolehubah: log_pattern_obj tidak ditakrifkan, semak jika anda salah menaip huruf atau terlupa untuk mentakrifkannya