[Koha-bugs] [Bug 1820] New: output of update22to30.pl on Ubuntu 6.06

[bugzilla-daemon]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1820

           Summary: output of update22to30.pl on Ubuntu 6.06
           Product: Koha
           Version: rel_3_0
          Platform: All
        OS/Version: Linux - Other
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Command-line Utilities
        AssignedTo: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


gmcharlt on the koha IRC channel suggested I post the output of update22to30.pl
here.

address@hidden:~$
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl
moving accountlines to InnoDB
moving accountlines to utf8
moving accountoffsets to InnoDB
moving accountoffsets to utf8
moving additionalauthors to InnoDB
moving additionalauthors to utf8
moving aqbasket to InnoDB
moving aqbasket to utf8
moving aqbookfund to InnoDB
moving aqbookfund to utf8
moving aqbooksellers to InnoDB
moving aqbooksellers to utf8
moving aqbudget to InnoDB
moving aqbudget to utf8
moving aqorderbreakdown to InnoDB
moving aqorderbreakdown to utf8
moving aqorderdelivery to InnoDB
moving aqorderdelivery to utf8
moving aqorders to InnoDB
moving aqorders to utf8
moving auth_header to InnoDB
moving auth_header to utf8
moving auth_subfield_structure to InnoDB
moving auth_subfield_structure to utf8
moving auth_tag_structure to InnoDB
moving auth_tag_structure to utf8
moving auth_types to InnoDB
moving auth_types to utf8
moving authorised_values to InnoDB
moving authorised_values to utf8
moving biblio to InnoDB
moving biblio to utf8
moving biblio_framework to InnoDB
moving biblio_framework to utf8
moving biblioanalysis to InnoDB
moving biblioanalysis to utf8
moving biblioitems to InnoDB
moving biblioitems to utf8
moving bibliosubject to InnoDB
moving bibliosubject to utf8
moving bibliosubtitle to InnoDB
moving bibliosubtitle to utf8
moving bibliothesaurus to InnoDB
DBD::mysql::db do failed: The used table type doesn't support FULLTEXT indexes
at koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 1729.
moving bibliothesaurus to utf8
moving bookshelf to InnoDB
moving bookshelf to utf8
moving borexp to InnoDB
moving borexp to utf8
moving borrowers to InnoDB
moving borrowers to utf8
moving branchcategories to InnoDB
moving branchcategories to utf8
moving branches to InnoDB
moving branches to utf8
moving branchrelations to InnoDB
moving branchrelations to utf8
moving branchtransfers to InnoDB
moving branchtransfers to utf8
moving catalogueentry to InnoDB
moving catalogueentry to utf8
moving categories to InnoDB
moving categories to utf8
moving currency to InnoDB
moving currency to utf8
moving deletedbiblio to InnoDB
moving deletedbiblio to utf8
moving deletedbiblioitems to InnoDB
moving deletedbiblioitems to utf8
moving deletedborrowers to InnoDB
moving deletedborrowers to utf8
moving deleteditems to InnoDB
moving deleteditems to utf8
moving ethnicity to InnoDB
moving ethnicity to utf8
moving issues to InnoDB
moving issues to utf8
moving issuingrules to InnoDB
moving issuingrules to utf8
moving items to InnoDB
moving items to utf8
moving itemsprices to InnoDB
moving itemsprices to utf8
moving itemtypes to InnoDB
moving itemtypes to utf8
moving labels to InnoDB
moving labels to utf8
moving labels_conf to InnoDB
moving labels_conf to utf8
moving marc_biblio to InnoDB
moving marc_biblio to utf8
moving marc_blob_subfield to InnoDB
moving marc_blob_subfield to utf8
moving marc_breeding to InnoDB
moving marc_breeding to utf8
moving marc_subfield_structure to InnoDB
moving marc_subfield_structure to utf8
moving marc_tag_structure to InnoDB
moving marc_tag_structure to utf8
moving marcrecorddone to InnoDB
moving marcrecorddone to utf8
moving printers to InnoDB
moving printers to utf8
moving reserveconstraints to InnoDB
moving reserveconstraints to utf8
moving reserves to InnoDB
moving reserves to utf8
moving serial to InnoDB
moving serial to utf8
moving sessionqueries to InnoDB
moving sessionqueries to utf8
moving sessions to InnoDB
moving sessions to utf8
moving shelfcontents to InnoDB
moving shelfcontents to utf8
moving statistics to InnoDB
moving statistics to utf8
moving stopwords to InnoDB
moving stopwords to utf8
moving subscription to InnoDB
moving subscription to utf8
moving subscriptionhistory to InnoDB
moving subscriptionhistory to utf8
moving suggestions to InnoDB
moving suggestions to utf8
moving systempreferences to InnoDB
moving systempreferences to utf8
moving uploadedmarc to InnoDB
moving uploadedmarc to utf8
moving userflags to InnoDB
moving userflags to utf8
moving users to InnoDB
moving users to utf8
moving websites to InnoDB
moving websites to utf8
moving z3950queue to InnoDB
moving z3950queue to utf8
moving z3950results to InnoDB
moving z3950results to utf8
moving z3950servers to InnoDB
moving z3950servers to utf8
altering borrowers emailaddress to email
altering borrowers streetaddress to address
altering borrowers faxnumber to fax
altering borrowers textmessaging to opacnote
altering borrowers altnotes to contactnote
altering borrowers physstreet to B_address
altering borrowers streetcity to B_city
altering borrowers phoneday to mobile
altering borrowers zipcode to zipcode
altering borrowers homezipcode to B_zipcode
altering borrowers altphone to B_phone
altering borrowers expiry to dateexpiry
altering borrowers guarantor to guarantorid
altering borrowers altrelationship to relationship
altering deletedborrowers emailaddress to email
altering deletedborrowers streetaddress to address
altering deletedborrowers faxnumber to fax
altering deletedborrowers textmessaging to opacnote
altering deletedborrowers altnotes to contactnote
altering deletedborrowers physstreet to B_address
altering deletedborrowers streetcity to B_city
altering deletedborrowers phoneday to mobile
altering deletedborrowers zipcode to zipcode
altering deletedborrowers homezipcode to B_zipcode
altering deletedborrowers altphone to B_phone
altering deletedborrowers expiry to dateexpiry
altering deletedborrowers guarantor to guarantorid
altering deletedborrowers altrelationship to relationship
removing some unused fields...
Could convert to MyISAM database tables...
Adding repeatable_holidays table...
Adding charges table...
Adding special_holidays table...
Adding opac_news table...
Adding alert table...
Adding action_logs table...
Adding subscriptionroutinglist table...
Adding notifys table...
Adding letter table...
Adding reviews table...
Adding zebraqueue table...
Adding overduerules table...
Adding tags table...
Adding roadtype table...
Adding cities table...
Adding issuedate field to issues table...
Adding associatedborrower field to statistics table...
Adding itemnumber field to serial table...
Adding claimdate field to serial table...
Adding routingnotes field to serial table...
Adding marc field to auth_header table...
Adding linkid field to auth_header table...
Adding imageurl field to itemtypes table...
Adding issuesatonce field to subscription table...
Adding firstacquidate field to subscription table...
Adding manualhistory field to subscription table...
Adding irregularity field to subscription table...
Adding letter field to subscription table...
Adding numberpattern field to subscription table...
Adding distributedto field to subscription table...
Adding internalnotes field to subscription table...
Adding callnumber field to subscription table...
Adding branchcode field to subscription table...
Adding hemisphere field to subscription table...
Adding isurl field to auth_subfield_structure table...
Adding hidden field to auth_subfield_structure table...
Adding linkid field to auth_subfield_structure table...
Adding kohafield field to auth_subfield_structure table...
Adding frameworkcode field to auth_subfield_structure table...
Adding icon field to z3950servers table...
Adding position field to z3950servers table...
Adding type field to z3950servers table...
Adding description field to z3950servers table...
  alter or create marc in marc_breeding
  alter or create borrowernumber in issues
  alter or create itemnumber in issues
  alter or create branchcode in issues
  alter or create issuedate in issues
  alter or create branch in statistics
  alter or create itemtype in statistics
  alter or create notify_id in accountlines
  alter or create notify_level in accountlines
  alter or create accountno in accountlines
  alter or create defaultvalue in marc_subfield_structure
  alter or create id in aqbooksellers
  alter or create listprice in aqbooksellers
  alter or create invoiceprice in aqbooksellers
  alter or create booksellerid in aqbasket
  alter or create categorycode in issuingrules
  alter or create branchcode in issuingrules
  alter or create itemtype in issuingrules
  alter or create firstname in borrowers
  alter or create initials in borrowers
  alter or create B_email in borrowers
  alter or create streetnumber in borrowers
  alter or create streettype in borrowers
  alter or create phone in borrowers
  alter or create B_streetnumber in borrowers
  alter or create B_streettype in borrowers
  alter or create phonepro in borrowers
  alter or create address2 in borrowers
  alter or create emailpro in borrowers
  alter or create contactfirstname in borrowers
  alter or create contacttitle in borrowers
  alter or create branchcode in borrowers
  alter or create categorycode in borrowers
  alter or create dateadded in shelfcontents
  alter or create expirationdate in opac_news
  alter or create number in opac_news
  alter or create branchip in branches
  alter or create branchprinter in branches
  alter or create branchcode in branches
  alter or create itemtype in deletedbiblioitems
  alter or create dewey in deletedbiblioitems
  alter or create itemtype in biblioitems
  alter or create lcsort in biblioitems
  alter or create ccode in biblioitems
  alter or create dewey in biblioitems
  alter or create publicationyear in biblioitems
  alter or create collectiontitle in biblioitems
  alter or create collectionissn in biblioitems
  alter or create collectionvolume in biblioitems
  alter or create editionstatement in biblioitems
  alter or create editionresponsibility in biblioitems
  alter or create reason in suggestions
  alter or create notes in serial
  alter or create category_type in categories
  alter or create categorycode in categories
  alter or create waitingdate in reserves
  alter or create itemtype in itemtypes
  alter or create summary in itemtypes
  alter or create bookfundid in aqbookfund
