Traceback (most recent call last):
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbcursor.py", line 271, in executemany
statement_id = self.prepare(statement)
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbcursor.py", line 152, in prepare
response = self.connection.send_request(request)
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbconnection.py", line 84, in send_request
return self.__send_message_recv_reply(payload.getvalue())
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbconnection.py", line 124, in __send_message_recv_reply
return ReplyMessage.unpack_reply(header, payload)
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbprotocolmessage.py", line 92, in unpack_reply
segments=tuple(ReplySegment.unpack_from(payload, expected_segments=header.num_segments)),
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbprotocolsegments.py", line 152, in unpack_from
raise error.parts[0].errors[0]
pyhdb.exceptions.DatabaseError: sql syntax error: incorrect syntax near "%": line 1 col 157 (at pos 157)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbcursor.py", line 35, in format_operation
operation = operation % e_values
TypeError: not all arguments converted during string formatting
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:/users/w/PycharmProjects/pythonProject/insertMysqlAutoOrtData.py", line 48, in
write_item(item)
File "D:/users/w/PycharmProjects/pythonProject/insertMysqlAutoOrtData.py", line 28, in write_item
cursor.executemany(sql, item)
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbcursor.py", line 279, in executemany
operation = format_operation(statement, row_params)
File "D:userswPycharmProjectspythonProjectvenvlibsite-packagespyhdbcursor.py", line 39, in format_operation
raise ProgrammingError(str(msg))
pyhdb.exceptions.ProgrammingError: not all arguments converted during string formatting