Upgrading to OpenPSA 1.10.1 (and later) in latin1 encoded DB
Just a quick note about this, the process is deductable from the long post about converting latin1 databases to UTF-8, but better to have it written out this way.
This applies also to installing fresh 1.10.1 (or newer) OpenPSA on latin1 encoded database (though obviously 1 and 4 do not apply).
- In case you have custom localizations, make a backup of them with repligard (remember to use -a)
- Use repligard to import the release
- In OpenPSA manager run the following script
<?php mgd_include_snippet("NemeinLocalization/init"); //Convert all nemeinloc registered libraries while (list ($k, $libPath) = each ($localization_libraries)) { nnloc_convert_charset_lib($libPath, 'utf-8', 'iso-8859-1'); } ?> - If you made a backup of localizations, import it now (again, use -a)
- In Snippet /NemeinLocalization/Config change the line
if (!$localization_conf['db_encoding']) $localization_conf['db_encoding']='utf-8';
toif (!$localization_conf['db_encoding']) $localization_conf['db_encoding']='iso-8859-1';
- Make a note somewhere to remember to do this each time you upgrade OpenPSA untill you have converted the database to UTF-8
- Reserve time for converting your database to UTF-8