View | Details | Raw Unified | Return to bug 36027
Collapse All | Expand All

(-)a/misc/maintenance/search_for_data_inconsistencies.pl (-23 / +35 lines)
Lines 113-119 sub set_skip_options { Link Here
113
        # if a least one skip option is provided, print a warning
113
        # if a least one skip option is provided, print a warning
114
        my $has_skip_option = grep { $options{$_} == 1 } grep { /^skip-/ } keys %options;
114
        my $has_skip_option = grep { $options{$_} == 1 } grep { /^skip-/ } keys %options;
115
        if ($has_skip_option) {
115
        if ($has_skip_option) {
116
            print("Warning : skip options are ignored when check options are provided\n");
116
            print(
117
                "Warning: The --skip-* option(s) were ignored. Only the --check-* options in the command were run.\n");
117
        }
118
        }
118
119
119
        # Set all skip options to 0
120
        # Set all skip options to 0
Lines 727-766 sub new_hint { Link Here
727
728
728
=head1 SYNOPSIS
729
=head1 SYNOPSIS
729
730
730
search_for_data_inconsistencies.pl [options]
731
    search_for_data_inconsistencies.pl [options]
731
732
732
=head2 DESCRIPTION
733
=head2 DESCRIPTION
733
734
734
Catch data inconsistencies in Koha database:
735
    Identify data inconsistencies in the Koha database. Checks for:
735
736
    * Items without a home or holding library
736
    * Items with undefined homebranch and/or holdingbranch
737
    * Authority records with an invalid authority type
737
    * Authorities with undefined authtypecodes/authority types
738
    * Records and items without an item type, or an invalid item type:
738
    * Item types:
739
      - if item types are defined at an item level
739
        * if item types are defined at item level (item-level_itypes=specific item),
740
        (item-level_itypes=specific item), then items.itype must
740
        then items.itype must be set else biblioitems.itemtype must be set
741
        be set else biblioitems.itemtype must be set
741
        * Item types defined in items or biblioitems must be defined in the itemtypes table
742
      - Item types defined in items or biblioitems must be defined
743
        in the item types table
744
    * Invalid values in framework fields using authorized values
742
    * Bibliographic records without a title
745
    * Bibliographic records without a title
743
    * Invalid MARCXML in bibliographic records
746
    * Invalid MARCXML in bibliographic records
744
    * Patrons with invalid category types due to lower and upper age limits
747
    * Patrons with an invalid patron category type because of lower
748
      and upper age limits
745
    * Relationships that form guarantor loops
749
    * Relationships that form guarantor loops
746
* Any date fields in the database (timestamp, datetime, date) set to 0000-00-00
750
    * Any date fields in the database (timestamp, datetime, date)
751
      set to 0000-00-00
747
752
748
=head2 OPTIONS
753
=head2 OPTIONS
749
754
750
  --check-branch     Check for items without home or holding library
755
  --check-branch     Check for items without a home or holding library
751
  --check-auth       Check for authority records with invalid authority type
756
  --check-auth       Check for authority records with an invalid authority type
752
  --check-status     Check for bibliographic records and items without an item type or with an invalid item type
757
  --check-status     Check for bibliographic records and items without
753
  --check-framework  Check for invalid values in fields where the framework limits to an authorized value category
758
                     an item type or with an invalid item type
759
  --check-framework  Check for invalid values in fields where the framework
760
                     limits the values to an authorized value category
754
  --check-title      Check for bibliographic records without a title
761
  --check-title      Check for bibliographic records without a title
755
  --check-age        Check for patrons with invalid age for category
762
  --check-age        Check for patrons with an invalid age for the patron
763
                     category
756
  --check-loop       Check for relationships that form guarantor loops
764
  --check-loop       Check for relationships that form guarantor loops
757
  --check-all        Run all checks without specifying any other option
765
  --check-all        Run all checks without specifying any other option
758
  --skip-branch      Skip checking for items without home or holding library
766
  --skip-branch      Skip checking for items without a home or holding
759
  --skip-auth        Skip checking for authority records with invalid authority type
767
                     library
760
  --skip-status      Skip checking for bibliographic records and items without an item type or with an invalid item type
768
  --skip-auth        Skip checking for authority records with an invalid
761
  --skip-framework   Skip checking for invalid values in fields where the framework limits to an authorized value category
769
                     authority type
770
  --skip-status      Skip checking for bibliographic records and items without
771
                     an item type or with an invalid item type
772
  --skip-framework   Skip checking for invalid values in fields where the
773
                     framework limits the values to an authorized value category
762
  --skip-title       Skip checking for bibliographic records without a title
774
  --skip-title       Skip checking for bibliographic records without a title
763
  --skip-age         Skip checking for patrons with invalid age for category
775
  --skip-age         Skip checking for patrons with an invalid age for the
776
                     patron category
764
  --skip-loop        Skip checking for relationships that form guarantor loops
777
  --skip-loop        Skip checking for relationships that form guarantor loops
765
  --help             Print usage information
778
  --help             Print usage information
766
779
767
- 

Return to bug 36027