[Koha-bugs] [Bug 4002] Issues with borrowernumber set as NULL
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Aug 3 11:30:11 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4002
Paul Poulain <paul.poulain at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #4814|0 |1
is obsolete| |
--- Comment #11 from Paul Poulain <paul.poulain at 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.
More information about the Koha-bugs
mailing list