[Koha-bugs] [Bug 27945] Limit the number of article requests per day per patron category

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27945

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com
             Status|Needs Signoff               |Failed QA

--- Comment #7 from David Nind <david at davidnind.com> ---
Hi Agustín.

There are errors when running the database update:

root at kohadevbox:koha(bz27945)$ updatedatabase
DEV atomic update: bug_27945.perl
Atomic update generated errors: {UNKNOWN}: DBI Exception: DBD::mysql::db do
failed: Unknown column 'article_request_fee' in 'categories' [for Statement "
        ALTER TABLE `categories` ADD COLUMN `article_request_limit` tinyint(4)
DEFAULT NULL COMMENT 'Limit article scan requests per day' AFTER
`article_request_fee`
      "]  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
        DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55c0aed443e8),
"DBI Exception: DBD::mysql::db do failed: Unknown column 'arti"...) called at
/usr/share/perl5/DBIx/Class/Storage.pm line 113
       
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x55c0b29ba4b0),
"DBI Exception: DBD::mysql::db do failed: Unknown column 'arti"...) called at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501
        DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Unknown
column 'article_request_fee"..., DBI::db=HASH(0x55c0b4469f90), undef) called at
(eval 1487) line 7
        eval '$DBversion = \'XXX\'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # you can use $dbh here like:
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );

    # or perform some test and warn
    if( !column_exists( \'categories\', \'article_request_limit\' ) ) {
      $dbh->do(q{
        ALTER TABLE `categories` ADD COLUMN `article_request_limit` tinyint(4)
DEFAULT NULL COMMENT \'Limit article scan requests per day\' AFTER
`article_request_fee`
      });
    }

    # Always end with this (adjust the bug info)
    NewVersion( $DBversion, 27945, "Add article_request_limit to categories
table");
}
' called at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 24596


DEV atomic update: bug_27946.perl
Upgrade to XXX done [20:29:34]: Bug 27946 - Add article_request_fee to
categories table, add debit_line_id column to article_requests table and add
ARTICLE_REQUEST as a debit type

-- 
You are receiving this mail because:
You are watching all bug changes.