| ProgrammingError | Python 3.8.8: /home/benzo/anaconda3/bin/python3.8 Mon Sep 25 21:15:39 2023 |
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
| /home/benzo/benzo.xsrv.jp/public_html/kakakucom/kakakucom_json.cgi in <module> |
| 132 # print(strSQL_Cnt) |
| 133 #件数ロード |
| => 134 cur.execute(strSQL_Cnt) |
| 135 |
| 136 |
| cur = <mysql.connector.cursor_cext.CMySQLCursor object>, cur.execute = <bound method CMySQLCursor.execute of <mysql.connector.cursor_cext.CMySQLCursor object>>, strSQL_Cnt = "\nSELECT \ncount(*)\nFROM `kakakucomAll` as data\nJO...word`) AGAINST('+エアロ +R1(AERO ' in boolean mode)\n" |
| /home/benzo/anaconda3/lib/python3.8/site-packages/mysql/connector/cursor_cext.py in execute(self=<mysql.connector.cursor_cext.CMySQLCursor object>, operation="\nSELECT \ncount(*)\nFROM `kakakucomAll` as data\nJO...word`) AGAINST('+エアロ +R1(AERO ' in boolean mode)\n", params=(), multi=False) |
| 268 |
| 269 try: |
| => 270 result = self._cnx.cmd_query(stmt, raw=self._raw, |
| => 271 buffered=self._buffered, |
| => 272 raw_as_string=self._raw_as_string) |
| result undefined, self = <mysql.connector.cursor_cext.CMySQLCursor object>, self._cnx = <weakproxy at 0x7f8d89029ef0 to CMySQLConnection>, self._cnx.cmd_query = <bound method CMySQLConnection.cmd_query of <mys...nnector.connection_cext.CMySQLConnection object>>, stmt = b"\nSELECT \ncount(*)\nFROM `kakakucomAll` as da...82\xa2\xe3\x83\xad +R1(AERO ' in boolean mode)\n", raw undefined, self._raw = False, buffered undefined, self._buffered = False, raw_as_string undefined, self._raw_as_string = False |
| /home/benzo/anaconda3/lib/python3.8/site-packages/mysql/connector/connection_cext.py in cmd_query(self=<mysql.connector.connection_cext.CMySQLConnection object>, query=b"\nSELECT \ncount(*)\nFROM `kakakucomAll` as da...82\xa2\xe3\x83\xad +R1(AERO ' in boolean mode)\n", raw=False, buffered=False, raw_as_string=False) |
| 520 query_attrs=self._query_attrs) |
| 521 except MySQLInterfaceError as exc: |
| => 522 raise errors.get_mysql_exception(exc.errno, msg=exc.msg, |
| => 523 sqlstate=exc.sqlstate) |
| 524 except AttributeError: |
| global errors = <module 'mysql.connector.errors' from '/home/ben...thon3.8/site-packages/mysql/connector/errors.py'>, errors.get_mysql_exception = <function get_mysql_exception>, exc undefined, msg undefined, sqlstate undefined |
ProgrammingError: 1064 (42000): syntax error, unexpected $end
args =
(1064, '1064 (42000): syntax error, unexpected $end', '42000')
errno =
1064
msg =
'syntax error, unexpected $end'
sqlstate =
'42000'
with_traceback =
<built-in method with_traceback of ProgrammingError object>