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'
Created attachment 43269 [details] [review] 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.
Remove 2 NULL from the end for the 1 insert, then s|,NULL,NULL,'F',/,'F',/ s|,NULL,NULL,'M',/,'M',/
Created attachment 43733 [details] [review] 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.
Created attachment 43813 [details] [review] [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>
Patch pushed to master. Thanks Jonathan!