X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FUpgrade.pm;h=aebfc29c7c0be8de7b8bd58a58991977c4543c04;hp=c959ba947f307f1bb33e5eedcaee818e6c2944c7;hb=2a9d2460814b37e07d7cb83392723146a60d34c7;hpb=c53b9ea5e995de0388c4e1973b1929626fdc29a6 diff --git a/FS/FS/Upgrade.pm b/FS/FS/Upgrade.pm index c959ba947..aebfc29c7 100644 --- a/FS/FS/Upgrade.pm +++ b/FS/FS/Upgrade.pm @@ -47,6 +47,10 @@ sub upgrade_config { my $conf = new FS::Conf; + # to simplify tokenization upgrades + die "Conf selfservice-payment_gateway no longer supported" + if $conf->config('selfservice-payment_gateway'); + $conf->touch('payment_receipt') if $conf->exists('payment_receipt_email') || $conf->config('payment_receipt_msgnum'); @@ -334,7 +338,10 @@ sub upgrade { }); foreach my $object ( @objects ) { my $payinfo = $object->decrypt($object->payinfo); - die "error decrypting payinfo" if $payinfo eq $object->payinfo; + if ( $payinfo eq $object->payinfo ) { + warn "error decrypting payinfo for $table: $payinfo\n"; + next; + } $object->payinfo($payinfo); my $error = $object->replace; die $error if $error; @@ -358,7 +365,12 @@ sub upgrade_data { #fix whitespace - before cust_main 'cust_location' => [], - #cust_main (remove paycvv from history, locations, cust_payby, etc) + # need before cust_main tokenization upgrade, + # blocks tokenization upgrade if deprecated features still in use + 'agent_payment_gateway' => [], + + #cust_main (tokenizes cards, remove paycvv from history, locations, cust_payby, etc) + # (handles payinfo encryption/tokenization across all relevant tables) 'cust_main' => [], #contact -> cust_contact / prospect_contact @@ -380,6 +392,7 @@ sub upgrade_data { # reason / void_reason migration to reasonnum / void_reasonnum 'cust_credit_void' => [], 'cust_bill_void' => [], + # also fix some tax allocation records 'cust_bill_pkg_void' => [], #duplicate history records @@ -487,6 +500,27 @@ sub upgrade_data { #mark certain taxes as system-maintained, # and fix whitespace 'cust_main_county' => [], + + #'compliance solutions' -> 'compliance_solutions' + 'tax_rate' => [], + 'tax_rate_location' => [], + + #upgrade part_event_condition_option agentnum to a multiple hash value + 'part_event_condition_option' =>[], + + #fix ip format + 'svc_circuit' => [], + + #fix ip format + 'svc_hardware' => [], + + #fix ip format + 'svc_pbx' => [], + + #fix ip format + 'tower_sector' => [], + + ; \%hash; @@ -543,15 +577,31 @@ sub upgrade_schema { sub upgrade_schema_data { my %opt = @_; + #auto-find tables/classes with an _update_schema method? + tie my %hash, 'Tie::IxHash', #fix classnum character(1) 'cust_bill_pkg_detail' => [], #add necessary columns to RT schema 'TicketSystem' => [], + #remove h_access_user_log if it exists (since our regular auto schema + # upgrade doesn't have the drop tables flag turned on) + 'access_user_log' => [], #remove possible dangling records 'password_history' => [], 'cust_pay_pending' => [], + #remove records referencing removed things with their FKs + 'pkg_referral' => [], + 'cust_bill_pkg_discount' => [], + 'cust_msg' => [], + 'cust_bill_pay_batch' => [], + 'cust_event_fee' => [], + 'radius_attr' => [], + 'queue_depend' => [], + 'cust_main_invoice' => [], + #update records referencing removed things with their FKs + 'cust_pkg' => [], ; \%hash; @@ -681,4 +731,3 @@ Sure. =cut 1; -