[Bug 14981] New: Sample patron data broken by removal of ethnicity column
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Bug ID: 14981 Summary: Sample patron data broken by removal of ethnicity column Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: kyle.m.hall@gmail.com QA Contact: testopia@bugs.koha-community.org Bug 10020 has removed the ethnicity columns in Koha, but they are still referenced in the sample_patrons.sql file. Attempting to install using the sample data results in this error: ERROR 1054 (42S22) at line 1: Unknown column 'ethnicity' in 'field list' -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |10020 Referenced Bugs: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10020 [Bug 10020] Remove old code related to 'ethnicity' -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 43269 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=43269&action=edit Bug 14981: Remove ethnicity occurrences from sample patrons file Bug 10020 has removed these columns, the should be removed from the patron sample file. Test plan: Insert the files updated by this patch into a fresh DB, you shouldn't get any error. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org Assignee|gmcharlt@gmail.com |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Remove 2 NULL from the end for the 1 insert, then s|,NULL,NULL,'F',/,'F',/ s|,NULL,NULL,'M',/,'M',/ -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Frédéric Demians <frederic@tamil.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Frédéric Demians <frederic@tamil.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #43269|0 |1 is obsolete| | --- Comment #3 from Frédéric Demians <frederic@tamil.fr> --- Created attachment 43733 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=43733&action=edit Bug 14981: Remove ethnicity occurrences from sample patrons file Bug 10020 has removed these columns, the should be removed from the patron sample file. Test plan: Insert the files updated by this patch into a fresh DB, you shouldn't get any error. Signed-off-by: Frederic Demians <f.demians@tamil.fr> Before applying the patch, I was able to notice the error when loading the patron sample SQL file to a DB. With the patch, it's solved. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #43733|0 |1 is obsolete| | --- Comment #4 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 43813 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=43813&action=edit [PASSED QA] Bug 14981: Remove ethnicity occurrences from sample patrons file Bug 10020 has removed these columns, the should be removed from the patron sample file. Test plan: Insert the files updated by this patch into a fresh DB, you shouldn't get any error. Signed-off-by: Frederic Demians <f.demians@tamil.fr> Before applying the patch, I was able to notice the error when loading the patron sample SQL file to a DB. With the patch, it's solved. Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |tomascohen@gmail.com --- Comment #5 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Patch pushed to master. Thanks Jonathan! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14981 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Architecture, internals, |Installation and upgrade |and plumbing |(web-based installer) CC| |gmcharlt@gmail.com, | |katrin.fischer@bsz-bw.de -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org