[Bug 4002] Issues with borrowernumber set as NULL
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4002 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #4814|0 |1 is obsolete| | --- Comment #11 from Paul Poulain <paul.poulain@biblibre.com> 2011-08-03 09:30:11 UTC --- Created attachment 4815 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=4815 proposed fix signed-off oups, uploaded a wrong patch, sorry. This one is correct $dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_1`"); $dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_2`"); now before : $dbh->do("ALTER TABLE issues ALTER COLUMN borrowernumber DROP DEFAULT"); $dbh->do("ALTER TABLE issues ALTER COLUMN itemnumber DROP DEFAULT"); $dbh->do("ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL"); $dbh->do("ALTER TABLE issues MODIFY COLUMN itemnumber int(11) NOT NULL"); -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org