[Koha] Migration issues from ancient 2.2.5 to 3.x

[Manos PETRIDIS]

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-bounces at lists.katipo.co.nz
[mailto:koha-bounces at 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 <indradg at 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:  gmc at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha