Should that be the case, I wonder if such a unique index on systempreferences.variable. would be welcome as a permanent feature. Unless all sql scripts check for already existing entries so that they perform an update instead of insert, the index would at least ensure that no duplicates are created.
On the other hand of course, this would mean that some sql scripts may need re-visiting in order to ensure proper error trapping after every insert in systempreferences, but this may be better than having to deal with spurious errors during production, stemming from multiple occurrences of the same variable in systempreferences. Do you agree or have I got it wrong? MP -----Original Message----- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Galen Charlton Sent: Friday, April 12, 2013 8:14 PM To: Indranil Das Gupta Cc: koha Subject: Re: [Koha] Migration issues from ancient 2.2.5 to 3.x Hi, On Fri, Apr 12, 2013 at 9:32 AM, Indranil Das Gupta <indr...@gmail.com> wrote: > However, a whole load of system preferences are missing from the db > even after going through the 22_to_30 scripts > > Specifically I'm missing : > > StaffClient TemplateEncoding : utf-8 > StaffClient Intranetcolorstylesheet : blue.css (to have some blue > colors. This step is not required, you can skip it) StaffClient > Template : prog > > What do you suggest I do? Fortunately, just adding the missing system preferences will do the right thing. A quick and dirty way to get them in with the default values would be to [1] Create a unique index on systempreferences.variable. [2] Run the following; the unique index will prevent duplicates system preferences from being loaded: mysql [connection info] --force < installer/data/mysql/sysprefs.sql [3] Drop the unique index. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
