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

From Freeside
Jump to: navigation, search
(reverting spam)
 
Line 1: Line 1:
[http://techwebcast.info/forum/attachments/files/page-1237.html monroe county government rochester ny] [http://beachcki.org/officers/wpThumbnails/pics/topic497.htm alias season 1 torrent] [http://casv.ca/secondary/class/install/1261.html lingerie hot] [http://thewholesaler.co.uk/newsletter/data/images/article150.html personalized keychains] [http://tatlin.com/gallery/wp-content/uploads/2008/topic-2407.htm alan rickman snape] [http://mdabc.net/test/files/new1505.htm linda fiorentino] [http://cavalierpedigrees.com/XOOPS/images/text149.htm acute] [http://techwebcast.info/forum/attachments/files/page-1417.html huge pregnant bellies] [http://carpentercarpenter.ca/_doubletuttle/images/index.html sitemap] [http://rubyarts.org/images/icons/news-2066.html alba book guest net online phentermine site] [http://aquisechatea.com/galeria/albums/userpics/10002/page300.html jcb cards] [http://mdabc.net/test/files/new1811.htm impossible creatures crack] [http://pixsoulmedia.com/dev/images/thumbs/article817.html diabetic menu] [http://rubyarts.org/images/icons/news-291.html popcap] [http://aarh.net/generator/assets/gallery3/topic-178.html zemanova jpg] [http://beachcki.org/officers/wpThumbnails/pics/topic910.htm open video joiner 3.0.2 crack] [http://rubyarts.org/images/icons/news-1735.html mortage loan calculator] [http://rubyarts.org/images/icons/news-836.html pdf tiff converter download free] [http://pixsoulmedia.com/dev/images/thumbs/sitemap.html top] [http://castlekeepcavaliers.com/generator/assets/files/page571.html mac direct connect] [http://tatlin.com/gallery/wp-content/uploads/2008/topic-1728.htm military pay charts] [http://castlekeepcavaliers.com/generator/assets/files/page374.html movie mystic pizza] [http://sahardesign.com/files/styles/article347.html anna nicole free movies] [http://castlekeepcavaliers.com/generator/assets/files/page862.html alberta wedding license] [http://techwebcast.info/forum/attachments/files/page-1427.html alam majlis perbandaran shah] [http://vfcpug.org/meta/quad/images/text-494.htm katie price video] [http://beachcki.org/officers/wpThumbnails/pics/index.html page] [http://capstonerealty.ph/gallery/Farm_Lots/mini/resource-1151.html 5 celebrate de mayo we why] [http://cavaliersonline.com/photos/icons/index.htm page] [http://appleturnover.tv/about/images/news-931-20090703.html summery of book] [http://mdabc.net/test/files/new751.htm gran turismo 4 cheat codes] [http://tatlin.com/gallery/wp-content/uploads/2008/topic-2306.htm site translator 2.39 crack] [http://paarc.ca/images/thumbs/article2540.html skittles vending] [http://appleturnover.tv/about/images/news-2817-20090628.html dimethylsulfoxide] [http://beachcki.org/officers/wpThumbnails/pics/topic1240.htm redfish video] [http://brixhost.net/my/attachments/media/news-1643-2009-06-23.html these dreams lyrics by heart] [http://aquisechatea.com/galeria/albums/userpics/10002/page1587.html map] [http://pixsoulmedia.com/dev/images/thumbs/article1221.html inspirational story volunteer] [http://pixsoulmedia.com/dev/images/thumbs/sitemap.html links] [http://kazak.ca/buzz/data/media/xcoelzar1931.htm keygen smartmovie 2.64] [http://castlekeepcavaliers.com/generator/assets/files/page629.html movie pa reading] [http://rvpark4u.com/weblog/skins/rsd/files/page92.html excel airways] [http://cavaliersonline.com/photos/icons/index.htm link] [http://marja-leena-rathje.info/ssp_director/config/conf/article1308.html new.com] [http://paarc.ca/images/thumbs/article932.html attack heart john mcsherry video] [http://tatlin.com/gallery/wp-content/uploads/2008/topic-743.htm torrent guitar lesson] [http://appleturnover.tv/about/images/news-502-20090702.html zaba people search] [http://cavalierpedigrees.com/XOOPS/images/text582.htm karma car    ] [http://pixsoulmedia.com/dev/images/thumbs/article779.html american me] [http://marja-leena-rathje.info/ssp_director/config/conf/article2556.html top] 
 
 
== int->bigint for the byte counting stuff ==
 
== int->bigint for the byte counting stuff ==
  

Latest revision as of 16:13, 25 July 2009

int->bigint for the byte counting stuff


clear; for t in svc_acct h_svc_acct; do for c in upbytes upbytes_threshold downbytes downbytes_threshold totalbytes totalbytes_threshold; do echo "BEGIN WORK;
ALTER TABLE $t ADD COLUMN ${c}_new bigint;
UPDATE $t SET ${c}_new = CAST($c AS bigint);
ALTER TABLE $t DROP COLUMN $c; 
ALTER TABLE $t RENAME COLUMN ${c}_new TO $c;
COMMIT WORK;
"; done; done

clear; for t in prepay_credit h_prepay_credit; do for c in upbytes downbytes totalbytes; do echo "BEGIN WORK;
ALTER TABLE $t ADD COLUMN ${c}_new bigint;
UPDATE $t SET ${c}_new = CAST($c AS bigint);
ALTER TABLE $t DROP COLUMN $c;
ALTER TABLE $t RENAME COLUMN ${c}_new TO $c;
COMMIT WORK;
"; done; done

bigger payinfo fields for encryption

ALTER TABLE cust_main ADD payinfo_new varchar(512);
UPDATE cust_main SET payinfo_new = payinfo;
ALTER TABLE cust_main DROP payinfo;
ALTER TABLE cust_main RENAME payinfo_new TO payinfo;

ALTER TABLE cust_main ADD paycvv_new varchar(512);
UPDATE cust_main SET paycvv_new = paycvv;
ALTER TABLE cust_main DROP paycvv;
ALTER TABLE cust_main RENAME paycvv_new TO paycvv;

ALTER TABLE h_cust_main ADD payinfo_new varchar(512);
UPDATE h_cust_main SET payinfo_new = payinfo;
ALTER TABLE h_cust_main DROP payinfo;
ALTER TABLE h_cust_main RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_main ADD paycvv_new varchar(512);
UPDATE h_cust_main SET paycvv_new = paycvv;
ALTER TABLE h_cust_main DROP paycvv;
ALTER TABLE h_cust_main RENAME paycvv_new TO paycvv;

ALTER TABLE cust_pay ADD payinfo_new varchar(512);
UPDATE cust_pay SET payinfo_new = payinfo;
ALTER TABLE cust_pay DROP payinfo;
ALTER TABLE cust_pay RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay ADD payinfo_new varchar(512);
UPDATE h_cust_pay SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay DROP payinfo;
ALTER TABLE h_cust_pay RENAME payinfo_new TO payinfo;


ALTER TABLE cust_pay_void ADD payinfo_new varchar(512);
UPDATE cust_pay_void SET payinfo_new = payinfo;
ALTER TABLE cust_pay_void DROP payinfo;
ALTER TABLE cust_pay_void RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay_void ADD payinfo_new varchar(512);
UPDATE h_cust_pay_void SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay_void DROP payinfo;
ALTER TABLE h_cust_pay_void RENAME payinfo_new TO payinfo;


ALTER TABLE cust_pay_batch ADD payinfo_new varchar(512);
UPDATE cust_pay_batch SET payinfo_new = payinfo;
ALTER TABLE cust_pay_batch DROP payinfo;
ALTER TABLE cust_pay_batch RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_pay_batch ADD payinfo_new varchar(512);
UPDATE h_cust_pay_batch SET payinfo_new = payinfo;
ALTER TABLE h_cust_pay_batch DROP payinfo;
ALTER TABLE h_cust_pay_batch RENAME payinfo_new TO payinfo;


ALTER TABLE cust_refund ADD payinfo_new varchar(512);
UPDATE cust_refund SET payinfo_new = payinfo;
ALTER TABLE cust_refund DROP payinfo;
ALTER TABLE cust_refund RENAME payinfo_new TO payinfo;

ALTER TABLE h_cust_refund ADD payinfo_new varchar(512);
UPDATE h_cust_refund SET payinfo_new = payinfo;
ALTER TABLE h_cust_refund DROP payinfo;
ALTER TABLE h_cust_refund RENAME payinfo_new TO payinfo;

bigger _password fields for weird LDAP encodings

ALTER TABLE svc_acct ADD _password_new varchar(512) NOT NULL;
UPDATE svc_acct SET _password_new = _password;
ALTER TABLE svc_acct DROP _password;
ALTER TABLE svc_acct RENAME _password_new TO _password;

ALTER TABLE h_svc_acct ADD _password_new varchar(512) NOT NULL;
UPDATE h_svc_acct SET _password_new = _password;
ALTER TABLE h_svc_acct DROP _password;
ALTER TABLE h_svc_acct RENAME _password_new TO _password;

Issues with freeside-upgrade

I had lots of issues while trying to run freeside-upgrade. The fix I finally made work was to run the script as follows

freeside-upgrade -d username > dbupdatefile

and then manually dump the dbupdatefile to psql

psql -f dbupdatefile

It would be helpful if you could document said "issues" here, or in the forum, or on the mailing list, rather than only documenting their existence and a workaround. That way someone encountering the same problem might provide a fix so that the script works as intended for you. FWIW, freeside-upgrade has worked for myself and others for many upgrades to date.