[Koha] Upgrading from 2.2 to 3.0, not so smooth...

[Jesse Weaver]

On Wed, Dec 10, 2008 at 4:17 AM, PasiK <pasi.korkalo at oululainen.com> wrote:

>
> We tried to upgrade our Koha system from 2.2 to 3.0. Installation went ok,
> but data-conversion failed completely. Here's the error-log from
> update22to20.pl:
>
> Adding textmessaging field to deletedborrowers table...
> DBD::mysql::st execute failed: Unknown column 'faxnumber' in
> 'deletedborrowers' at ./update22to30.pl line 3071.
> **Error : DBI::st=HASH(0x88f6500)->errstr
> altering borrowers zipcode to zipcode
> altering deletedborrowers zipcode to zipcode
> altering deletedborrowers homezipcode to B_zipcode
> DBD::mysql::db do failed: Duplicate column name 'B_zipcode' at
> ./update22to30.pl line 3104.
> removing some unused fields...
>  alter or create notify_id in accountlines
>  alter or create notify_level in accountlines
>  alter or create accountno in accountlines
>  alter or create booksellerid in aqbasket
>  alter or create bookfundid in aqbookfund
>  alter or create branchcode in aqbookfund
>  alter or create id in aqbooksellers
> DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl
> line 3271.
> Error while executing: alter table aqbooksellers change `id` `id` int(11)
> NOT NULL PRIMARY KEY auto_increment   at ./update22to30.pl line 3271.
>  alter or create currency in aqbooksellers
>  alter or create listprice in aqbooksellers
>  alter or create invoiceprice in aqbooksellers
>  alter or create invoicedisc in aqbooksellers
>  alter or create bookfundid in aqbudget
>  alter or create bookfundid in aqorderbreakdown
>  alter or create ordernumber in aqorderdelivery
>  alter or create currency in aqorders
>  alter or create authtypecode in auth_header
>  alter or create datecreated in auth_header
>  alter or create origincode in auth_header
>  alter or create authtypecode in auth_subfield_structure
>  alter or create tagfield in auth_subfield_structure
>  alter or create tagsubfield in auth_subfield_structure
>  alter or create liblibrarian in auth_subfield_structure
>  alter or create libopac in auth_subfield_structure
>  alter or create authorised_value in auth_subfield_structure
>  alter or create value_builder in auth_subfield_structure
>  alter or create seealso in auth_subfield_structure
>  alter or create kohafield in auth_subfield_structure
>  alter or create frameworkcode in auth_subfield_structure
>  alter or create authtypecode in auth_tag_structure
>  alter or create tagfield in auth_tag_structure
>  alter or create liblibrarian in auth_tag_structure
>  alter or create libopac in auth_tag_structure
>  alter or create authorised_value in auth_tag_structure
>  alter or create auth_tag_to_report in auth_types
>  alter or create summary in auth_types
>  alter or create category in authorised_values
>  alter or create authorised_value in authorised_values
>  alter or create lib in authorised_values
>  alter or create frameworkcode in biblio
>  alter or create frameworkcode in biblio_framework
>  alter or create frameworktext in biblio_framework
>  alter or create itemtype 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 shelfname in bookshelf
>  alter or create owner in bookshelf
>  alter or create category in bookshelf
>  alter or create cardnumber in borrowers
>  alter or create surname in borrowers
>  alter or create branchcode in borrowers
>  alter or create categorycode in borrowers
>  alter or create address in borrowers
>  alter or create city in borrowers
>  alter or create sex in borrowers
>  alter or create branchcode in branches
>  alter or create branchname in branches
>  alter or create branchcode in branchrelations
>  alter or create categorycode in branchrelations
>  alter or create frombranch in branchtransfers
>  alter or create tobranch in branchtransfers
>  alter or create category_type in categories
>  alter or create categorycode in categories
> DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl
> line 3271.
> Error while executing: alter table categories change `categorycode`
> `categorycode` varchar(10) NOT NULL PRIMARY KEY  default ''  at
> ./update22to30.pl line 3271.
>  alter or create frameworkcode in deletedbiblio
>  alter or create itemtype in deletedbiblioitems
>  alter or create dewey in deletedbiblioitems
>  alter or create itemtype in deletedbiblioitems
>  alter or create branchcode in deletedborrowers
>  alter or create categorycode in deletedborrowers
>  alter or create B_zipcode in deletedborrowers
>  alter or create zipcode in deletedborrowers
>  alter or create address in deletedborrowers
>  alter or create city in deletedborrowers
>  alter or create surname in deletedborrowers
>  alter or create streetnumber in deletedborrowers
>  alter or create streettype in deletedborrowers
>  alter or create sex in deletedborrowers
>  alter or create borrowernumber in issues
>  alter or create itemnumber in issues
>  alter or create return in issues
>  alter or create categorycode in issuingrules
>  alter or create branchcode in issuingrules
>  alter or create itemtype in issuingrules
>  alter or create homebranch in items
>  alter or create holdingbranch in items
>  alter or create itemtype in itemtypes
> DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl
> line 3271.
> Error while executing: alter table itemtypes change `itemtype` `itemtype`
> varchar(10) NOT NULL PRIMARY KEY  default ''  at ./update22to30.pl line
> 3271.
>  alter or create description in itemtypes
>  alter or create summary in itemtypes
>  alter or create marc in marc_breeding
>  alter or create defaultvalue in marc_subfield_structure
>  alter or create authtypecode in marc_subfield_structure
>  alter or create tagfield in marc_subfield_structure
>  alter or create tagsubfield in marc_subfield_structure
>  alter or create authorised_value in marc_subfield_structure
>  alter or create seealso in marc_subfield_structure
>  alter or create tagfield in marc_tag_structure
>  alter or create liblibrarian in marc_tag_structure
>  alter or create libopac in marc_tag_structure
>  alter or create authorised_value in marc_tag_structure
>  alter or create frameworkcode in marc_tag_structure
>  alter or create expirationdate in opac_news
>  alter or create printername in printers
>  alter or create printqueue in printers
>  alter or create printtype in printers
>  alter or create reservedate in reserveconstraints
>  alter or create constrainttype in reserves
>  alter or create branchcode in reserves
>  alter or create planneddate in serial
>  alter or create notes in serial
>  alter or create branch in statistics
>  alter or create datetime in statistics
>  alter or create startdate in subscription
>  alter or create histstartdate in subscriptionhistory
>  alter or create enddate in subscriptionhistory
> removing some unused data...
> DELETE FROM userflags where bit = 8
> synch'ing borrowers and deletedborrowers
> synch'ing items and deleteditems
> synch'ing biblio and deletedbiblio
> synch'ing biblioitems and deletedbiblioitems
> Updating publisheddate
> Checking for data required in table userflags...
> Checking for data required in table systempreferences...
> 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 borrowernumber in borrowers
> DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl
> line 3408.
> Error alter table borrowers ADD PRIMARY KEY (borrowernumber) :
> DBI::db=HASH(0x885d484)->err
> Checking for foreign keys required...
>        Creating foreign key items in accountlines
>        Creating foreign key aqbookfund in aqorderbreakdown
>        Creating foreign key biblio in aqorders
>        Creating foreign key branches in borrowers
>        Creating foreign key branchcategories in branchrelations
>        Creating foreign key items in branchtransfers
>        Creating foreign key items in issues
>        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-a58_52`, CONSTRAINT `#sql-a58_52_ibfk_5`
> FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON
> UPDATE
> CASCADE) at ./update22to30.pl line 3442.
> ====================
>    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)
>    ====================
>
>        Creating foreign key biblio in reserves
>        Creating foreign key items in reserves
>        Creating foreign key branches in reserves
>        Creating foreign key bookshelf in shelfcontents
> DBD::mysql::db do failed: Can't DROP 'borrowernumber'; check that
> column/key
> exists at ./update22to30.pl line 3531.
> upgrade to Koha 3.0 done
>
> At the moment we are able to access Koha via browser, but there's nothing
> there. Ideas for fixing this?
> --
> View this message in context:
> http://www.nabble.com/Upgrading-from-2.2-to-3.0%2C-not-so-smooth...-tp20933358p20933358.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

What version of MySQL are you running?

-- 
Jesse Weaver
Software Developer, LibLime
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081210/acb443ca/attachment-0001.htm