Find answers from the community

Updated 3 months ago

because I can t run query after it it

because I can't run query after it. it all return. Doesn't generate the query anymore.
Plain Text
 sqlalchemy.exc.ProgrammingError: (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 'Given an input question, first create a syntactically correct mysql query to run' at line 1")
[SQL: Given an input question, first create a syntactically correct mysql query to run, then look at the results of the query and return the answer. You can order the results by a relevant column to return the most interesting examples in the database.
Never query for all the columns from a specific table, only ask for a few relevant columns given the question.
Pay attention to use only the column names that you can see in the schema description. Be careful to not query for columns that do not exist. Pay attention to which column is in which table. Also, qualify column names with the table name when needed.
Use the following format:
Question: Question here
SQLQuery: SQL Query to run]
(Background on this error at: https://sqlalche.me/e/20/f405)
>>> response = query_engine.query("Which club play in England Premier League?"
L
C
8 comments
yea I know, one sec
PR open, just need to make sure the checks pass https://github.com/jerryjliu/llama_index/pull/7261
Thanks. Which version should I use to avoid this error?
8.2.post1 will fix the error, should be out in 30 mins or so
thanks it works
thanks for pointing that out πŸ˜…
Add a reply
Sign up and join the conversation on Discord