DBD::mysql::db do failed: Multiple primary key defined at
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 1928.
  alter or create firstname in deletedborrowers
  alter or create initials in deletedborrowers
  alter or create B_email in deletedborrowers
  alter or create streetnumber in deletedborrowers
  alter or create streettype in deletedborrowers
  alter or create phone in deletedborrowers
  alter or create B_streetnumber in deletedborrowers
  alter or create B_streettype in deletedborrowers
  alter or create phonepro in deletedborrowers
  alter or create address2 in deletedborrowers
  alter or create emailpro in deletedborrowers
  alter or create contactfirstname in deletedborrowers
  alter or create contacttitle in deletedborrowers
  alter or create value in systempreferences
  alter or create explanation in systempreferences
  alter or create bookfundid in aqbudget
  alter or create frombranch in branchtransfers
  alter or create tobranch in branchtransfers
  alter or create onloan in items
  alter or create cutterextra in items
  alter or create homebranch in items
  alter or create holdingbranch in items
  alter or create itype in items
removing some unused data...
DELETE FROM userflags where bit = 8
synch'ing borrowers and deletedborrowers
synch'ing items and deleteditems
creating column onloan
creating column cutterextra
creating column itype
synch'ing biblio and deletedbiblio
synch'ing biblioitems and deletedbiblioitems
creating column lcsort
creating column ccode
creating column collectiontitle
creating column collectionissn
creating column collectionvolume
creating column editionstatement
creating column editionresponsibility
Checking for data required in table userflags...
Adding row to userflags:   flagdesc => allow to edit authorities  bit => 14 
defaulton => 0  flag => editauthorities
insert into userflags (flagdesc,bit,defaulton,flag) values (?,?,?,?)Adding row
to userflags:   flagdesc => allow to manage serials subscriptions  bit => 15 
defaulton => 0  flag => serials
insert into userflags (flagdesc,bit,defaulton,flag) values (?,?,?,?)Adding row
to userflags:   flagdesc => allow to access to the reports module  bit => 16 
defaulton => 0  flag => reports
insert into userflags (flagdesc,bit,defaulton,flag) values (?,?,?,?)Checking
for data required in table systempreferences...
Adding row to systempreferences:   options => Calendar|Days  explanation => How
to calculate return dates : Calendar means holidays will be controled, Days
means the return date don't depend on holidays  variable => useDaysMode  value
=> Calendar  type => Choice
insert into systempreferences (options,explanation,variable,value,type) values
(?,?,?,?,?)Adding row to systempreferences:   options => 0|1|2  explanation =>
Set the level of error info sent to the browser. 0=none, 1=some, 2=most 
variable => DebugLevel  value => 0  type => Choice
insert into systempreferences (options,explanation,variable,value,type) values
(?,?,?,?,?)Adding row to systempreferences:   explanation => List all Titles
for borrowers  variable => BorrowersTitles  value => Mr|Mrs|Miss|Ms  type =>
free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => List all mandatory
fields for borrowers  variable => BorrowerMandatoryField  value =>
cardnumber|surname|address  type => free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => The relationships
between a guarantor & a guarantee (separated by | or ,)  variable =>
borrowerRelationship  value => father|mother,grand-mother  type => free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Maximum delay to
pick up a reserved document  variable => ReservesMaxPickUpDelay  value => 10 
type => free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Max delay before
considering the transfer has potentialy a problem  variable =>
TransfersMaxDaysWarning  value => 3  type => free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Are your patrons
members of institutions  variable => memberofinstitution  value => 0  type =>
YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Allow reading record
info retrievable from issues and oldissues tables  variable => ReadingHistory 
value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Allow no debt alert
if the patron is issuing item that accumulate debt  variable =>
IssuingInProcess  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => This Variable allow
or not to return automaticly to his homebranch  variable => AutomaticItemReturn
 value => 1  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Allows patrons to
