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

Revision as of 03:55, 12 January 2009

etree bit torrents ameteur sex video new hindi movie released activation code recovermyfiles movie theatres in manhattan new york movie actress slr mercedes video movie theater columbia alabama american clip kenpo video elecard mpeg 2 video movie goodwill hunting adult amateur free porn video page outlaw star video intervideo windvd 5 free download movie sound bites casino natural boob movie ashley simpson booed off stage video clip multiple personality disorder movies page audio mp3 id3 tag editor serial psp vintage warmer crack share tag upload video making money movie this top week list movie names almeda buy movie priscilla movie cameras for sale spongebob video game avs video converter 3.4 crack serial jet takeoff videos anerobic respiration in yeast masti indian movie macromedia flash mx professional 2004 crack avena lee free video making memory music us video explicit movie scene sex aliens the movie website illinois licence plate http nikki ziering nude video index powwow highway movie posting videos on website premeditation video url rock music video codes lanka sri movies anastasia romanov movie microsoft movie maker 2.0 download japanese version movie posters mystery skate video making a video diary ati rage 128 agp graphics video card new jim carrey movies last of the mohicans movie script adult amateur mature movie audio and video not in sync relic the movie lustra music video codes link lightning bolt movie eating octopus shark video lake in the hills movie link movie stuck on you song list red light district movies most embarrassing movie sex scenes summary of the movie supersize me s video 7 pin pinout petite teenager movies osasync pro serial rachel hunter movie pro democracy movement in china lava serial pci american movie revolution aeon download flux free movie and 1 mixtapes videos url international movies data base iraq us video war top live streaming video cam ebony fire jada thumb video stock footage film video meet the folkers movie review president funny videos renew texas drivers license easy video producer numb u2 video los music temerarios video alias episodes torrent rammstein mein teil music video url movie west wild wild map male movie nude star movie from the 20s erykah badu music videos codes security spy serial 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.
• 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