[Koha] Koha upgrade to from 3.0.6 to 3.2 and Zebra

Hugo Rodrigues hugoseixasr at gmail.com
Thu Dec 16 05:50:34 NZDT 2010


Dear friends,

still trying to get zebra running.
I chose to do a clean test install with latest version through apt-get
method.

Now, when I do rebuild_zebra for 1st time my only error message is

16:41:11-15/12 zebraidx(13866) [warn] Record didn't contain match fields in
(bib1,Local-number)

Any suggestions?

More informations and details below and attached if you have the time.

Thank you for your patience.

Hugo Rodrigues, librarian
Metropolitana, Lisbon, Portugal

Unimarc

Server information
Koha version: 3.03.00.004
OS version ('uname -a'): Linux koha 2.6.32-26-generic #48-Ubuntu SMP Wed Nov
24 09:00:03 UTC 2010 i686 GNU/Linux
Perl interpreter: /usr/bin/perl
Perl version: 5.010001
Perl @INC: /usr/share/koha/lib
/etc/perl
/usr/local/lib/perl/5.10.1
/usr/local/share/perl/5.10.1
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.
MySQL version: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486)
using readline 6.1
Apache version: Server version: Apache/2.2.14 (Ubuntu)
Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free
software, covered by the GNU General Public License, and you are welcome to
change it and/or distribute copies of it under certain conditions. SHA1 ID:
419ad759807269fdfa379799a051ed3a551c6541 Using ICU








2010/12/9 Robin Sheat <robin at catalyst.net.nz>

