Page History

...

If you are upgrading an existing system, be prepared to run the following commands in the ofbiz home directory:

• svn up or git pull

• ./gradlew clean

• ./gradlew "ofbiz --load-data readers=seed"
• ./gradlew ofbiz

...

R691362 Fix an issue in artifactInfo reported on user ML

R1805961 "Manage life span of marketing related

R691380 Some changes related to GeoPoint have slipped in in r691362

R1805961 "Manage life span of marketing related

1. Drop the SimpleTaxLookup from you production DB (subsidiary as it's probably already not used)
2. upgrade to at least R691380 and restart the system.

...

ALTER TABLE PRODUCT DROP MANUFACTURER_PARTY_ID;

R1805961

...

Manage life span of marketing related entities

Jira
server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-9550

This added the fromDate, and thruDate fields to the MarketingCampaignPrice, MarketingCampaignPromo, MarketingCampaignRole entities, fromDate is a PK field.

...

UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_SAGEPAY' WHERE payment_gateway_config_type_id = 'SAGEPAY';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_AUTH_NET' WHERE payment_gateway_config_type_id = 'AUTHORIZE_NET';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_CYBERSRC' WHERE payment_gateway_config_type_id = 'CYBERSOURCE';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_EWAY' WHERE payment_gateway_config_type_id = 'EWAY';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_PAYFLOWPRO' WHERE payment_gateway_config_type_id = 'PAYFLOWPRO';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_PAYPAL' WHERE payment_gateway_config_type_id = 'PAYPAL';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_CLRCOMRC' WHERE payment_gateway_config_type_id = 'CLEARCOMMERCE';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_WORLDPAY' WHERE payment_gateway_config_type_id = 'WORLDPAY';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_ORBITAL' WHERE payment_gateway_config_type_id = 'ORBITAL';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_SECUREPAY' WHERE payment_gateway_config_type_id = 'SECUREPAY';
UPDATE Payment_Gateway_Config SET payment_gateway_config_type_id = 'PAY_GATWY_IDEAL' WHERE payment_gateway_config_type_id = 'IDEAL';

R1812383: Manage life span of SecurityGroupPermission entity   

...

UPDATE security_group_permission SET from_date='2000-01-01 00:00:00';
ALTER TABLE security_group_permission
  DROP PRIMARY KEY
  ADD PRIMARY KEY (group_id, permission_id, from_date)

R1858479:

...

Jira
server ASF JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-10921

Person entity's maritalStatus field has been changed from indicator to Enumeration to manage various classification of legal marital status.
After upgrate migrateMaritalStatusFromIndicatorToEnum service(committed at R1864215) can be used to upgrade existing data of maritalStatus field to the new maritalStatusEnumId.

R1866558:

Jira
server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-11182

PicklistStatus replace PicklistStatusHistory (this has been rename OldPicklistStatusHistory) to be support natively by entityauto engine lije other EntityStatus.

After upgrate migrateOldPicklistStatusHistoryToPickListStatus service can be used to forward  historical data present in PicklistStatusHistory to PicklistStatus.

Commits e7b3169, f906994: Rename some connoted words like blacklist and whitelist

Jira
server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-12168

After upgrate the migrateOldOrderBlacklistAndOldOrderBlacklistType service can be used to forward  historical data from OrderBlacklist and OrderBlacklistType entities to new OrderDenylist and OrderDenylistType entities

Commit d288e12: Change GeoPoint latitude an longitude fields from type short-varchar to fixed-point for correct comparisons https://github.com/apache/ofbiz-framework/pull/220