[GitHub] Jeeva-Ganesan opened a new issue #3682: Parameter issue in MYSQL query

[gi...@git.apache.org]

Jeeva-Ganesan opened a new issue #3682: Parameter issue in MYSQL query
URL: https://github.com/apache/incubator-superset/issues/3682
 
 
   Hi, I just installed superset and tried to connect to my mysql datasource.  This is the error I was keep getting
   
   ```
   ERROR:root:execute() got an unexpected keyword argument 'args'
   Traceback (most recent call last):
     File "/Users/jeeva/anaconda/lib/python2.7/site-packages/superset/sql_lab.py", line 179, in execute_sql
       **db_engine_spec.cursor_execute_kwargs)
   TypeError: execute() got an unexpected keyword argument 'args'
   ```
   
   Here is what i am using to connect to the source - its a mysql connector driver.
   
   `mysql+mysqlconnector://root:XXXXXXXXXX@127.0.0.1:3306/databasename`
   
   This line is what causing this issue,
   
   https://github.com/apache/incubator-superset/blob/d0b5b449b281022d497f2079f83b103602c7077c/superset/sql_lab.py#L178
   
   After I commented this line and changed it to 
   
           #cursor.execute(query.executed_sql,
           #               **db_engine_spec.cursor_execute_kwargs)
           cursor.execute(query.executed_sql)
   
   It worked, posting it here for two reason, one is to share if anyone is facing the same issue and searching for the reason, second one is to know, is there anything wrong with my approach, do I have to install different mysql driver or something?
   
   Thanks.
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services