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).

  1. In case you have custom localizations, make a backup of them with repligard (remember to use -a)
  2. Use repligard to import the release
  3. 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'); 
    }
    
    ?>
  4. If you made a backup of localizations, import it now (again, use -a)
  5. In Snippet /NemeinLocalization/Config change the line
    if (!$localization_conf['db_encoding']) $localization_conf['db_encoding']='utf-8';
    to
    if (!$localization_conf['db_encoding']) $localization_conf['db_encoding']='iso-8859-1';
  6. Make a note somewhere to remember to do this each time you upgrade OpenPSA untill you have converted the database to UTF-8
  7. Reserve time for converting your database to UTF-8

Design by Inventive Design and powered by Midgard CMS.