Upgrading to 1.1.x from 1.2.x

• If migrating from 1.0.0, see these instructions first.
• If migrating from less than 1.1.4, see these instructions first.
• Back up your data and current Freeside installation.
• Install the Perl module String-Approx
• Configuration file location has changed!
• Move /var/spool/freeside/dbdef.datasrc to /usr/local/etc/freeside/dbdef.datasrc.
• Move /var/spool/freeside/counters to /usr/local/etc/freeside/counters.datasrc.
• Move /var/spool/freeside/export to /usr/local/etc/freeside/export.datasrc.
• Apply the following changes to your database:

  ALTER TABLE cust_main CHANGE state state varchar(80) NULL;
  ALTER TABLE cust_main_county CHANGE state state varchar(80) NULL;
  ALTER TABLE cust_main_county ADD country char(2);
  ALTER TABLE cust_main CHANGE paydate paydate varchar(10);
  UPDATE cust_main SET country = "US" where country IS NULL OR country = '';
  UPDATE cust_main_county SET country = "US" where country IS NULL OR country = "";
  CREATE TABLE cust_main_invoice (
     destnum int NOT NULL,
     custnum int NOT NULL,
     dest varchar(80) NOT NULL,
     PRIMARY KEY (destnum),
     INDEX ( custnum )
  );
  

• Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are running a different database engine you will need to modify it slightly.
• Copy or symlink htdocs and site_perl to the new copies.