submit reviews from the opac  variable => reviewson  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => The includes
directory you want for specific look of Koha (includes or includes_npl for
example)  variable => intranet_includes  value => includes  type => Free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => switch to activate
or not Autolocation, if Yes, the Librarian can't change his location, it's
defined by branchip  variable => AutoLocation  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => search among marc
field  variable => expandedSearchOption  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => option to allow
reserves on opac  variable => RequestOnOpac  value => 1  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Enable / Disable
cloud link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl on
the server)  variable => OpacCloud  value => 1  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Enable/Disable
browser link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl
on the server)  variable => OpacBrowser  value => 1  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Enable / Disable the
top issue link on OPAC  variable => OpacTopissue  value => 1  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Enable / Disable the
search authority link on OPAC  variable => OpacAuthorities  value => 1  type =>
YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log cataloguing action.  variable => CataloguingLog  value => 0  type
=> YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log borrowers edition/creation/deletion...  variable => BorrowersLog 
value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log Subscription action  variable => SubscriptionLog  value => 0  type
=> YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log issue.  variable => IssueLog  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log the circulation return  variable => ReturnLog  value => 0  type =>
YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Koha Version 
variable => Version  value => 3.0  type => Free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log all the letter sent  variable => LetterLog  value => 0  type =>
YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want to log fines  variable => FinesLog  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Active this if you
want NOT to use zebra (large libraries should avoid this parameters)  variable
=> NoZebra  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Enter a specific
hash for NoZebra indexes. Enter : 'indexname' => '100a,245a,500*','index2' =>
'...'  variable => NoZebraIndexes  value => 0  type => Free
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Adding row to systempreferences:   explanation => Force Surnames to be
uppercase  variable => uppercasesurnames  value => 0  type => YesNo
insert into systempreferences (explanation,variable,value,type) values
(?,?,?,?)Checking for data required in table authorised_values...
Adding row to authorised_values:   authorised_value => Not enough budget  lib
=> This book it too much expensive  category => SUGGEST
insert into authorised_values (authorised_value,lib,category) values
(?,?,?)Checking for index required...
        Creating index isbn in biblioitems
        Creating index publishercode in biblioitems
        Creating index PRIMARY in userflags
        Creating index basketno in aqorders
        Creating index booksellerid in aqbasket
        Creating index PRIMARY in branchrelations
        Creating index branchcode in branchrelations
        Creating index categorycode in branchrelations
        Creating index PRIMARY in currency
        Creating index ordernumber in aqorderbreakdown
        Creating index bookfundid in aqorderbreakdown
        Creating index shelfnumber in shelfcontents
        Creating index itemnumber in shelfcontents
        Creating index homebranch in items
        Creating index holdingbranch in items
