add autocommit argument
set to false the autocommit argument and fix the (') character into location row values.