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

[Galen Charlton]

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