@@ -, +, @@ --- misc/cronjobs/advance_notices.pl | 5 ++++- misc/cronjobs/automatic_item_modification_by_age.pl | 5 +++++ misc/cronjobs/automatic_renewals.pl | 4 ++++ misc/cronjobs/batch_anonymise.pl | 4 ++++ misc/cronjobs/build_browser_and_cloud.pl | 4 ++++ misc/cronjobs/cart_to_shelf.pl | 4 ++++ misc/cronjobs/check-url-quick.pl | 5 +++++ misc/cronjobs/cleanup_database.pl | 4 ++++ misc/cronjobs/cloud-kw.pl | 6 +++++- misc/cronjobs/create_koc_db.pl | 4 ++++ misc/cronjobs/delete_items.pl | 5 +++++ misc/cronjobs/delete_patrons.pl | 4 ++++ misc/cronjobs/delete_records_via_leader.pl | 5 +++++ misc/cronjobs/edi_cron.pl | 5 +++++ misc/cronjobs/gather_print_notices.pl | 4 ++++ misc/cronjobs/holds/auto_unsuspend_holds.pl | 4 ++++ misc/cronjobs/holds/build_holds_queue.pl | 4 ++++ misc/cronjobs/holds/cancel_expired_holds.pl | 4 ++++ misc/cronjobs/holds/cancel_unfilled_holds.pl | 4 ++++ misc/cronjobs/import_webservice_batch.pl | 4 ++++ misc/cronjobs/j2a.pl | 4 ++++ misc/cronjobs/longoverdue.pl | 4 ++++ misc/cronjobs/membership_expiry.pl | 4 ++++ misc/cronjobs/merge_authorities.pl | 11 ++++++++--- misc/cronjobs/notice_unprocessed_suggestions.pl | 5 +++++ misc/cronjobs/overdue_notices.pl | 4 ++++ misc/cronjobs/process_message_queue.pl | 4 ++++ misc/cronjobs/purge_suggestions.pl | 4 ++++ misc/cronjobs/reconcile_balances.pl | 5 ++++- misc/cronjobs/runreport.pl | 4 ++++ misc/cronjobs/serialsUpdate.pl | 4 ++++ misc/cronjobs/share_usage_with_koha_community.pl | 4 ++++ misc/cronjobs/staticfines.pl | 4 ++++ misc/cronjobs/stockrotation.pl | 5 +++++ .../cronjobs/thirdparty/TalkingTech_itiva_outbound.pl | 5 +++++ misc/cronjobs/update_totalissues.pl | 4 ++++ 36 files changed, 157 insertions(+), 6 deletions(-) --- a/misc/cronjobs/advance_notices.pl +++ a/misc/cronjobs/advance_notices.pl @@ -223,7 +223,10 @@ END_WARN unless ($confirm) { pod2usage(1); } - +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); # The fields that will be substituted into <> --- a/misc/cronjobs/automatic_item_modification_by_age.pl +++ a/misc/cronjobs/automatic_item_modification_by_age.pl @@ -20,6 +20,11 @@ my $result = GetOptions( pod2usage(1) if $help; $verbose = 1 unless $confirm; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + # Load configuration from the syspref my $syspref_content = C4::Context->preference('automatic_item_modification_by_age_configuration'); my $rules = eval { JSON::from_json( $syspref_content ) }; --- a/misc/cronjobs/automatic_renewals.pl +++ a/misc/cronjobs/automatic_renewals.pl @@ -68,6 +68,10 @@ GetOptions( pod2usage(0) if $help; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $auto_renews = Koha::Checkouts->search({ auto_renew => 1 }); --- a/misc/cronjobs/batch_anonymise.pl +++ a/misc/cronjobs/batch_anonymise.pl @@ -67,6 +67,10 @@ if ( !$days ) { usage(1); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my ($year,$month,$day) = Today(); --- a/misc/cronjobs/build_browser_and_cloud.pl +++ a/misc/cronjobs/build_browser_and_cloud.pl @@ -62,6 +62,10 @@ my $browser_subfield = $2; warn "browser : $browser_tag / $browser_subfield" unless $batch; die "no cloud or browser field/subfield defined : nothing to do !" unless $browser_tag or $cloud_tag; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $dbh = C4::Context->dbh; --- a/misc/cronjobs/cart_to_shelf.pl +++ a/misc/cronjobs/cart_to_shelf.pl @@ -64,6 +64,10 @@ unless ($hours) { die "ERROR: No --hours (-h) option defined"; } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $query = "SELECT itemnumber FROM items WHERE location = 'CART' AND TIMESTAMPDIFF(HOUR, items.timestamp, NOW() ) > ?"; --- a/misc/cronjobs/check-url-quick.pl +++ a/misc/cronjobs/check-url-quick.pl @@ -43,6 +43,11 @@ GetOptions( 'tags=s{,}' => \@tags, ); +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + # Validate tags to check { my %h = map { $_ => undef } @tags; --- a/misc/cronjobs/cleanup_database.pl +++ a/misc/cronjobs/cleanup_database.pl @@ -176,6 +176,10 @@ if ($pDebarments && $allDebarments) { usage(1); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $dbh = C4::Context->dbh(); --- a/misc/cronjobs/cloud-kw.pl +++ a/misc/cronjobs/cloud-kw.pl @@ -42,8 +42,12 @@ sub usage { exit; } -usage() if $help || !$conf; +usage() if $help || !$conf; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my @clouds; --- a/misc/cronjobs/create_koc_db.pl +++ a/misc/cronjobs/create_koc_db.pl @@ -118,6 +118,10 @@ GetOptions( pod2usage(1) if $help; pod2usage( -verbose => 2 ) if $man; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); my %wanted_borrowers_columns = map { $_ => 1 } qw/borrowernumber cardnumber surname firstname address city phone dateofbirth/; my %wanted_issues_columns = map { $_ => 1 } qw/borrowernumber date_due itemcallnumber title itemtype/; --- a/misc/cronjobs/delete_items.pl +++ a/misc/cronjobs/delete_items.pl @@ -7,6 +7,11 @@ use C4::Circulation; use Modern::Perl; use Pod::Usage; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + my $dbh = C4::Context->dbh(); my $query = { --- a/misc/cronjobs/delete_patrons.pl +++ a/misc/cronjobs/delete_patrons.pl @@ -41,6 +41,10 @@ unless ( $not_borrowed_since or $expired_before or $last_seen or $category_code pod2usage(q{At least one filter is mandatory}); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $members = GetBorrowersToExpunge( --- a/misc/cronjobs/delete_records_via_leader.pl +++ a/misc/cronjobs/delete_records_via_leader.pl @@ -77,6 +77,11 @@ This script has the following parameters : exit(); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + my @metadatas = # Should be replaced by a call to C4::Search on zebra index # Record-status when bug 15537 will be pushed Koha::Biblio::Metadatas->search( { format => 'marcxml', schema => C4::Context->preference('marcflavour'), metadata => { LIKE => '%_____d%' } } ); --- a/misc/cronjobs/edi_cron.pl +++ a/misc/cronjobs/edi_cron.pl @@ -36,6 +36,11 @@ use Koha::EDI qw( process_quote process_invoice process_ordrsp); use Koha::Edifact::Transport; use Fcntl qw( :DEFAULT :flock :seek ); +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + my $logdir = C4::Context->config('logdir'); # logging set to trace as this may be what you --- a/misc/cronjobs/gather_print_notices.pl +++ a/misc/cronjobs/gather_print_notices.pl @@ -79,6 +79,10 @@ if ( $ods and @letter_codes != 1 ) { $delimiter ||= q|,|; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $today_iso = output_pref( { dt => dt_from_string, dateonly => 1, dateformat => 'iso' } ) ; --- a/misc/cronjobs/holds/auto_unsuspend_holds.pl +++ a/misc/cronjobs/holds/auto_unsuspend_holds.pl @@ -32,6 +32,10 @@ BEGIN { use C4::Reserves; use C4::Log; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); AutoUnsuspendReserves(); --- a/misc/cronjobs/holds/build_holds_queue.pl +++ a/misc/cronjobs/holds/build_holds_queue.pl @@ -18,6 +18,10 @@ BEGIN { use C4::HoldsQueue qw(CreateQueue); use C4::Log; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); CreateQueue(); --- a/misc/cronjobs/holds/cancel_expired_holds.pl +++ a/misc/cronjobs/holds/cancel_expired_holds.pl @@ -32,6 +32,10 @@ BEGIN { use C4::Reserves; use C4::Log; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); CancelExpiredReserves(); --- a/misc/cronjobs/holds/cancel_unfilled_holds.pl +++ a/misc/cronjobs/holds/cancel_unfilled_holds.pl @@ -35,6 +35,10 @@ use Koha::Calendar; use Koha::DateUtils; use Koha::Libraries; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); =head1 NAME --- a/misc/cronjobs/import_webservice_batch.pl +++ a/misc/cronjobs/import_webservice_batch.pl @@ -50,6 +50,10 @@ EOF ; exit; } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); my $batch_ids = GetStagedWebserviceBatches() or exit; --- a/misc/cronjobs/j2a.pl +++ a/misc/cronjobs/j2a.pl @@ -125,6 +125,10 @@ if ( not $fromcat && $tocat ) { #make sure we've specified the info we need. exit; } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $dbh = C4::Context->dbh; --- a/misc/cronjobs/longoverdue.pl +++ a/misc/cronjobs/longoverdue.pl @@ -228,6 +228,10 @@ unless ($confirm) { print "### TEST MODE -- NO ACTIONS TAKEN ###\n"; } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); # In my opinion, this line is safe SQL to have outside the API. --atz --- a/misc/cronjobs/membership_expiry.pl +++ a/misc/cronjobs/membership_expiry.pl @@ -157,6 +157,10 @@ GetOptions( pod2usage( -verbose => 2 ) if $man; pod2usage(1) if $help || !$confirm; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $expdays = C4::Context->preference('MembershipExpiryDaysNotice'); --- a/misc/cronjobs/merge_authorities.pl +++ a/misc/cronjobs/merge_authorities.pl @@ -19,9 +19,14 @@ GetOptions( ); $|=1; # flushes output -if( $params->{batch} ) { - handle_batch( $params ); -} else { +if ( $params->{batch} ) { + C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef + ); + handle_batch($params); +} +else { pod2usage(1); } --- a/misc/cronjobs/notice_unprocessed_suggestions.pl +++ a/misc/cronjobs/notice_unprocessed_suggestions.pl @@ -22,6 +22,11 @@ if ($help) { pod2usage( verbose => 2 ); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + unless (@days) { pod2usage(q{At least one day parameter should be given}); exit; --- a/misc/cronjobs/overdue_notices.pl +++ a/misc/cronjobs/overdue_notices.pl @@ -326,6 +326,10 @@ GetOptions( pod2usage(1) if $help; pod2usage( -verbose => 2 ) if $man; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction() unless $test_mode; if ( defined $csvfilename && $csvfilename =~ /^-/ ) { --- a/misc/cronjobs/process_message_queue.pl +++ a/misc/cronjobs/process_message_queue.pl @@ -66,6 +66,10 @@ ENDUSAGE die $usage if $help; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); C4::Letters::SendQueuedMessages( --- a/misc/cronjobs/purge_suggestions.pl +++ a/misc/cronjobs/purge_suggestions.pl @@ -63,6 +63,10 @@ if( !$confirm || $help || !defined($days) ) { print "No confirm parameter passed!\n\n" if !$confirm && !$help; print $usage; } elsif( $days and $days > 0 ) { + C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef + ); cronlogaction( " ( days: $days )"); DelSuggestionsOlderThan($days); } else { --- a/misc/cronjobs/reconcile_balances.pl +++ a/misc/cronjobs/reconcile_balances.pl @@ -76,7 +76,10 @@ GetOptions( ) or pod2usage(2); pod2usage(1) if $help; - +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my @patron_ids = map { $_->borrowernumber } Koha::Account::Lines->search( --- a/misc/cronjobs/runreport.pl +++ a/misc/cronjobs/runreport.pl @@ -204,6 +204,10 @@ pod2usage( -verbose => 2 ) if ($man); pod2usage( -verbose => 2 ) if ($help and $verbose); pod2usage(1) if $help; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); unless ($format) { --- a/misc/cronjobs/serialsUpdate.pl +++ a/misc/cronjobs/serialsUpdate.pl @@ -79,6 +79,10 @@ GetOptions( pod2usage(1) if $help; pod2usage( -verbose => 2 ) if $man; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); $verbose and !$confirm and print "### Database will not be modified ###\n"; --- a/misc/cronjobs/share_usage_with_koha_community.pl +++ a/misc/cronjobs/share_usage_with_koha_community.pl @@ -35,6 +35,10 @@ Setting the quiet flag will silence this message. exit 1; } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $need_update = ($force ? 1 : C4::UsageStats::NeedUpdate() ); --- a/misc/cronjobs/staticfines.pl +++ a/misc/cronjobs/staticfines.pl @@ -91,6 +91,10 @@ This script has the following parameters : ENDUSAGE die $usage if $help; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $dbh = C4::Context->dbh; --- a/misc/cronjobs/stockrotation.pl +++ a/misc/cronjobs/stockrotation.pl @@ -113,6 +113,11 @@ use C4::Context; use C4::Letters; use Koha::StockRotationRotas; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + my $admin_email = ''; my $branch = 0; my $execute = 0; --- a/misc/cronjobs/thirdparty/TalkingTech_itiva_outbound.pl +++ a/misc/cronjobs/thirdparty/TalkingTech_itiva_outbound.pl @@ -89,6 +89,11 @@ $library_code ||= ''; pod2usage( -verbose => 1 ) if $help; +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); + # output log or STDOUT my $OUT; if ( defined $outfile ) { --- a/misc/cronjobs/update_totalissues.pl +++ a/misc/cronjobs/update_totalissues.pl @@ -95,6 +95,10 @@ if ( not $result or $want_help ) { usage(); } +C4::Context->set_userenv( + '-1', '-1', undef, 'CRON', 'CRON', undef, + undef, undef, undef, undef, undef +); cronlogaction(); my $dbh = C4::Context->dbh; --