<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>https://secure.freeside.biz/mediawiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=GetolOcnar</id>
		<title>Freeside - User contributions [en]</title>
		<link rel="self" type="application/atom+xml" href="https://secure.freeside.biz/mediawiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=GetolOcnar"/>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php/Special:Contributions/GetolOcnar"/>
		<updated>2026-06-06T08:51:14Z</updated>
		<subtitle>User contributions</subtitle>
		<generator>MediaWiki 1.27.7</generator>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4348</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4348"/>
				<updated>2009-01-12T16:11:35Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://chifire.strefa.pl/news-933.html&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://chifire.strefa.pl/news-933.html religious horror movies] [http://huruple.qsh.eu/20081225-jackass-the.htm jackass the movie download] [http://qasletop.is-the-boss.com/racinsa.html quick inspiration] [http://acsitzar.0lx.net/news-play-record-video-2008-11-17.html play record video] [http://lofaako.strefa.pl/article1345.html scary movie games] &lt;br /&gt;
[http://bukgetert.0lx.net/article-1918.htm mac music toby video] [http://betheres.qsh.eu/comment-1896.htm kid rock and scott stapp sex video] [http://huruple.qsh.eu/20090105-owen-hart-dead.htm owen hart dead video] [http://ettaelt.strefa.pl/news-1070.html latest english movie reviews] [http://indronrol.is-the-boss.com/sitemap.html site] &lt;br /&gt;
[http://varpasz.is-the-boss.com/article738.htm etree bit torrents] [http://golxando.0lx.net/1050185475.html ameteur sex video] [http://sakonze.qsh.eu/plormonf-765.html new hindi movie released] [http://varpasz.is-the-boss.com/article514.htm activation code recovermyfiles] [http://releltl.0lx.net/20081111-movie-theatres.html movie theatres in manhattan new york] &lt;br /&gt;
[http://caraines.qsh.eu/sitnoor.htm movie actress] [http://saererg.0lx.net/20081109-slr-mercedes-video.htm slr mercedes video] [http://bukgetert.0lx.net/article-1816.htm movie theater columbia alabama] [http://roladarh.strefa.pl/news-1024.html american clip kenpo video] [http://flheddin.qsh.eu/zaralf-176.html elecard mpeg 2 video] &lt;br /&gt;
[http://bukgetert.0lx.net/article-1104.htm movie goodwill hunting] [http://zelfibu.strefa.pl/ficaen-204.html adult amateur free porn video] [http://cnavieltz.strefa.pl/sitemap.htm page] [http://saererg.0lx.net/20081108-outlaw-star-video.htm outlaw star video] [http://lifokdron.0lx.net/693.html intervideo windvd 5 free download] &lt;br /&gt;
[http://fademon.0lx.net/article-360.htm movie sound bites casino] [http://chifire.strefa.pl/news-1820.html natural boob movie] [http://acsitzar.0lx.net/news-ashley-simpson-2008-11-19.html ashley simpson booed off stage video clip] [http://mahohmie.qsh.eu/resource1458.htm multiple personality disorder movies] [http://indronrol.is-the-boss.com/sitemap.html page] &lt;br /&gt;
[http://brc4tdro.is-the-boss.com/page265.html audio mp3 id3 tag editor serial] [http://zelzelqa.is-the-boss.com/news-psp-vintage-warmer-2008-12-25.html psp vintage warmer crack] [http://zelgetgo.0lx.net/new676.htm share tag upload video] [http://lifokdron.0lx.net/1517.html making money movie this top week] [http://chifire.strefa.pl/news-949.html list movie names] &lt;br /&gt;
[http://roladarh.strefa.pl/news-1987.html almeda buy movie priscilla] [http://licawol.strefa.pl/resource1945.htm movie cameras for sale] [http://dronoubr.0lx.net/spongebob-video.html spongebob video game] [http://ettaelt.strefa.pl/news-1708.html avs video converter 3.4 crack serial] [http://golxando.0lx.net/1013671239.html jet takeoff videos] &lt;br /&gt;
[http://faquafav.is-the-boss.com/text-536.htm anerobic respiration in yeast] [http://naceceli.qsh.eu/page1547.html masti indian movie] [http://brc4tdro.is-the-boss.com/page15.html macromedia flash mx professional 2004 crack] [http://releltl.0lx.net/20081111-avena-lee-free.html avena lee free video] [http://tulilre.strefa.pl/2008-12-24-making-memory-music.html making memory music us video] &lt;br /&gt;
[http://ettaelt.strefa.pl/news-1499.html explicit movie scene sex] [http://tacataca.strefa.pl/comment-321.htm aliens the movie website] [http://baslozaro.is-the-boss.com/article589.html illinois licence plate] [http://huruple.qsh.eu/sitemap.html http] [http://vihencbr.0lx.net/nikki-ziering.html nikki ziering nude video] &lt;br /&gt;
[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url] &lt;br /&gt;
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters] &lt;br /&gt;
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4325</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4325"/>
				<updated>2009-01-12T10:55:36Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://varpasz.is-the-boss.com/article738.htm&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://varpasz.is-the-boss.com/article738.htm etree bit torrents] [http://golxando.0lx.net/1050185475.html ameteur sex video] [http://sakonze.qsh.eu/plormonf-765.html new hindi movie released] [http://varpasz.is-the-boss.com/article514.htm activation code recovermyfiles] [http://releltl.0lx.net/20081111-movie-theatres.html movie theatres in manhattan new york] &lt;br /&gt;
[http://caraines.qsh.eu/sitnoor.htm movie actress] [http://saererg.0lx.net/20081109-slr-mercedes-video.htm slr mercedes video] [http://bukgetert.0lx.net/article-1816.htm movie theater columbia alabama] [http://roladarh.strefa.pl/news-1024.html american clip kenpo video] [http://flheddin.qsh.eu/zaralf-176.html elecard mpeg 2 video] &lt;br /&gt;
[http://bukgetert.0lx.net/article-1104.htm movie goodwill hunting] [http://zelfibu.strefa.pl/ficaen-204.html adult amateur free porn video] [http://cnavieltz.strefa.pl/sitemap.htm page] [http://saererg.0lx.net/20081108-outlaw-star-video.htm outlaw star video] [http://lifokdron.0lx.net/693.html intervideo windvd 5 free download] &lt;br /&gt;
[http://fademon.0lx.net/article-360.htm movie sound bites casino] [http://chifire.strefa.pl/news-1820.html natural boob movie] [http://acsitzar.0lx.net/news-ashley-simpson-2008-11-19.html ashley simpson booed off stage video clip] [http://mahohmie.qsh.eu/resource1458.htm multiple personality disorder movies] [http://indronrol.is-the-boss.com/sitemap.html page] &lt;br /&gt;
[http://brc4tdro.is-the-boss.com/page265.html audio mp3 id3 tag editor serial] [http://zelzelqa.is-the-boss.com/news-psp-vintage-warmer-2008-12-25.html psp vintage warmer crack] [http://zelgetgo.0lx.net/new676.htm share tag upload video] [http://lifokdron.0lx.net/1517.html making money movie this top week] [http://chifire.strefa.pl/news-949.html list movie names] &lt;br /&gt;
[http://roladarh.strefa.pl/news-1987.html almeda buy movie priscilla] [http://licawol.strefa.pl/resource1945.htm movie cameras for sale] [http://dronoubr.0lx.net/spongebob-video.html spongebob video game] [http://ettaelt.strefa.pl/news-1708.html avs video converter 3.4 crack serial] [http://golxando.0lx.net/1013671239.html jet takeoff videos] &lt;br /&gt;
[http://faquafav.is-the-boss.com/text-536.htm anerobic respiration in yeast] [http://naceceli.qsh.eu/page1547.html masti indian movie] [http://brc4tdro.is-the-boss.com/page15.html macromedia flash mx professional 2004 crack] [http://releltl.0lx.net/20081111-avena-lee-free.html avena lee free video] [http://tulilre.strefa.pl/2008-12-24-making-memory-music.html making memory music us video] &lt;br /&gt;
[http://ettaelt.strefa.pl/news-1499.html explicit movie scene sex] [http://tacataca.strefa.pl/comment-321.htm aliens the movie website] [http://baslozaro.is-the-boss.com/article589.html illinois licence plate] [http://huruple.qsh.eu/sitemap.html http] [http://vihencbr.0lx.net/nikki-ziering.html nikki ziering nude video] &lt;br /&gt;
[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url] &lt;br /&gt;
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters] &lt;br /&gt;
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4279</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4279"/>
				<updated>2009-01-12T00:12:01Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://fademon.0lx.net/article-360.htm&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://fademon.0lx.net/article-360.htm movie sound bites casino] [http://chifire.strefa.pl/news-1820.html natural boob movie] [http://acsitzar.0lx.net/news-ashley-simpson-2008-11-19.html ashley simpson booed off stage video clip] [http://mahohmie.qsh.eu/resource1458.htm multiple personality disorder movies] [http://indronrol.is-the-boss.com/sitemap.html page] &lt;br /&gt;
[http://brc4tdro.is-the-boss.com/page265.html audio mp3 id3 tag editor serial] [http://zelzelqa.is-the-boss.com/news-psp-vintage-warmer-2008-12-25.html psp vintage warmer crack] [http://zelgetgo.0lx.net/new676.htm share tag upload video] [http://lifokdron.0lx.net/1517.html making money movie this top week] [http://chifire.strefa.pl/news-949.html list movie names] &lt;br /&gt;
[http://roladarh.strefa.pl/news-1987.html almeda buy movie priscilla] [http://licawol.strefa.pl/resource1945.htm movie cameras for sale] [http://dronoubr.0lx.net/spongebob-video.html spongebob video game] [http://ettaelt.strefa.pl/news-1708.html avs video converter 3.4 crack serial] [http://golxando.0lx.net/1013671239.html jet takeoff videos] &lt;br /&gt;
[http://faquafav.is-the-boss.com/text-536.htm anerobic respiration in yeast] [http://naceceli.qsh.eu/page1547.html masti indian movie] [http://brc4tdro.is-the-boss.com/page15.html macromedia flash mx professional 2004 crack] [http://releltl.0lx.net/20081111-avena-lee-free.html avena lee free video] [http://tulilre.strefa.pl/2008-12-24-making-memory-music.html making memory music us video] &lt;br /&gt;
[http://ettaelt.strefa.pl/news-1499.html explicit movie scene sex] [http://tacataca.strefa.pl/comment-321.htm aliens the movie website] [http://baslozaro.is-the-boss.com/article589.html illinois licence plate] [http://huruple.qsh.eu/sitemap.html http] [http://vihencbr.0lx.net/nikki-ziering.html nikki ziering nude video] &lt;br /&gt;
[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url] &lt;br /&gt;
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters] &lt;br /&gt;
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4256</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4256"/>
				<updated>2009-01-11T19:27:01Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://roladarh.strefa.pl/news-1987.html&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://roladarh.strefa.pl/news-1987.html almeda buy movie priscilla] [http://licawol.strefa.pl/resource1945.htm movie cameras for sale] [http://dronoubr.0lx.net/spongebob-video.html spongebob video game] [http://ettaelt.strefa.pl/news-1708.html avs video converter 3.4 crack serial] [http://golxando.0lx.net/1013671239.html jet takeoff videos] &lt;br /&gt;
[http://faquafav.is-the-boss.com/text-536.htm anerobic respiration in yeast] [http://naceceli.qsh.eu/page1547.html masti indian movie] [http://brc4tdro.is-the-boss.com/page15.html macromedia flash mx professional 2004 crack] [http://releltl.0lx.net/20081111-avena-lee-free.html avena lee free video] [http://tulilre.strefa.pl/2008-12-24-making-memory-music.html making memory music us video] &lt;br /&gt;
[http://ettaelt.strefa.pl/news-1499.html explicit movie scene sex] [http://tacataca.strefa.pl/comment-321.htm aliens the movie website] [http://baslozaro.is-the-boss.com/article589.html illinois licence plate] [http://huruple.qsh.eu/sitemap.html http] [http://vihencbr.0lx.net/nikki-ziering.html nikki ziering nude video] &lt;br /&gt;
[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url] &lt;br /&gt;
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters] &lt;br /&gt;
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4213</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4213"/>
				<updated>2009-01-11T08:59:57Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://relquaca.is-the-boss.com/sitemap.html&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url] &lt;br /&gt;
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters] &lt;br /&gt;
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4190</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4190"/>
				<updated>2009-01-11T03:23:28Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://licawol.strefa.pl/resource1573.htm&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4167</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4167"/>
				<updated>2009-01-10T22:17:55Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://tulilre.strefa.pl/2008-12-25-lightning-bolt.html&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4146</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4146"/>
				<updated>2009-01-10T16:57:11Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://sedplxca.is-the-boss.com/osasync-pro-serial-2008-12-22.htm&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4129</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4129"/>
				<updated>2009-01-10T11:17:29Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://cnavieltz.strefa.pl/sitemap.htm&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4095</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=4095"/>
				<updated>2009-01-09T11:18:00Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: http://relquaca.is-the-boss.com/20081229-alias-episodes.html&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[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] &lt;br /&gt;
[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] &lt;br /&gt;
acellaacel&lt;br /&gt;
erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=3990</id>
		<title>Freeside:1.7:Documentation:Upgrading</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:1.7:Documentation:Upgrading&amp;diff=3990"/>
				<updated>2008-12-17T19:25:58Z</updated>
		
		<summary type="html">&lt;p&gt;GetolOcnar: alcrocaol&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;erbocroel&lt;br /&gt;
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.&lt;br /&gt;
* Install DBIx::DBSchema 0.31 (or later)&lt;br /&gt;
* Install HTML::Widgets::SelectLayers 0.06 (or later)&lt;br /&gt;
* Install DBIx::SearchBuilder 1.34 (or later)&lt;br /&gt;
* Install Color::Scheme&lt;br /&gt;
* Install Data::Table&lt;br /&gt;
* Install Lingua::EN::NameParse&lt;br /&gt;
* Install Lingua::EN::Inflect&lt;br /&gt;
* Install DateTime&lt;br /&gt;
* Install DateTime::Format::Strptime&lt;br /&gt;
* Install Number::Format 1.50 (or later)&lt;br /&gt;
* Apply the following changes to your database: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);&lt;br /&gt;
UPDATE h_cust_pay_batch SET payinfo = cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* Apply the following changes to your database (if you have a paymask column): &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt;&lt;br /&gt;
* As the freeside UNIX user, run &amp;lt;code&amp;gt;freeside-upgrade username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
* If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.&lt;br /&gt;
* &amp;lt;code&amp;gt;pg_attribute: permission denied executing: UPDATE pg_attribute&amp;lt;/code&amp;gt; when running freeside-upgrade with Pg 7.3 or older?  Try this:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);&lt;br /&gt;
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* ACL bootstrapping:&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
su&lt;br /&gt;
cd /usr/local/etc/freeside&lt;br /&gt;
chown freeside mapsecrets htpasswd&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
** As the freeside UNIX user, run &amp;lt;code&amp;gt;bin/mapsecrets2access_user username&amp;lt;/code&amp;gt;, passing the username of an internal Freeside user.&lt;br /&gt;
** Using the web interface you can add more restrictive groups and move your employees into them.&lt;br /&gt;
* 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 &amp;lt;code&amp;gt;bin/fs-migrate-cust_tax_exempt&amp;lt;/code&amp;gt; - it may need to be customized for your specific data.&lt;br /&gt;
* Optional to eliminate harmless but noisy warnings: &lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
* &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; (or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; if you've got everything setup for that in the Makefile)&lt;br /&gt;
* Perl module errors?  Try &amp;lt;code&amp;gt;make clean&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-perl-modules&amp;lt;/code&amp;gt; then &amp;lt;code&amp;gt;make install-docs&amp;lt;/code&amp;gt; or &amp;lt;code&amp;gt;make deploy&amp;lt;/code&amp;gt; again&lt;/div&gt;</summary>
		<author><name>GetolOcnar</name></author>	</entry>

	</feed>