[Koha-bugs] [Bug 22421] accountlines.issue_id is missing a foreign key constraint

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

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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA

--- Comment #19 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
I got myself into trouble here:

1) Check out item backdated, so it's overdue
2) Run fines.pl to accrue fines
3) Return it
4) Verify title etc. still show

- Apply patchset

1) Run updatedatabase and dbic, restart_all
2) Check out same item backdated again
3) Return from patron account

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`accountlines`, CONSTRAINT
`accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues`
(`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE) [for Statement "INSERT INTO
`accountlines` ( `accounttype`, `amount`, `amountoutstanding`,
`borrowernumber`, `branchcode`, `date`, `description`, `interface`, `issue_id`,
`itemnumber`, `manager_id`, `note`, `payment_type`, `status`) VALUES ( ?, ?, ?,
?, ?, NOW(), ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0='OVERDUE', 1=0.9,
2=0.9, 3=51, 4=undef, 5='Conspirator : 07/01/2019 23:59', 6='intranet', 7=4,
8=22, 9=undef, 10='', 11=undef, 12='UNRETURNED'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
Broken FK constraint at /usr/share/perl5/Exception/Class/Base.pm line 88
        Exception::Class::Base::throw('Koha::Exceptions::Object::FKConstraint',
'error', 'Broken FK constraint', 'broken_fk', 'issue_id') called at
/home/vagrant/kohaclone/Koha/Object.pm line 163

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