Hi again,
Sorry about the bad formatting of my previous e-mail.Hopefully this copy will be more readable, or else I will just leave it at that.
I have also included some extra info at the bottom that might be relevant.
Hi, everyone
I'm having trouble using MySQL Connector/Python's cursor.callproc() method to call stored procedures whose names include backticks.
Here is the entire traceback (with minor redactions):
<pre>Traceback (most recent call last): File "C:\Users\[...]\Bottle\Website\website.py", line 108, in <module> cursor.callproc('`insert_page`', args) File "C:\Users\[...]\Bottle\lib\site-packages\mysql\connector\cursor.py", line 705, in callproc self.execute("SET {0}=%s".format(argname), (arg,)) File "C:\Users\[...]\Bottle\lib\site-packages\mysql\connector\cursor.py", line 515, in execute self._handle_result(self._connection.cmd_query(stmt)) File "C:\Users\[...]\Bottle\lib\site-packages\mysql\connector\connection.py", line 488, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "C:\Users\[...]\Bottle\lib\site-packages\mysql\connector\connection.py", line 395, in _handle_result raise errors.get_exception(packet)mysql.connector.errors.ProgrammingError: 1064 (42000): 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 '`insert_page`_arg1=NULL' at line 1</pre>
And here is the stored procedure call that produces it:
<pre>args = (None, 'foo', 'bar', None)cursor.callproc('`insert_page`', args)</pre>
Having gone through the Connector/Python manual, I have noticed demonstrations of extended Python string formatting with the cursor.execute() method in order to ensure correct parsing down the line, however, that doesn't seem to be applicable to the callproc() method.
Using the MySQL Command Line Client, I'm able to call the exact same stored procedures without any issues, so the problem has to lie somewhere within the Python application.
I'm using MySQL Connector/Python version 2.1.3, MySQL Server version 5.7.12, Python 3.5.1 (64-bit) on Windows 7 64-bit.
I have asked the same question on stackoverflow. I will mirror any replies to/from there that fix the issue, unless someone objects to that?
Thank you for your time.
Thank you,Magnus