WinXPSP2; Python 2.4.1; MySQLdb 1.2.0; SQLObject 0.6.1
Following examples noted that no records are actually
inserted into MySQL db, even though autoincrement
increased and no errors are reported.
Tried some tests with MySQLdb alone and found same
issue. Searched Google and found that some releases of
MySQLdb have autocommit set to false by default. Adding
connection.autocommit(True) to MySQLdb example code
resolved the issue.
Made the following change to mysqlconnection.py at line 28:
conn = MySQLdb.connect(host=self.host, db=self.db,
conn.autocommit(True) # DPG2 20050416: required
for \ some versions of MySQLdb
Thanks for SQLObject!