There are quite a few solutions, e.g. hosting a private repository, but the quickest was to change the requirements.txt file to download from mysql’s cdn. i.e., to change: mysql-connector-python==1.0.12 to https://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.1.15.tar.gz
The main differences between them are: mysql-connector-repackaged: is old, do not use it mysql-connector-python 2.0.4: is the original uploaded by MySQL. But it has the problem that does not works with Django >= 1.8. MySQL did not upload yet their stable version 2.1.3 to this repo. mysql-connector-python-rf 2.1.3: is the solution to all your problems … Read more
According to this article it is available by passing in ‘dictionary=True’ to the cursor constructor: http://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursordict.html so I tried: cnx = mysql.connector.connect(database=”bananas”) cursor = cnx.cursor(dictionary=True) and got: TypeError: cursor() got an unexpected keyword argument ‘dictionary’ and I tried: cnx = mysql.connector.connect(database=”bananas”) cursor = cnx.cursor(named_tuple=True) and got: TypeError: cursor() got an unexpected keyword argument ‘named_tuple’ and … Read more
I found that this error occurs since version 2.2.3. You can avoid this issue using version 2.1.6. pip install mysql-connector==2.1.6 try above.
use dbb.commit() after curb.execute (“UPDATE RadioGroups SET CurrentState=1 WHERE RadioID=11”) to commit all the changes that you ‘loaded’ into the mysql server