February 2008 - Koha-bugs - lists.koha-community.org

[Bug 1820] output of update22to30.pl on Ubuntu 6.06
by bugzilla-daemon＠pippin.metavore.com 08 Feb '08

08 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1820 ------- Comment #2 from galen.charlton(a)liblime.com 2008-02-08 14:47 ------- Of the errors reported in your attachment, the ones regarding deletedbiblio are the ones of most interest. Could you add the output of the mysql commands "desc deletedbiblio;" and "desc biblio;" to this bug. Thanks. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1820] output of update22to30.pl on Ubuntu 6.06
by bugzilla-daemon＠pippin.metavore.com 08 Feb '08

08 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1820 matthew.metzger(a)cono.org changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |matthew.metzger(a)cono.org ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1820] output of update22to30.pl on Ubuntu 6.06
by bugzilla-daemon＠pippin.metavore.com 08 Feb '08

08 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1820 ------- Comment #1 from matthew.metzger(a)cono.org 2008-02-08 08:55 ------- Created an attachment (id=167) --> (http://bugs.koha.org/cgi-bin/bugzilla/attachment.cgi?id=167&action=view) errors listed at step 3 of the web installer "updating database structure" gmcharlt on IRC asked me to add these errors to this bug number ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1820] New: output of update22to30.pl on Ubuntu 6.06
by bugzilla-daemon＠pippin.metavore.com 08 Feb '08

08 Feb '08

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: jmf(a)liblime.com ReportedBy: matthew.metzger(a)cono.org QAContact: koha-bugs(a)nongnu.org gmcharlt on the koha IRC channel suggested I post the output of update22to30.pl here. sysadmin@document-server:~$ 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.

1 0

[Bug 1625] Pass title, subtitle, and author variables to MARC views
by bugzilla-daemon＠pippin.metavore.com 07 Feb '08

07 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1625 ------- Comment #1 from oleonard(a)myacpl.org 2008-02-07 11:22 ------- ...and the same should be done for addbiblio.pl, which should at least show the title. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1819] New: deletion of a holiday does not work
by bugzilla-daemon＠pippin.metavore.com 07 Feb '08

07 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1819 Summary: deletion of a holiday does not work Product: Koha Version: HEAD Platform: PC OS/Version: All Status: NEW Severity: major Priority: P3 Component: Holidays AssignedTo: henridamien(a)koha-fr.org ReportedBy: paul.poulain(a)free.fr QAContact: koha-bugs(a)nongnu.org - tools/holiday.pl - create a holiday - try to delete it => impossible ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1818] New: problem in language selector
by bugzilla-daemon＠pippin.metavore.com 07 Feb '08

07 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1818 Summary: problem in language selector Product: Koha Version: HEAD Platform: PC OS/Version: All Status: NEW Severity: critical Priority: P3 Component: I18N/L10N AssignedTo: jmf(a)liblime.com ReportedBy: paul.poulain(a)free.fr QAContact: koha-bugs(a)nongnu.org In koha-news.pl, the language selector display an empty line for each language. Same problem for the language selector in language syspref. I've investigated a little bit and have found that in language => $language->{'language_code'}, language_code does not exist in the hash. Seems we should use language or rfc4646_subtag. However, i'm not sure to understand everything of the new language handling, so I don't try to fix the problem ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1675] OPAC large image value saved but not displayed
by bugzilla-daemon＠pippin.metavore.com 07 Feb '08

07 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1675 ------- Comment #2 from oleonard(a)myacpl.org 2008-02-07 05:56 ------- The issue with opacsmallimage has been fixed. opaclargeimage is an obsolete preference and should be removed. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1816] stage-marc-import does not report progress or completion on large files
by bugzilla-daemon＠pippin.metavore.com 06 Feb '08

06 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1816 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|chris.cormack(a)liblime.com |galen.charlton(a)liblime.com ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1817] New: pagination links disrupt display on large result sets
by bugzilla-daemon＠pippin.metavore.com 06 Feb '08

06 Feb '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1817 Summary: pagination links disrupt display on large result sets Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P3 Component: Templates AssignedTo: oleonard(a)myacpl.org ReportedBy: rch(a)liblime.com QAContact: koha-bugs(a)nongnu.org Especially noticeable in tools/manage-marc-import.pl ... A large number of pages causes a big block of page links to usurp the page. Perhaps there's a yui component that can handle this for us ? Or a two-level pagination display. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0