[Koha-bugs] [Bug 7045] Default-value substitution inconsistent

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Sep 5 08:48:00 CEST 2016


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7045

Zeno Tajoli <z.tajoli at cineca.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |z.tajoli at cineca.it

--- Comment #33 from Zeno Tajoli <z.tajoli at cineca.it> ---
ATTENTION
The update in updatedatabase.pl for this patch (DBRev 16.06.00.016)
is wrong.
Instesad of 

update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'YYYY',
'<<YYYY>>') where defaultvalue like "%YYYY%" and defaultvalue not like
"%<<YYYY>>%";
update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'MM',
'<<MM>>') where defaultvalue like "%MM%" and defaultvalue not like "%<<MM>>%";
update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'DD',
'<<DD>>') where defaultvalue like "%DD%" and defaultvalue not like "%<<DD>>%";
update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'user',
'<<USER>>') where defaultvalue like "%user%" and defaultvalue not like
"%<<USER>>%";

I see:

 INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`,
`explanation`, `type`) VALUES
('OPACSuggestionMandatoryFields','title','','Define the mandatory fields for a
patron purchase suggestions made via OPAC.','multiple');

It is the same of DBRev 16.06.00.017.

An error of RM ?

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the QA Contact for the bug.


More information about the Koha-bugs mailing list