Checking for foreign keys required...
        Creating foreign key borrowers in issues
        Creating foreign key items in issues
        Creating foreign key biblio in biblioitems
        Creating foreign key itemtypes in biblioitems
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`Koha/#sql-e5a_17b`, CONSTRAINT `#sql-e5a_17b_ibfk_2` FOREIGN
KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON UPDATE CASCADE) at
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2093.
====================
    An error occured during :
        alter table biblioitems ADD FOREIGN KEY itemtype (itemtype) REFERENCES
itemtypes (itemtype) on update CASCADE on delete RESTRICT
    It probably means there is something wrong in your DB : a row
(biblioitems.itemtype) refers to a value in itemtypes.itemtype that does not
exist. solve the problem and run updater again (or just the previous SQL
statement).
    You can find those values with select
        biblioitems.* from biblioitems where itemtype not in (select itemtype
from itemtypes)
    ====================

        Creating foreign key borrowers in accountlines
        Creating foreign key items in accountlines
        Creating foreign key auth_types in auth_tag_structure
        Creating foreign key aqbasket in aqorders
        Creating foreign key biblio in aqorders
        Creating foreign key borrowers in reserves
        Creating foreign key biblio in reserves
        Creating foreign key items in reserves
        Creating foreign key branches in reserves
        Creating foreign key currency in aqbooksellers
        Creating foreign key currency in aqbooksellers
        Creating foreign key aqbooksellers in aqbasket
        Creating foreign key categories in borrowers
        Creating foreign key branches in borrowers
        Creating foreign key branches in branchrelations
        Creating foreign key branchcategories in branchrelations
        Creating foreign key aqorders in aqorderbreakdown
        Creating foreign key aqbookfund in aqorderbreakdown
        Creating foreign key virtualshelf in shelfcontents
