$logger->debug("INSERT INTO script(repoid, sname) SELECT repoid, '" . $scriptN . "' as sname FROM repository WHERE rname='" . $repository->getName . "'"); my $query = $self->{dbConn}->prepare("INSERT INTO script(repoid, sname) SELECT repoid, '" . $scriptN . "' as sname FROM repository WHERE rname='" . $scriptN . "'"); my $affected = $query->execute; $self->{dbConn}->commit; $logger->debug($DBI::errstr || 'no errors found, ' . $affected . ' affected');