Bugzilla – Attachment 148306 Details for
Bug 32437
When adding to a basket form a staged file and matching the imported records are ignored when set to overwrite
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32437: (QA follow-up) Prevent upgrade if wrong PRIMARY KEY key present
Bug-32437-QA-follow-up-Prevent-upgrade-if-wrong-PR.patch (text/plain), 1.31 KB, created by
Marcel de Rooy
on 2023-03-17 08:28:58 UTC
(
hide
)
Description:
Bug 32437: (QA follow-up) Prevent upgrade if wrong PRIMARY KEY key present
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2023-03-17 08:28:58 UTC
Size:
1.31 KB
patch
obsolete
>From 99475fa46daf6295ea202ce726ffeb1e18a0d2c9 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Thu, 16 Mar 2023 15:14:13 +0000 >Subject: [PATCH] Bug 32437: (QA follow-up) Prevent upgrade if wrong PRIMARY > KEY key present >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/atomicupdate/bug_32437.pl | 3 +++ > 1 file changed, 3 insertions(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_32437.pl b/installer/data/mysql/atomicupdate/bug_32437.pl >index 6ff91391b9..16343ad018 100755 >--- a/installer/data/mysql/atomicupdate/bug_32437.pl >+++ b/installer/data/mysql/atomicupdate/bug_32437.pl >@@ -12,6 +12,9 @@ return { > } elsif( !primary_key_exists('import_auths','import_record_id') ){ > say $out "Found an existing PRIMARY KEY on import_auths table"; > say $out "You must delete this key and replace it with a key on import_record_id"; >+ say $out " ALTER TABLE import_auths DROP PRIMARY KEY;"; >+ say $out " ALTER TABLE import_auths ADD PRIMARY KEY (import_record_id);"; >+ die "Interrupting installer process: database revision for bug 32437 fails!"; > } else { > say $out "PRIMARY KEY import_record_id on import_auths already exists"; > } >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 32437
:
144538
|
144539
|
144540
|
144541
|
144573
|
144574
|
144575
|
144576
|
145223
|
145224
|
145225
|
145226
|
147677
|
147678
|
147679
|
147680
|
147681
|
148270
|
148271
|
148272
|
148273
|
148274
|
148275
|
148276
|
148277
|
148300
|
148301
|
148302
|
148303
|
148304
|
148305
| 148306