<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi everyone.</p>
    <p>We have a fairly recent install of Freeside, so we started at
      v4.1. v4.2 was recently released with some security updates, but
      when I try to run the freeside-upgrade script as the freeside user
      on our system and restart Apache, I don't see the new version
      number in Help->About Freeside. <br>
    </p>
    <p>This is the complete output from the complete freeside upgrade
      procedure:<br>
      <br>
      <br>
      root@freeside:/home/ernied# /etc/init.d/apache2 stop<br>
      [ ok ] Stopping apache2 (via systemctl): apache2.service.<br>
      root@freeside:/home/ernied# su freeside<br>
      freeside@freeside:/home/ernied$ cd<br>
      freeside@freeside:~$ ls<br>
      freeside@freeside:~$ freeside-upgrade freeside<br>
      Subroutine JSON::XS::Boolean::(++ redefined at
      /usr/share/perl/5.20/overload.pm line 50.<br>
      Subroutine JSON::XS::Boolean::(-- redefined at
      /usr/share/perl/5.20/overload.pm line 50.<br>
      Subroutine JSON::XS::Boolean::(0+ redefined at
      /usr/share/perl/5.20/overload.pm line 50.<br>
      FS::part_event::Condition::payby is disabled; skipping<br>
      Upgrade startup completed in 4 seconds<br>
      UPDATE cust_main SET agent_custid = NULL where agent_custid = ''<br>
      UPDATE h_cust_main SET agent_custid = NULL where agent_custid = ''<br>
      <br>
            SELECT SETVAL( 'upgrade_journal_upgradenum_seq',<br>
                           ( SELECT MAX(upgradenum) FROM upgrade_journal
      )<br>
                         )<br>
          <br>
      Upgrading cust_bill_pkg_detail schema...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading TicketSystem schema...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading password_history schema...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pay_pending schema...<br>
        committing<br>
        done in 0 seconds<br>
      Custom fields schema upgrade completed at
      /usr/bin/freeside-upgrade line 172.<br>
      Schema upgrade completed in 5 seconds<br>
      Application pruning completed in 0 seconds<br>
      Re-initialization with updated schema completed in 4 seconds<br>
      Custom fields data upgrade completed at /usr/bin/freeside-upgrade
      line 401.<br>
      Use of uninitialized value $total_new_charges in numeric gt (>)
      at /usr/share/perl5/FS/Upgrade.pm line 152.<br>
      Use of uninitialized value in pattern match (m//) at
      /usr/share/perl5/FS/Upgrade.pm line 173.<br>
      Config updates completed in 0 seconds<br>
      Upgrading part_event_condition...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_event...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_main...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading contact...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading msgcat...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading reason_type...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pkg_reason...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_pkg...<br>
        committing<br>
        done in 1 seconds<br>
      Upgrading cust_credit...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_credit_void...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_bill_void...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_bill_pkg_void...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading h_cust_svc...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pay...<br>
      Need to migrate paybatch field in 2 payments.<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_pkg_taxclass...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pay_pending...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_bill_pkg_detail...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading usage_class...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading phone_type...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading access_right...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_pkg_option...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading pkg_category...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cdr...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_attachment...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_main_note...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pay_void...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pkg...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_pkg_discount...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_refund...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading banned_pay...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_payby...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading payment_gateway...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading msg_template...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading phone_avail...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading TicketSystem...<br>
      Subroutine JSON::XS::Boolean::("" redefined at
      /usr/share/perl/5.20/overload.pm line 50.<br>
      Subroutine JSON::XS::Boolean::(eq redefined at
      /usr/share/perl/5.20/overload.pm line 50.<br>
      ScripAction 'notify other recipients' not found.<br>
        committing<br>
        done in 1 seconds<br>
      Upgrading lata...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading msa...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading radius_usergroup...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_svc...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading part_export...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading tower...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_svc...<br>
      searching for missing svc_x records...<br>
      found 0<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading svc_broadband...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading pay_batch...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_tax_exempt_pkg...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_bill_pkg...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_bill_pkg_tax_location...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading state...<br>
      Updating state and country codes...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading quotation_pkg...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading tax_status...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_main_county...<br>
        committing<br>
        done in 0 seconds<br>
      Upgrading cust_location...<br>
        committing<br>
        done in 0 seconds<br>
      Table updates completed in 2 seconds<br>
      SQL RADIUS updates completed in 0 seconds<br>
      Final commit and disconnection completed in 0 seconds; upgrade
      done!<br>
      <br>
    </p>
  </body>
</html>