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

From Freeside
Jump to: navigation, search
(http://cnavieltz.strefa.pl/comment-1800.htm)
(removing spam)
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[http://cnavieltz.strefa.pl/comment-1800.htm adult amateur mature movie] [http://huruple.qsh.eu/20081228-audio-and-video.htm audio and video not in sync] [http://lofaako.strefa.pl/article642.html relic the movie] [http://saererg.0lx.net/20081110-lustra-music-video.htm lustra music video codes] [http://betheres.qsh.eu/sitemap.htm link]
 
[http://tulilre.strefa.pl/2008-12-25-lightning-bolt.html lightning bolt movie] [http://mahohmie.qsh.eu/resource1450.htm eating octopus shark video] [http://betheres.qsh.eu/comment-1706.htm lake in the hills movie] [http://chifire.strefa.pl/sitemap.html link] [http://mahohmie.qsh.eu/resource1779.htm movie stuck on you song list]
 
[http://cnavieltz.strefa.pl/comment-1448.htm red light district movies] [http://zelgetgo.0lx.net/new401.htm most embarrassing movie sex scenes] [http://flheddin.qsh.eu/delsedr-1912.html summary of the movie supersize me] [http://releltl.0lx.net/20081121-s-video-7-pin-pinout.html s video 7 pin pinout] [http://naceceli.qsh.eu/page1975.html petite teenager movies]
 
[http://sedplxca.is-the-boss.com/osasync-pro-serial-2008-12-22.htm osasync pro serial] [http://betheres.qsh.eu/comment-1091.htm rachel hunter movie] [http://brc4tdro.is-the-boss.com/page89.html pro democracy movement in china] [http://zelzelqa.is-the-boss.com/news-lava-serial-2008-12-28.html lava serial pci] [http://sakonze.qsh.eu/zcanrdron-629.html american movie revolution]
 
[http://saererg.0lx.net/20081121-aeon-download.htm aeon download flux free movie] [http://caraines.qsh.eu/golplmone.htm and 1 mixtapes videos] [http://releltl.0lx.net/sitemap.html url] [http://licawol.strefa.pl/resource1525.htm international movies data base] [http://tarobasal.strefa.pl/article1784.htm iraq us video war]
 
[http://cnavieltz.strefa.pl/sitemap.htm top] [http://roladarh.strefa.pl/news-1827.html live streaming video cam] [http://huruple.qsh.eu/20081225-ebony-fire-jada.htm ebony fire jada thumb video] [http://zelgetgo.0lx.net/new1467.htm stock footage film video] [http://roladarh.strefa.pl/news-256.html meet the folkers movie review]
 
[http://chifire.strefa.pl/news-816.html president funny videos] [http://faquafav.is-the-boss.com/text-383.htm renew texas drivers license] [http://golxando.0lx.net/1058063007.html easy video producer] [http://flheddin.qsh.eu/tatrnesed-1538.html numb u2 video] [http://lifokdron.0lx.net/1018.html los music temerarios video]
 
[http://relquaca.is-the-boss.com/20081229-alias-episodes.html alias episodes torrent] [http://huruple.qsh.eu/20081227-rammstein-mein.htm rammstein mein teil music video] [http://vihencbr.0lx.net/sitemap.html url] [http://lifokdron.0lx.net/323.html movie west wild wild] [http://lifokdron.0lx.net/sitemap.html map]
 
[http://sematild.qsh.eu/resource1987.htm male movie nude star] [http://huruple.qsh.eu/20081227-movie-from-the-20s.htm movie from the 20s] [http://sakonze.qsh.eu/nogetb-1787.html erykah badu music videos codes] [http://indronrol.is-the-boss.com/varsit.html security spy serial] [http://zelfibu.strefa.pl/chirol-1734.html movie theater charlotte nc]
 
acellaacel
 
erbocroel
 
 
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.
 
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.
 
* Install DBIx::DBSchema 0.31 (or later)
 
* Install DBIx::DBSchema 0.31 (or later)

Latest revision as of 10:51, 12 January 2009

  • Perl 5.8.0 or newer is required. Perl 5.8.3 or newer is required if using RT.
  • Install DBIx::DBSchema 0.31 (or later)
  • Install HTML::Widgets::SelectLayers 0.06 (or later)
  • Install DBIx::SearchBuilder 1.34 (or later)
  • Install Color::Scheme
  • Install Data::Table
  • Install Lingua::EN::NameParse
  • Install Lingua::EN::Inflect
  • Install DateTime
  • Install DateTime::Format::Strptime
  • Install Number::Format 1.50 (or later)
  • 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;
  • Apply the following changes to your database (if you have a paymask column):
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 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