Difference between revisions of "Freeside:1.7:Documentation:Upgrading"

From Freeside
Jump to: navigation, search
Line 17: Line 17:
 
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
 
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
 
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;
 
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;
 +
 +
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';
 
</nowiki></pre>
 
</nowiki></pre>
 
* <code>make install-perl-modules</code>
 
* <code>make install-perl-modules</code>

Revision as of 02:11, 19 December 2006

  • Install DBIx::DBSchema 0.31 (or later)
  • Install HTML::Widgets::SelectLayers 0.06 (or later)
  • Install Color::Scheme
  • Install Data::Table
  • Install Lingua::EN::NameParse
  • Install Lingua::EN::Inflect
  • Install DateTime
  • Install DateTime::Format::Strptime
  • Apply the following changes to your database: 

ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
UPDATE cust_pay_batch SET payinfo = cardnum;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;

ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
UPDATE h_cust_pay_batch SET payinfo = cardnum;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;

UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';


  •  make install-perl-modules
    • 

  •  As the freeside UNIX user, run freeside-upgrade username, passing the username of an internal Freeside user.
    • 

  •  If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.
    • 

  •  pg_attribute: permission denied executing: UPDATE pg_attribute when running freeside-upgrade with Pg 7.3 or older?  Try this:

ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;


  •  ACL bootstrapping:

    •  


su
cd /usr/local/etc/freeside
chown freeside mapsecrets htpasswd




    •  As the freeside UNIX user, run bin/mapsecrets2access_user username, passing the username of an internal Freeside user.
      • 

    •  Using the web interface you can add more restrictive groups and move your employees into them.
    • 

  •  If you have any records in the cust_tax_exempt table, you *MUST* migrate them to the new cust_tax_exempt_pkg table.  An example script to get you started is in bin/fs-migrate-cust_tax_exempt - it may need to be customized for your specific data.
    • 

  •  Optional for better zip code report performance: 

CREATE INDEX cust_main16 on cust_main ( zip );
CREATE INDEX cust_main17 on cust_main ( ship_zip );


  •  Optional if you're using the new agent cust ref#s: 


CREATE UNIQUE INDEX cust_main18 ON cust_main ( agentnum, agent_custid );




  •  Optional to eliminate harmless but noisy warnings: 


UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;




  •  make install-docs (or make deploy if you've got everything setup for that in the Makefile)
    • 

  •  Perl module errors?  Try make clean then make install-perl-modules then make install-docs or make deploy again






					

						Retrieved from "http://freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&oldid=1634"