X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FUpgrade.pm;h=3e041279524faa5d7f61e067affd8f95e1799641;hb=f46033677220ff936a12d91b5e41ca1098356b5c;hp=7fbbbaaeca06931c7fe4319070d7bfc0c7df2f8e;hpb=e328428724f2274144fb3e33704131ba70d20016;p=freeside.git diff --git a/FS/FS/Upgrade.pm b/FS/FS/Upgrade.pm index 7fbbbaaec..3e0412795 100644 --- a/FS/FS/Upgrade.pm +++ b/FS/FS/Upgrade.pm @@ -338,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; @@ -368,7 +371,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 @@ -396,10 +404,6 @@ sub upgrade_data { #duplicate history records 'h_cust_svc' => [], - # need before transaction tables, - # blocks tokenization upgrade if deprecated features still in use - 'agent_payment_gateway' => [], - #populate cust_pay.otaker 'cust_pay' => [], @@ -502,6 +506,13 @@ 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' =>[], ; \%hash; @@ -558,15 +569,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;