[Koha-bugs] [Bug 27534] New: koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"

Sat Jan 23 11:15:36 CET 2021

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534

            Bug ID: 27534
           Summary: koha upgrade throws SQL error while applying Bug 25333
                    - Change message transport type for Talking Tech from
                    "phone" to "itiva"
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: egpetridis at yahoo.com
        QA Contact: testopia at bugs.koha-community.org

Noticed the following error while upgrading to 20.11.01.000:

DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key
constraint fails (`koha_usmarc`.`letter`, CONSTRAINT
`message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES
`message_transport_types` (`message_transport_type`)) [for Statement "
        UPDATE message_transport_types SET message_transport_type = "itiva"
WHERE message_transport_type = "phone"
    "] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
23192.
Upgrade to 20.06.00.058 done [00:14:07]: Bug 25333 - Change message transport
type for Talking Tech from "phone" to "itiva"

Apparently it pertains to Bug: 25333 

Log follows:

root at koha:~# apt-get update
Ign:1 http://debian.otenet.gr/debian stretch InRelease
Hit:2 http://debian.otenet.gr/debian stretch Release                           
Ign:3 http://debian.noc.ntua.gr/debian stretch InRelease                       
Ign:4 http://deb.debian.org/debian stretch InRelease                           
Get:5 http://debian.noc.ntua.gr/debian stretch-updates InRelease [93.6 kB]     
Get:6 http://security.debian.org/debian-security stretch/updates InRelease
[53.0 kB]
Hit:7 http://deb.debian.org/debian stretch Release                             
Hit:8 http://debian.noc.ntua.gr/debian stretch Release                         
Hit:10 http://debian.koha-community.org/koha stable InRelease                  
Get:12 http://security.debian.org/debian-security stretch/updates/main Sources
[331 kB]
Hit:13 http://espejito.fder.edu.uy/mariadb/repo/10.4/debian stretch InRelease  
Get:14 http://security.debian.org/debian-security stretch/updates/main amd64
Packages [649 kB]
Fetched 1,127 kB in 2s (448 kB/s)                                              
Reading package lists... Done

root at koha:~# apt-get upgrade
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer required:
  libcache-fastmmap-perl libpdf-api2-simple-perl libppi-perl
  libwww-youtube-download-perl libxml-treepp-perl tinymce
Use 'apt autoremove' to remove them.
The following packages have been kept back:
  libjson-validator-perl libmojolicious-perl
  libmojolicious-plugin-openapi-perl
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up koha-common (20.11.01-1) ...
Upgrading database schema for usmarc
Upgrade to 20.06.00.023 done [00:13:16]: Bug 16371 - Quote of the Day (QOTD)
for the staff interface 
Upgrade to 20.06.00.024 done [00:13:17]: Bug 25867 - Update subfield
descriptions for 952$a and 952$b
Upgrade to 20.06.00.025 done [00:13:17]: Bug  6725 - Adds
PatronDuplicateMatchingAddFields system preference
Upgrade to 20.06.00.026 done [00:13:17]: Bug 19036 - Add
accountlines.credit_number, account_credit_types.credit_number_enabled and
syspref AutoCreditNumber
Upgrade to 20.06.00.027 done [00:13:17]: Bug  8732 - Add new BiblioItemtypeInfo
to system preferences
Upgrade to 20.06.00.028 done [00:13:17]: Bug 25958 - Allow LongOverdue cron to
exclude specified lost values
Upgrade to 20.06.00.029 done [00:13:17]: Bug 25534 - Add ability to send an
email specifying a reason when canceling a hold
Upgrade to 20.06.00.030 done [00:13:17]: Bug 20057 - Add new system preference
'AutoApprovePatronProfileSettings'
Upgrade to 20.06.00.031 done [00:13:17]: Bug 22789 - Add non_priority column on
reserves and old_reserves tables
Upgrade to 20.06.00.032 done [00:13:17]: Bug 19889 - Add
exclude_from_local_holds_priority column to items, deleteditems and categories
tables
Upgrade to 20.06.00.033 done [00:13:17]: Bug 21066 - Rename column
opac_news.timestamp with published_on
                                                   - Add new column
opac_news.updated_on
                                                   - Replace timestamp
references in letters table
Upgrade to 20.06.00.034 done [00:13:17]: Bug 24197 - Add new system preference
'AddressForFailedOverdueNotices'
Upgrade to 20.06.00.035 done [00:13:17]: Bug 23682 - Add new system preference
'EdifactInvoiceImport'
Upgrade to 20.06.00.036 done [00:13:17]: Bug 20168 - Update
OPACSearchForTitleIn to work with Bootstrap 4
Upgrade to 20.06.00.037 done [00:13:17]: Bug 23816 - Add min_password_length
and require_strong_password columns in categories table
Upgrade to 20.06.00.038 done [00:13:18]: Bug 24807 - Add 'year' type to improve
sorting behaviour
Upgrade to 20.06.00.039 done [00:13:18]: Bug 18958 - Add reserve_id to
hold_fill_targets
Upgrade to 20.06.00.040 done [00:13:18]: Bug 26454 - Add system preference to
set meta description for the OPAC
Upgrade to 20.06.00.041 done [00:13:18]: Bug 26268 - Remove items.paidfor field
Upgrade to 20.06.00.042 done [00:13:18]: Bug 25776 - Add letter.updated_on
Upgrade to 20.06.00.043 done [00:13:18]: Bug 25261 - Add CircConfirmItemParts
syspref
Upgrade to 20.06.00.044 done [00:13:18]: Bug 22343 - Add SMTP configuration
options
Upgrade to 20.06.00.045 done [00:13:18]: Bug 22417 - Add new table
background_jobs
Upgrade to 20.06.00.046 done [00:13:18]: Bug 13535 - Add FK constraint on
borrowernumber to alert table
Upgrade to 20.06.00.047 done [00:13:18]: Bug 23420 - Allow configuration of
hidden fields on the suggestion form in OPAC
Upgrade to 20.06.00.048 done [00:13:18]: Bug 26529 - Remove blank default
branch rules
Upgrade to 20.06.00.049 done [00:14:04]: Bug 26145 - Add the
biblioimages.itemnumber column
                                                   - Rename table biblioimages
with cover_images
Upgrade to 20.06.00.050 done [00:14:04]: Bug 19382 - Add ability to block
guarantees based on fees owed by guarantor and other guarantee - new system
preference 'NoIssuesChargeGuarantorsWithGuarantees'
Upgrade to 20.06.00.051 done [00:14:04]: Bug 12556 - Add new syspref
HoldsNeedProcessingSIP
Upgrade to 20.06.00.052 done [00:14:04]: Bug 25460 - Update OAI set when
adding/editing/deleting item records
Upgrade to 20.06.00.053 done [00:14:04]: Bug 26569 - Use gender neutral
pronouns in system preference explanations
Upgrade to 20.06.00.054 done [00:14:04]: Bug 25596 - Add OVERPAYMENT credit
type
Upgrade to 20.06.00.055 done [00:14:05]: Bug 18050 - Add FK constraint on
aqbudgets.budget_period_id
Upgrade to 20.06.00.056 done [00:14:07]: Bug 26853 - Update import_biblios
columns and indexes
Upgrade to 20.06.00.057 done [00:14:07]: Bug 26638 - Add missing system
preference ArticleRequestsMandatoryFieldsItemOnly
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key
constraint fails (`koha_usmarc`.`letter`, CONSTRAINT
`message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES
`message_transport_types` (`message_transport_type`)) [for Statement "
        UPDATE message_transport_types SET message_transport_type = "itiva"
WHERE message_transport_type = "phone"
    "] at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line
23192.
Upgrade to 20.06.00.058 done [00:14:07]: Bug 25333 - Change message transport
type for Talking Tech from "phone" to "itiva"
Upgrade to 20.06.00.059 done [00:14:07]: Bug 19482 - Add mandatory column to
search_field for ES mapping
Upgrade to 20.06.00.060 done [00:14:08]: Bug 25334 - Add generic 'phone'
message transport type
Upgrade to 20.06.00.061 done [00:14:08]: Bug 24412 - Attach waiting reserve to
desk
Upgrade to 20.06.00.062 done [00:14:08]: Bug 23091 - Update refund rules
Upgrade to 20.06.00.063 done [00:14:08]: Bug 14866 - Add decreaseloanholds
circulation rule
Upgrade to 20.06.00.064 done [00:14:08]: Bug 24603 - Add CANCELLATION
credit_type_code
Upgrade to 20.06.00.065 done [00:14:08]: Bug 23916 - Add new
[old_]issues.issuer DB fields
                                                   - Add new syspref
RecordStaffUserOnCheckout
Upgrade to 20.06.00.066 done [00:14:09]: Bug 22818 - Add ILL notices
Upgrade to 20.06.00.067 done [00:14:09]: Bug 20936 - Add new system preference
OPACHoldsHistory
Upgrade to 20.06.00.068 done [00:14:09]: Bug 23019 - Add import_batch_profiles
table and profile_id column in import_batches
Upgrade to 20.06.00.069 done [00:14:09]: Bug 24083 - Add circulation_rules
'unseen_renewals_allowed'
                                                   - Add issues.unseen_renewals
& old_issues.unseen_renewals)
                                                   - Add new system preference
UnseenRenewals
Upgrade to 20.11.00.000 done [00:14:09]: Koha 20.11.00 release
Upgrade to 20.11.01.000 done [00:14:09]: Koha 20.11.01 release
The following plugins have been enabled:
  amqp_client
  rabbitmq_stomp

Applying plugin configuration to rabbit at koha... started 2 plugins.
W: APT had planned for dpkg to do more than it reported back (0 vs 4).
   Affected packages: koha-common:amd64
root at koha:~#

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.