> Chris Nighswonger schreef op do 09-12-2010 om 08:27 [-0500]:
> >         11:16:14-09/12 zebraidx(2403) [warn] zebra_lock_create fail
> >         fname=/var/lock/koha/zebradb/biblios/norm..LCK [No such file
> >         or directory]
> >         11:16:14-09/12 zebraidx(2403) [warn] zebra_lock_create fail
> >         fname=/var/lock/koha/zebradb/biblios/shadow..LCK [No such file
> >         or directory]
> >         11:16:14-09/12 zebraidx(2403) [fatal] Could not select
> >         database biblios errCode=109
> >
> >
>
> > Especially #4 as this looks to be a permissions problem.
>
> I would actually suggest that the directories are missing (otherwise it
> would say 'permission denied'.)
>
> try running:
> sudo mkdir -p /var/lock/koha/zebradb/biblios
> sudo mkdir -p /var/lock/koha/zebradb/authorities
> sudo chown koha:koha /var/lock/koha/zebradb/biblios
> sudo chown koha:koha /var/lock/koha/zebradb/authorities
>
> (replace the koha:koha with the name and group that your zebra processes
> run as.)
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101215/ea039758/attachment-0001.htm 
-------------- next part --------------
Update report :

    * Upgrade to 3.01.00.000 done (start of 3.1)
    * Upgrade to 3.01.00.001 done (add hold_fill_targets table and a column to tmp_holdsqueue)
    * Upgrade to 3.01.00.002 done (bug 2582: set null issues.issuedate to lastreneweddate)
    * Upgrade to 3.01.00.003 done (add new syspref)
    * Upgrade to 3.01.00.004 done (added OPACDisplayRequestPriority system preference)
    * Upgrade to 3.01.00.005 done (Add letter for holds notifications)
    * Upgrade to 3.01.00.006 done (add index on biblioitems.issn)
    * Upgrade to 3.01.00.007 done (fix display of many sysprefs)
    * Upgrade to 3.01.00.008 done (added branch_transfer_limits table and UseBranchTransferLimits system preference)
    * Upgrade to 3.01.00.009 done (added subpermissions for circulate permission)
    * Upgrade to 3.01.00.010 done (bug 2687: increase length of borrower attribute fields)
    * Upgrade to 3.01.00.011 done (removed bogus intranetuserjs syspref)
    * Upgrade to 3.01.00.012 done (Add tables and system preferences for holds policies)
    * Upgrade to 3.01.00.013 done (data for Email Checkout Slips project)
    * Upgrade to 3.01.00.014 done ( Updated table for Branch Transfer Limits)
    * Upgrade to 3.01.00.015 done (added Syndetics Enhanced Content system preferences)
    * Upgrade to 3.01.00.016 done (Added Babeltheque syspref)
    * Upgrade to 3.01.00.017 done ( Updated table for Serials Display)
    * Upgrade to 3.01.00.018 done (added deletedborrowers.smsalertnumber, missed in 3.00.00.091)
    * Upgrade to 3.01.00.019 done (adding OPACShowCheckoutName systempref)
    * Upgrade to 3.01.00.020 done (adding LibraryThing for Libraries sysprefs)
    * Upgrade to 3.01.00.021 done (adding OPACAmazonReviews syspref)
    * Upgrade to 3.01.00.022 done (bug 2945: increase size of labels_conf.formatstring)
    * Upgrade to 3.01.00.023 done (bug 2765: increase width of isbn column in several tables)
    * Upgrade to 3.01.00.024 done (change labels.batch_id from varchar to int)
    * Upgrade to 3.01.00.025 done (added ceilingDueDate system preference)
    * Upgrade to 3.01.00.026 done (added numReturnedItemsToShow system preference)
    * Upgrade to 3.01.00.027 done (Increased size of zebraqueue biblio_auth_number to address bug 3148.)
    * Upgrade to 3.01.00.028 done (added AmazonReviews)
    * Upgrade to 3.01.00.029 done (fixed bug 2599: using Spanish search limit retrieves Russian results)
    * Upgrade to 3.01.00.030 done (added AllowNotForLoanOverride system preference)
    * Upgrade to 3.01.00.031 done (fix column widths in branch_transfer_limits)
    * Upgrade to 3.01.00.032 done (Change the field)
    * Upgrade to 3.01.00.033 done (DB changes to allow patron category defaults for messaging preferences)
    * Upgrade to 3.01.00.034 done (Adding graceperiod column to subscription table)
    * Upgrade to 3.01.00.035 done (Adding location to subscription table)
    * Upgrade to 3.01.00.036 done (new viewISBD, viewLabeledMARC, viewMARC sysprefs and tweak IntranetBiblioDefaultView)
    * Upgrade to 3.01.00.037 done (added FilterBeforeOverdueReport syspref and new index on authorised_values)
    * Upgrade to 3.01.00.038 done (add ZIP, city, country, URL, and notes column to branches)
    * Upgrade to 3.01.00.039 done (added SpineLabelFormat and SpineLabelAutoPrint sysprefs)
    * Upgrade to 3.01.00.040 done (AllowHoldDateInFuture and OPACAllowHoldDateInFuture sysprefs)
    * Upgrade to 3.01.00.041 done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.)
    * Upgrade to 3.01.00.042 done (added OPACFineNoRenewals syspref)
    * Upgrade to 3.01.00.043 done (amended Item added NewItemsDefaultLocation, InProcessingToShelvingCart, ReturnToShelvingCart sysprefs)
    * Upgrade to 3.01.00.044 done (added DisplayClearScreenButton system preference)
    * Upgrade to 3.01.00.045 done (added a preference to hide the patrons name in the staff catalog)Upgrade to 3.01.00.046 done (add country and B_country to borrowers)
    * Upgrade to 3.01.00.047 done (bug 2761: change max length of itemcallnumber to 255 from 30)
    * Upgrade to 3.01.00.048 done (bug 2611: fix spelling/capitalization in permission flag descriptions)
    * Upgrade to 3.01.00.049 done (bug 2611: changed catalogue to catalog per the standard)
    * Upgrade to 3.01.00.050 done (bug 1934: Add OPACSearchForTitleIn syspref)
    * Upgrade to 3.01.00.051 done (fixed typos in new sysprefs)
    * Upgrade to 3.01.00.052 done (bug 3481: add permanent_location column to deleteditems)
    * Upgrade to 3.01.00.053 done (Migrated labels tables and data to new schema.) NOTE: All existing label batches have been assigned to the first branch in the list of branches. This is ONLY true of migrated label batches.
    * Upgrade to 3.01.00.054 done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers)
    * Upgrade to 3.01.00.055 done (changed OPACSearchForTitleIn per requests in bug 1934)
    * Upgrade to 3.01.00.056 done (Bug 1172 : Add OPACPatronDetails syspref)
    * Upgrade to 3.01.00.057 done (Bug 2576 : Add OPACFinesTab syspref)
    * Upgrade to 3.01.00.058 done (Added primary keys to language tables)
    * Upgrade to 3.01.00.059 done (added DisplayOPACiconsXSLT sysprefs)
    * Upgrade to 3.01.00.060 done ( Added AllowAllMessageDeletion syspref and messages table )
    * Upgrade to 3.01.00.061 done ( Added ShowPatronImageInWebBasedSelfCheck system preference )
    * Upgrade to 3.01.00.062 done (added csv export profiles)
    * Upgrade to 3.01.00.065 done (Moving allowed renewals from itemtypes to issuingrule)
    * Upgrade to 3.01.00.066 done (Moving max allowed reserves from system preference to issuingrule)
    * Upgrade to 3.01.00.067 done (added permissions for batch modification and deletion)
    * Upgrade done (Adding finedays in issuingrules table)
    * Upgrade done (added OPAC search history preference and table)
    * Upgrade done (Added a lib_opac field in authorised_values table)
    * Upgrade to 3.01.00.071 done ( Adding enddate to subscription)
    * Upgrade to 3.01.00.072 done (add new syspref and column in borrowers)
    * Upgrade to 3.01.00.073 done (adding aqcontract table)
    * Upgrade to 3.01.00.074 done (edit aqbasket table done)
    * Upgrade to 3.01.00.075 done (adding uncertainprices)
    * Upgrade to 3.01.00.076 done (adding basketgroups)
    * Upgrade to 3.01.00.077 done (Adding new aqbudgetperiods, aqbudgets and aqbudget_planning tables )
    * Upgrade to 3.01.00.078 done (adds 'budget_period_total' column to aqbudgetperiods table)
    * Upgrade to 3.01.00.079 done (adds 'active' column to currencies table)
    * Upgrade to 3.01.00.080 done (adds permissions for the acquisitions module)
    * Upgrade to 3.01.00.081 done (added per-supplier gstrate setting)
    * Upgrade to 3.01.00.082 done (adding ReservesNeedReturns systempref, in circulation)
    * Upgrade to 3.01.00.083 done (New aqorders_items table for acqui)
    * Upgrade to 3.01.00.084 done (CurrencyFormat syspref added)
    * Upgrade to 3.01.00.085 done update budget_id size that should not be a tinyint
    * Upgrade to 3.01.00.086 done SuggestionsUpgrade to 3.01.00.087 done drop column budget_amount_sublevel from aqbudgets
    * Upgrade to 3.01.00.088 done (intranetbookbag syspref added)
    * Upgrade to 3.01.00.090 done (granular permissions for guided reports added)
    * Upgrade to 3.01.00.091 done (opac-detail default tag updated)
    * Upgrade to 3.01.00.092 done (Added RoutingListAddReserves syspref)
    * Upgrade to 3.01.00.093 done (added index to ISSN)
    * Upgrade to 3.01.00.094 done (adding deliveryplace deliverycomment to basketgroups)
    * Upgrade to 3.01.00.095 done (stocknumber field added)
    * Upgrade to 3.01.00.096 done (PDF orders system preferences added and updated)
    * Upgrade to 3.01.00.097 done (Adding billingplace to aqbasketgroups)
    * Upgrade to 3.01.00.098 done (changing frameworkcode length in auth_subfield_structure)
    * Upgrade to 3.01.00.099 done (granular permissions for cataloging added)
    * Upgrade done (added CAS authentication system preferences)
    * Upgrade to 3.01.00.101 done (added OverdueNoticeBcc system preferences)
    * Upgrade done (fixed spelling error in edit_catalogue permission)
    * Upgrade done (adding patron permissions for tags tool)
    * Upgrade to 3.01.00.104 done ( add defaults to authorized values for MANUAL_INV and BOR_NOTES and add new default LOC authorized values for shelf to cart processing )
    * Upgrade to 3.01.00.105 done (added collection and collection_tracking tables for rotating collections functionality)
    * Upgrade done (added OpacAddMastheadLibraryPulldown system preferences)
    * Status: 500
    * Content-type: text/html
    *
    * <h1>Software error:</h1>
    * <pre>DB ERROR: Table 'creator_batches' already exists
    * </pre>
    * <p>
    * For help, please send mail to the webmaster (<a href="mailto:webmaster at debmaker32">webmaster at debmaker32</a>), giving this error message
    * and the time and date of the error.
    *
    * </p>
    * Upgrade to 3.01.00.107 done (Migrated labels and patroncards tables and data to new schema.)
    * Upgrade done (added separators for csv export)
    * Upgrade done (added encoding for csv export)
    * Upgrade done (Add enrolment period date support)
    * Upgrade done (mark DBrev for 3.2-alpha release)
    * Upgrade done ( added Show Spine Label Printer on Bib Items Details preferences )
    * Upgrade done (added two new syspref: OPACXSLTResultsDisplay and OPACXSLTDetailDisplay). You may have to go in Admin > System preference to tweak XSLT related syspref both in OPAC and Search tabs.
    * Upgrade to 3.01.00.114 done ( Added AutoSelfCheckAllowed, AutoSelfCheckID, and AutoShelfCheckPass system preference )
    * Upgrade to 3.01.00.115 done ( Default aqorders.quantityreceived to 0 )
    * Upgrade done ( corrected default OrderPdfFormat value if still set wrong )
    * Upgrade to 3.01.00.117 done (corrected ISO 639-2 language code for Portuguese)
    * Upgrade to 3.01.00.118 done (bug 4203: add display column to aqbudgets_planning if missing)
    * Upgrade to 3.01.00.119 done (Locale::Currency::Format installed.)
    * Upgrade to 3.01.00.120 done (bug 1080: add soundon system preference for circulation sounds)
    * Upgrade to 3.01.00.121 done ( Added Additional Fields to Reserves tables )
    * Upgrade to 3.01.00.122 done. — Add a new system preference OAI-PMF:ConfFile
    * Upgrade to 3.01.00.123 done (Add granular permission for holds modification and update description of reserveforothers permission)
    * Upgrade to 3.01.00.124 done (bug 3242: add HOLDPLACED letter template, which is used when emailLibrarianWhenHoldIsPlaced is enabled)
    * Upgrade to 3.01.00.125 done (bug 3482: Printable hold and overdue notices)
    * Upgrade to 3.01.00.126 done (Adding ILS-DI updates and ILS-DI:AuthorizedIPs)
    * Upgrade to 3.01.00.127 done (bug 4190: messages in patron account did not work with branchcodes > 4)
    * Upgrade to 3.01.00.128 done (bug 4331: index orders by budget_id)
    * Upgrade done (Change permissions names for item batch modification / deletion)
    * Upgrade done (change reserves.expirationdate values of 0000-00-00 to NULL (bug 1532)Upgrade to 3.01.00.131 done (adding print and feed message transport types)
    * Upgrade to 3.01.00.132 done (Adding index to language_descriptions table)
    * Upgrade to 3.01.00.133 done (bug 4405: added OverduesBlockCirc syspref to control whether circulation is blocked if a borrower has overdues)
    * Upgrade to 3.01.00.134 done adding syspref DisplayMultiPlaceHold to control whether multiple holds can be placed from the search results pageUpgrade to 3.01.00.135 done (bug 4377: added HOLD_PRINT message template)Upgrade to 3.01.00.136 done Adding a new permission to edit itemsUpgrade to 3.01.00.137 done (adding granular permissions for serials)Upgrade to 3.01.00.138 done (bug 4896: removing GranularPermissions syspref; use of granular permissions is now the default)Upgrade to 3.01.00.139 done (bug 3682: change message_name from varchar(20) to varchar(40))
    * Upgrade to 3.01.00.140 done (bug 4312 TagsModeration changed from NULL to 0)
    * Upgrade to 3.01.00.141 done Remove upcoming events messaging option (bug 2434)Upgrade to 3.01.00.142 done Remove upcoming events messaging option part 2 (bug 2434)Create index on authorised_values and borrower_attribute_types (bug 4139)Update the 'default' to 'normal' for the IntranetBiblioDefaultView syspref (bug 5007)Upgrade to 3.01.00.145 done (Add index on guarantorid)
    * Upgrade to 3.01.00.999 done (3.2.0 release candidate)
    * Upgrade to 3.02.00.000 done (Add HomeOrHoldingBranchReturn system preference)
    * Upgrade to 3.02.00.001 done (bug 3756: remove disused system preferences)
    * Upgrade to 3.02.00.002 done (bug 3881: remove unused OpacPrivacy system preference)
    * Upgrade to 3.02.00.003 done (correct ILS-DI:AuthorizedIPs)
    * Upgrade to 3.02.00.004 done (3.2.0 general release)
    * Upgrade to 3.03.00.001 done (Make subscriptionroutinglist more strict)
    * Upgrade to 3.03.00.002 done (Correct language mappings)
    * Upgrade to 3.03.00.003 done (Add UseTablesortForCirc syspref)
    * Upgrade to 3.03.00.004 done (bug 5127: add default templates for suggestion status change notifications)

Update errors :

    * [Wed Dec 15 16:21:27 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1966.
    * [Wed Dec 15 16:21:27 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'item_level_request' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1985.
    * [Wed Dec 15 16:21:27 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2032.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACDisplayRequestPriority' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2039.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2046.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2050.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2051.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2052.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2059.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_transfer_limits' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2095.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-circulate_remaining_permissions' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2114.
    * [Wed Dec 15 16:21:28 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2115.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2149.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2160.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2168.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'holdallowed' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2172.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'item_circulation_alert_preferences' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2182.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'circulation-CHECKIN' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2197.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'circulation-CHECKOUT' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2201.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2209.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2210.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2211.
    * [Wed Dec 15 16:21:29 2010] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`message_transports`, CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2212.
    * [Wed Dec 15 16:21:30 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'ccode' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2221.
    * [Wed Dec 15 16:21:31 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'smsalertnumber' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2295.
    * [Wed Dec 15 16:21:32 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2392.
    * [Wed Dec 15 16:21:32 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2409.
    * [Wed Dec 15 16:21:33 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewISBD' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2452.
    * [Wed Dec 15 16:21:33 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewLabeledMARC' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2453.
    * [Wed Dec 15 16:21:33 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'viewMARC' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2454.
    * [Wed Dec 15 16:21:35 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AWSPrivateKey' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2498.
    * [Wed Dec 15 16:21:44 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '13-manage_csv_profiles' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2677.
    * [Wed Dec 15 16:21:44 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'export_format' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2678.
    * [Wed Dec 15 16:21:44 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'fieldmapping' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2692.
    * [Wed Dec 15 16:21:45 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'finedays' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2749.
    * [Wed Dec 15 16:21:49 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqbudgets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2934.
    * [Wed Dec 15 16:21:49 2010] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'aqbudgetid' in 'aqbudgets' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2938.
    * [Wed Dec 15 16:21:50 2010] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'startdate'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2986.
    * [Wed Dec 15 16:21:51 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqorders_items' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3106.
    * [Wed Dec 15 16:21:53 2010] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'budget_amount_sublevel'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3160.
    * [Wed Dec 15 16:21:56 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3360.
    * [Wed Dec 15 16:21:56 2010] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections_tracking' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3370.
    * [Wed Dec 15 16:21:57 2010] patroncards_upgrade.pl: DBD::mysql::db do failed: Table 'creator_batches' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/patroncards_upgrade.pl line 149.
    * [Wed Dec 15 16:21:57 2010] patroncards_upgrade.pl: DB ERROR: Table 'creator_batches' already exists
    * [Wed Dec 15 16:21:57 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'csv_separator' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3401.
    * [Wed Dec 15 16:21:57 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'encoding' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3412.
    * [Wed Dec 15 16:22:02 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '15-check_expiration' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3665.
    * [Wed Dec 15 16:22:04 2010] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'HomeOrHoldingBranchReturn' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3747.


More information about the Koha mailing list