DBD::mysql::db do failed: Table 'Koha.virtualshelf' doesn't exist at
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2087.
SQL ERROR: delete from shelfcontents where shelfnumber not in (select
shelfnumber from virtualshelf) : DBI::db=HASH(0x8975b10)->err 
DBD::mysql::db do failed: Can't create table './Koha/#sql-e5a_17b.frm' (errno:
150) at koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2093.
====================
    An error occured during :
        alter table shelfcontents ADD FOREIGN KEY shelfnumber (shelfnumber)
REFERENCES virtualshelf (shelfnumber) on update CASCADE on delete CASCADE
    It probably means there is something wrong in your DB : a row
(shelfcontents.shelfnumber) refers to a value in virtualshelf.shelfnumber that
does not exist. solve the problem and run updater again (or just the previous
SQL statement).
    You can find those values with select
        shelfcontents.* from shelfcontents where shelfnumber not in (select
shelfnumber from virtualshelf)
    ====================

        Creating foreign key items in shelfcontents
        Creating foreign key categories in deletedborrowers
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`Koha/#sql-e5a_17b`, CONSTRAINT `#sql-e5a_17b_ibfk_1` FOREIGN
KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2093.
====================
    An error occured during :
        alter table deletedborrowers ADD FOREIGN KEY categorycode
(categorycode) REFERENCES categories (categorycode) on update RESTRICT on
delete RESTRICT
    It probably means there is something wrong in your DB : a row
(deletedborrowers.categorycode) refers to a value in categories.categorycode
that does not exist. solve the problem and run updater again (or just the
previous SQL statement).
    You can find those values with select
        deletedborrowers.* from deletedborrowers where categorycode not in
(select categorycode from categories)
    ====================

        Creating foreign key branches in deletedborrowers
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`Koha/#sql-e5a_17b`, CONSTRAINT `#sql-e5a_17b_ibfk_1` FOREIGN
KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) at
koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2093.
====================
    An error occured during :
        alter table deletedborrowers ADD FOREIGN KEY branchcode (branchcode)
REFERENCES branches (branchcode) on update RESTRICT on delete RESTRICT
    It probably means there is something wrong in your DB : a row
(deletedborrowers.branchcode) refers to a value in branches.branchcode that
does not exist. solve the problem and run updater again (or just the previous
SQL statement).
    You can find those values with select
        deletedborrowers.* from deletedborrowers where branchcode not in
(select branchcode from branches)
    ====================

        Creating foreign key branches in branchtransfers
        Creating foreign key branches in branchtransfers
        Creating foreign key items in branchtransfers
        Creating foreign key biblioitems in items
        Creating foreign key branches in items
        Creating foreign key branches in items
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`Koha/#sql-e5a_17b`, CONSTRAINT `#sql-e5a_17b_ibfk_3` FOREIGN
KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE)
at koha-3.00.00-alpha/installer/data/mysql/update22to30.pl line 2093.
====================
    An error occured during :
        alter table items ADD FOREIGN KEY holdingbranch (holdingbranch)
REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT
    It probably means there is something wrong in your DB : a row
(items.holdingbranch) refers to a value in branches.branchcode that does not
exist. solve the problem and run updater again (or just the previous SQL
statement).
    You can find those values with select
        items.* from items where holdingbranch not in (select branchcode from
branches)
    ====================

    moving biblioframework to biblio table
done / 5803
deleting suburb field in borrowers...
deleting altstreetaddress field in borrowers...
deleting altsuburb field in borrowers...
deleting altcity field in borrowers...
deleting studentnumber field in borrowers...
deleting school field in borrowers...
deleting area field in borrowers...
deleting preferredcont field in borrowers...
deleting suburb field in deletedborrowers...
deleting altstreetaddress field in deletedborrowers...
deleting altsuburb field in deletedborrowers...
deleting altcity field in deletedborrowers...
deleting studentnumber field in deletedborrowers...
deleting school field in deletedborrowers...
deleting area field in deletedborrowers...
deleting preferredcont field in deletedborrowers...
upgrade to Koha 3.0 done




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.