<br><br><div class="gmail_quote">On Wed, Dec 10, 2008 at 4:17 AM, PasiK <span dir="ltr"><<a href="mailto:pasi.korkalo@oululainen.com">pasi.korkalo@oululainen.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d"><br>
We tried to upgrade our Koha system from 2.2 to 3.0. Installation went ok,<br>
</div>but data-conversion failed completely. Here's the error-log from<br>
<div><div></div><div class="Wj3C7c">update22to20.pl:<br>
<br>
Adding textmessaging field to deletedborrowers table...<br>
DBD::mysql::st execute failed: Unknown column 'faxnumber' in<br>
'deletedborrowers' at ./update22to30.pl line 3071.<br>
**Error : DBI::st=HASH(0x88f6500)->errstr<br>
altering borrowers zipcode to zipcode<br>
altering deletedborrowers zipcode to zipcode<br>
altering deletedborrowers homezipcode to B_zipcode<br>
DBD::mysql::db do failed: Duplicate column name 'B_zipcode' at<br>
./update22to30.pl line 3104.<br>
removing some unused fields...<br>
alter or create notify_id in accountlines<br>
alter or create notify_level in accountlines<br>
alter or create accountno in accountlines<br>
alter or create booksellerid in aqbasket<br>
alter or create bookfundid in aqbookfund<br>
alter or create branchcode in aqbookfund<br>
alter or create id in aqbooksellers<br>
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl<br>
line 3271.<br>
Error while executing: alter table aqbooksellers change `id` `id` int(11)<br>
NOT NULL PRIMARY KEY auto_increment at ./update22to30.pl line 3271.<br>
alter or create currency in aqbooksellers<br>
alter or create listprice in aqbooksellers<br>
alter or create invoiceprice in aqbooksellers<br>
alter or create invoicedisc in aqbooksellers<br>
alter or create bookfundid in aqbudget<br>
alter or create bookfundid in aqorderbreakdown<br>
alter or create ordernumber in aqorderdelivery<br>
alter or create currency in aqorders<br>
alter or create authtypecode in auth_header<br>
alter or create datecreated in auth_header<br>
alter or create origincode in auth_header<br>
alter or create authtypecode in auth_subfield_structure<br>
alter or create tagfield in auth_subfield_structure<br>
alter or create tagsubfield in auth_subfield_structure<br>
alter or create liblibrarian in auth_subfield_structure<br>
alter or create libopac in auth_subfield_structure<br>
alter or create authorised_value in auth_subfield_structure<br>
alter or create value_builder in auth_subfield_structure<br>
alter or create seealso in auth_subfield_structure<br>
alter or create kohafield in auth_subfield_structure<br>
alter or create frameworkcode in auth_subfield_structure<br>
alter or create authtypecode in auth_tag_structure<br>
alter or create tagfield in auth_tag_structure<br>
alter or create liblibrarian in auth_tag_structure<br>
alter or create libopac in auth_tag_structure<br>
alter or create authorised_value in auth_tag_structure<br>
alter or create auth_tag_to_report in auth_types<br>
alter or create summary in auth_types<br>
alter or create category in authorised_values<br>
alter or create authorised_value in authorised_values<br>
alter or create lib in authorised_values<br>
alter or create frameworkcode in biblio<br>
alter or create frameworkcode in biblio_framework<br>
alter or create frameworktext in biblio_framework<br>
alter or create itemtype in biblioitems<br>
alter or create dewey in biblioitems<br>
alter or create publicationyear in biblioitems<br>
alter or create collectiontitle in biblioitems<br>
alter or create collectionissn in biblioitems<br>
alter or create collectionvolume in biblioitems<br>
alter or create editionstatement in biblioitems<br>
alter or create editionresponsibility in biblioitems<br>
alter or create shelfname in bookshelf<br>
alter or create owner in bookshelf<br>
alter or create category in bookshelf<br>
alter or create cardnumber in borrowers<br>
alter or create surname in borrowers<br>
alter or create branchcode in borrowers<br>
alter or create categorycode in borrowers<br>
alter or create address in borrowers<br>
alter or create city in borrowers<br>
alter or create sex in borrowers<br>
alter or create branchcode in branches<br>
alter or create branchname in branches<br>
alter or create branchcode in branchrelations<br>
alter or create categorycode in branchrelations<br>
alter or create frombranch in branchtransfers<br>
alter or create tobranch in branchtransfers<br>
alter or create category_type in categories<br>
alter or create categorycode in categories<br>
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl<br>
line 3271.<br>
Error while executing: alter table categories change `categorycode`<br>
`categorycode` varchar(10) NOT NULL PRIMARY KEY default '' at<br>
./update22to30.pl line 3271.<br>
alter or create frameworkcode in deletedbiblio<br>
alter or create itemtype in deletedbiblioitems<br>
alter or create dewey in deletedbiblioitems<br>
alter or create itemtype in deletedbiblioitems<br>
alter or create branchcode in deletedborrowers<br>
alter or create categorycode in deletedborrowers<br>
alter or create B_zipcode in deletedborrowers<br>
alter or create zipcode in deletedborrowers<br>
alter or create address in deletedborrowers<br>
alter or create city in deletedborrowers<br>
alter or create surname in deletedborrowers<br>
alter or create streetnumber in deletedborrowers<br>
alter or create streettype in deletedborrowers<br>
alter or create sex in deletedborrowers<br>
alter or create borrowernumber in issues<br>
alter or create itemnumber in issues<br>
alter or create return in issues<br>
alter or create categorycode in issuingrules<br>
alter or create branchcode in issuingrules<br>
alter or create itemtype in issuingrules<br>
alter or create homebranch in items<br>
alter or create holdingbranch in items<br>
alter or create itemtype in itemtypes<br>
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl<br>
line 3271.<br>
Error while executing: alter table itemtypes change `itemtype` `itemtype`<br>
varchar(10) NOT NULL PRIMARY KEY default '' at ./update22to30.pl line<br>
3271.<br>
alter or create description in itemtypes<br>
alter or create summary in itemtypes<br>
alter or create marc in marc_breeding<br>
alter or create defaultvalue in marc_subfield_structure<br>
alter or create authtypecode in marc_subfield_structure<br>
alter or create tagfield in marc_subfield_structure<br>
alter or create tagsubfield in marc_subfield_structure<br>
alter or create authorised_value in marc_subfield_structure<br>
alter or create seealso in marc_subfield_structure<br>
alter or create tagfield in marc_tag_structure<br>
alter or create liblibrarian in marc_tag_structure<br>
alter or create libopac in marc_tag_structure<br>
alter or create authorised_value in marc_tag_structure<br>
alter or create frameworkcode in marc_tag_structure<br>
alter or create expirationdate in opac_news<br>
alter or create printername in printers<br>
alter or create printqueue in printers<br>
alter or create printtype in printers<br>
alter or create reservedate in reserveconstraints<br>
alter or create constrainttype in reserves<br>
alter or create branchcode in reserves<br>
alter or create planneddate in serial<br>
alter or create notes in serial<br>
alter or create branch in statistics<br>
alter or create datetime in statistics<br>
alter or create startdate in subscription<br>
alter or create histstartdate in subscriptionhistory<br>
alter or create enddate in subscriptionhistory<br>
removing some unused data...<br>
DELETE FROM userflags where bit = 8<br>
synch'ing borrowers and deletedborrowers<br>
synch'ing items and deleteditems<br>
synch'ing biblio and deletedbiblio<br>
synch'ing biblioitems and deletedbiblioitems<br>
Updating publisheddate<br>
Checking for data required in table userflags...<br>
Checking for data required in table systempreferences...<br>
Checking for data required in table authorised_values...<br>
Adding row to authorised_values: authorised_value => Not enough budget<br>
lib => This book it too much expensive category => SUGGEST<br>
insert into authorised_values (authorised_value,lib,category) values<br>
(?,?,?)Checking for index required...<br>
Creating index borrowernumber in borrowers<br>
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl<br>
line 3408.<br>
Error alter table borrowers ADD PRIMARY KEY (borrowernumber) :<br>
DBI::db=HASH(0x885d484)->err<br>
Checking for foreign keys required...<br>
Creating foreign key items in accountlines<br>
Creating foreign key aqbookfund in aqorderbreakdown<br>
Creating foreign key biblio in aqorders<br>
Creating foreign key branches in borrowers<br>
Creating foreign key branchcategories in branchrelations<br>
Creating foreign key items in branchtransfers<br>
Creating foreign key items in issues<br>
Creating foreign key branches in items<br>
Creating foreign key branches in items<br>
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key<br>
constraint fails (`Koha/#sql-a58_52`, CONSTRAINT `#sql-a58_52_ibfk_5`<br>
FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE<br>
CASCADE) at ./update22to30.pl line 3442.<br>
====================<br>
An error occured during :<br>
alter table items ADD FOREIGN KEY holdingbranch (holdingbranch)<br>
REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT<br>
It probably means there is something wrong in your DB : a row<br>
(items.holdingbranch) refers to a value in branches.branchcode that does not<br>
exist. solve the problem and run updater again (or just the previous SQL<br>
statement).<br>
You can find those values with select<br>
items.* from items where holdingbranch not in (select branchcode from<br>
branches)<br>
====================<br>
<br>
Creating foreign key biblio in reserves<br>
Creating foreign key items in reserves<br>
Creating foreign key branches in reserves<br>
Creating foreign key bookshelf in shelfcontents<br>
DBD::mysql::db do failed: Can't DROP 'borrowernumber'; check that column/key<br>
exists at ./update22to30.pl line 3531.<br>
upgrade to Koha 3.0 done<br>
<br>
</div></div>At the moment we are able to access Koha via browser, but there's nothing<br>
there. Ideas for fixing this?<br>
<font color="#888888">--<br>
View this message in context: <a href="http://www.nabble.com/Upgrading-from-2.2-to-3.0%2C-not-so-smooth...-tp20933358p20933358.html" target="_blank">http://www.nabble.com/Upgrading-from-2.2-to-3.0%2C-not-so-smooth...-tp20933358p20933358.html</a><br>
</font><div><div></div><div class="Wj3C7c">Sent from the Koha - Discuss mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></div></blockquote></div><br>What version of MySQL are you running?<br clear="all"><br>-- <br>Jesse Weaver<br>Software Developer, LibLime<br>