[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-05-09 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Julian Maurice  changed:

   What|Removed |Added

 Status|Pushed to Master|RESOLVED
 CC||julian.maur...@biblibre.com
 Resolution|--- |FIXED

--- Comment #6 from Julian Maurice  ---
Not needed in stable version, status changed to RESOLVED

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Bernardo Gonzalez Kriegel  changed:

   What|Removed |Added

 CC||bgkrie...@gmail.com

--- Comment #5 from Bernardo Gonzalez Kriegel  ---
(In reply to Brendan Gallagher from comment #4)
> Pushed to Master - Should be in the May 2016 Release.  Thanks!

(In reply to Brendan Gallagher from comment #4)
> Pushed to Master - Should be in the May 2016 Release.  Thanks!

Hi Brendan,
I have a failure in updatedatabase here,
perhaps each sentence neeeds it's own $dbh->do

$dbh->do(q{
ALTER TABLE edifact_messages
DROP FOREIGN KEY emfk_vendor,
DROP FOREIGN KEY emfk_edi_acct,
DROP FOREIGN KEY emfk_basketno;
});

$dbh->do(q{
ALTER TABLE edifact_messages
ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES
aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES
vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES
aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE;
});

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Liz Rea  changed:

   What|Removed |Added

   See Also||https://bugs.koha-community
   ||.org/bugzilla3/show_bug.cgi
   ||?id=16361

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Brendan Gallagher  changed:

   What|Removed |Added

 CC||bren...@bywatersolutions.co
   ||m
 Status|Passed QA   |Pushed to Master

--- Comment #4 from Brendan Gallagher  ---
Pushed to Master - Should be in the May 2016 Release.  Thanks!

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Katrin Fischer  changed:

   What|Removed |Added

  Attachment #50735|0   |1
is obsolete||

--- Comment #3 from Katrin Fischer  ---
Created attachment 50763
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=50763&action=edit
[PASSED QA] Bug 16354 - TestBuilder.t fails due to key constraints

Test Plan:
1) prove t/db_dependent/TestBuilder.t
2) Note failure
3) Apply this patch
4) prove t/db_dependent/TestBuilder.t
5) Tests should now pass!

Signed-off-by: Bernardo Gonzalez Kriegel 
Failure noted and corrected.
No errors

Signed-off-by: Katrin Fischer 

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Katrin Fischer  changed:

   What|Removed |Added

   Patch complexity|--- |Medium patch
 Status|Signed Off  |Passed QA

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/


[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

2016-04-26 Thread bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Katrin Fischer  changed:

   What|Removed |Added

Summary|Fix FK constraints for  |Fix FK constraints for
   |EDIFACT tables  |edifact_messages table

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/