[Koha-bugs] [Bug 22421] accountlines.issue_id is missing a foreign key constraint
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jul 11 08:30:17 CEST 2019
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.
More information about the Koha-bugs
mailing list