Bugzilla – Attachment 344 Details for
Bug 1535
bump to 00013 fails
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
patch to fix updatedatabase
0002-fix-transfer-of-marc_breeding-to-import_records-impo.patch (text/plain), 1.81 KB, created by
Chris Cormack
on 2007-10-31 07:13:00 UTC
(
hide
)
Description:
patch to fix updatedatabase
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2007-10-31 07:13:00 UTC
Size:
1.81 KB
patch
obsolete
>From 813b7470478dc2ded621195703f93e113eea5423 Mon Sep 17 00:00:00 2001 >From: Galen Charlton <galen.charlton@liblime.com> >Date: Wed, 31 Oct 2007 10:09:12 -0500 >Subject: [PATCH] fix transfer of marc_breeding to import_records/import_biblios > >Problem was that z3950random is not a good unique key to use >for linking new import_records and import_biblios rows. >--- > updater/updatedatabase | 6 +++--- > 1 files changed, 3 insertions(+), 3 deletions(-) > >diff --git a/updater/updatedatabase b/updater/updatedatabase >index 44419e7..1580285 100755 >--- a/updater/updatedatabase >+++ b/updater/updatedatabase >@@ -430,9 +430,9 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > FROM `marc_breeding`"); > > $dbh->do("INSERT INTO `import_records` >- (`import_batch_id`, `record_sequence`, `marc`, `record_type`, `status`, >+ (`import_batch_id`, `import_record_id`, `record_sequence`, `marc`, `record_type`, `status`, > `encoding`, `z3950random`, `marcxml`, `marcxml_old`) >- SELECT `import_batch_id`, 1, `marc`, 'biblio', 'staged', `encoding`, `z3950random`, '', '' >+ SELECT `import_batch_id`, `id`, 1, `marc`, 'biblio', 'staged', `encoding`, `z3950random`, '', '' > FROM `marc_breeding` > JOIN `import_batches` ON (`file_name` = `file`)"); > >@@ -440,7 +440,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > (`import_record_id`, `title`, `author`, `isbn`) > SELECT `import_record_id`, `title`, `author`, `isbn` > FROM `marc_breeding` >- JOIN `import_records` USING (`z3950random`)"); >+ JOIN `import_records` ON (`import_record_id` = `id`)"); > > $dbh->do("UPDATE `import_batches` > SET `num_biblios` = ( >-- >1.5.2.1 >
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 1535
: 344