[BangPypers] MySQLdb issue with FC11 (Santhosh Edukulla)

[Vijay Ramachandran]

On Thu, Dec 17, 2009 at 3:17 PM, <bangpypers-request at python.org> wrote:

> From: Santhosh Edukulla <santhosh.edukulla at gmail.com>
> We are using MySQLdb module of python on  FC11 box. We were able to
> connect and execute a select statement on a remote mysql machine, but
> the delete, insert and update operations are not working.
>
> This specific machine has the relevant permissions for
> select,update,insert and delete operations on the mysql box.
>
> When the same code is run from a FC2 box, it is working fine.What
> could be the issue here?
>
>
Are you calling commit() after the update statements? The semantics of the
db api - http://www.python.org/dev/peps/pep-0249/ - changed:
"

Note that closing a connection without committing the changes first
will cause an implicit
rollback

"

HTH,
Vijay

            rollback to be performed.