MySQL Bug report and fix (autoconnect =0 => need to commit())
2013-01-10 08:54:37 GMT
I am running
PyICQt Version: 0.8.1.5-5
python-mysqldb Version: 1.2.3-1
mysql-server Version: 5.5.28+dfsg-1
and encountered the following bug:
Nothing was ever written into the database. After some debugging I found out that apparently autocommit is disabled by default.
Here a snipped from the mysql.log:
83 Connect pyicqt <at> localhost on pyicqt
83 Query SET NAMES utf8
83 Query set autocommit=0
Hence an explicit commit is needed in order to actually write changes to the db (and release locks).
I have added those at the relevant places. See attached diff (note that the filenames in the header should probably be changed before patching. ;)
I hope this might be helpful and find its way into the next version.
Apart from this little problem, thx for implementing this nice transport!
You received this message because you are subscribed to the Google Groups "py-transports" group.
To view this discussion on the web visit https://groups.google.com/d/msg/py-transports/-/5LL91NpblqEJ.
To post to this group, send email to py-transports <at> googlegroups.com.
To unsubscribe from this group, send email to py-transports+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/py-transports?hl=en.