[Koha-bugs] [Bug 13007] suggestions.budgetid should be a foreign key

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13007

Paola Rossi <paola.rossi at cineca.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #8 from Paola Rossi <paola.rossi at cineca.it> ---
I've applied the patch against master 3.17.00.055

The patch needed some trivial rebasing. 
The number of tests is not increased (error).

When I tried to add a new suggestion linked to "Any" fund, koha said:

Software error:

DBIx::Class::ResultSet::create(): Cannot add or update a child row: a foreign
key constraint fails (`koha`.`suggestions`, CONSTRAINT
`suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES `aqbudgets`
(`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE) at
/var/root-koha/.../C4/Suggestions.pm line 449

On the contrary, adding a new suggestion linked to a real fund is OK.

So I pass the patch to "Failed QA" status.

The "show create table suggestions" command gave:

CONSTRAINT `suggestions_budget_id_fk` FOREIGN KEY (`budgetid`) REFERENCES
`aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE
)

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