Hi. I'm having problems with the exception in subject, with pysqlite (on Debian Lenny).
Unfortunately, I'm unable to reproduce the problem, but basically it is an update statement in a transaction. If there is only one row in the table, all is ok; but if there are more then one rows, I get this exception. If I catch the exception and execute the transaction again, it finally succeed. This is the log of executed queries: BEGIN SELECT users.username, users.password, users.email, users.role, users.enabled, users.registration_date, users.last_login FROM users WHERE users.username = ? ['[EMAIL PROTECTED]'] UPDATE users SET last_login=? WHERE users.username = ? ['2008-07-16 11:08:25.944900', u'[EMAIL PROTECTED]'] COMMIT BEGIN SELECT contacts_info.username, contacts_info.full_name, contacts_info.telephone, contacts_info.fiscal_code FROM contacts_info WHERE contacts_info.username = ? ['[EMAIL PROTECTED]'] SELECT contacts_address.username, contacts_address.administrative_area_code, contacts_address.locality, contacts_address.address_line, contacts_address.address_line_2, contacts_address.postal_code FROM contacts_address, contacts_info WHERE contacts_info.username = ? ['[EMAIL PROTECTED]'] COMMIT BEGIN UPDATE contacts_info SET full_name=?, telephone=?, fiscal_code=? WHERE contacts_info.username = ? ['Manlio Perillo x', u'B', u'C', '[EMAIL PROTECTED]'] UPDATE contacts_address SET administrative_area_code=?, locality=?, address_line=?, address_line_2=?, postal_code=? WHERE contacts_address.username = ? [u'AV', 'X', 'Y', 'Z', u'W', '[EMAIL PROTECTED]'] COMMIT ROLLBACK Thanks Manlio Perillo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---