@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql | 2 +- installer/data/mysql/sysprefs.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) --- a/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql +++ a/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql @@ -1, +1, @@ -UPDATE systempreferences SET value='us', options = 'us | de | fr' WHERE variable = 'AddressFormat'; +UPDATE systempreferences SET options = 'us|de|fr' WHERE variable = 'AddressFormat'; --- a/installer/data/mysql/sysprefs.sql +++ a/installer/data/mysql/sysprefs.sql @@ -6,7 +6,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'), ('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'), ('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'), -('AddressFormat','us','us | de | fr','Choose format to display postal addresses', 'Choice'), +('AddressFormat','us','us|de|fr','Choose format to display postal addresses', 'Choice'), ('advancedMARCeditor','0','','If ON, the MARC editor won\'t display field/subfield descriptions','YesNo'), ('AdvancedSearchLanguages','','','ISO 639-2 codes of languages you wish to see appear as an Advanced search option. Example: eng|fre|ita','Textarea'), ('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'), --