Restoration Of Pending Affiliate Commissions - Revision history

SarahK at 17:42, 3 May 2022

2022-05-03T17:42:14Z

SarahK at 15:35, 1 December 2021

2021-12-01T15:35:31Z

David at 16:37, 29 November 2021

2021-11-29T16:37:52Z

David at 16:36, 29 November 2021

2021-11-29T16:36:17Z

David at 15:58, 29 November 2021

2021-11-29T15:58:03Z

David: Created page with "An update routine in WHMCS 8.3.1 introduced a severe bug (CORE-17294) when using the Affiliate system with the commission delay feature.

2021-11-29T15:37:36Z

Created page with "An update routine in WHMCS 8.3.1 introduced a severe bug (CORE-17294) when using the Affiliate system with the commission delay feature. <div class="docs-alert-info"><i class..."

New page
An update routine in WHMCS 8.3.1 introduced a severe bug (CORE-17294) when using the Affiliate system with the commission delay feature.

<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>This bug only affects systems that updated directly to version 8.3.1 and that use the Affiliate system with the commission delay feature.</div>

= Overview =

The bug removes pending affiliate commission records during the update to version 8.3.1. The error occurs only once and is not persistent. WHMCS 8.3.2 provides a fix that recreates any erroneously-removed records using the invoice and commission payout history.

When you update from version 8.3.1 to 8.3.2 or later, the removed data will be restored and, in most cases, no further action will be required. For more information, see Further Considerations below.

If your system restored records as part of the upgrade, a notification banner will display in the Admin Area.

<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>The notification banner is for informational purposes only. You can dismiss it by clicking the X.</div>

= Further Considerations =

''Most users will only need to perform the update from version 8.3.1 to version 8.3.2 or higher.''

Some conditions may affect version 8.3.2's ability to recreate records.

Manually inspect the restored data if any of these conditions apply to your WHMCS installation:

== Previous Manual Deletion of Pending Commissions ==

The update will recreate any pending commission that does not have a corresponding payout history entry for the affected time frame. Because manually-removed pending commissions are not tracked in affiliate accounting records, they will be recreated with any other pending commissions.

If you normally remove pending commissions manually, you must check all of the restored records after you update. Then, manually remove the unwanted records again.

== Disabled Affiliate Systems ==

The restorative routine will not run if the affiliate system is disabled. In these cases, no automated discovery or record recreation will be performed.

If you need to know whether the routine would have restored records if the Affiliate system had been enabled, contact WHMCS Technical Support. They can analyze your database, help determine whether any pending commissions exist, and assist you in creating them.

To determine whether the affiliate system was disabled after applying the 8.3.1 update, perform these steps:

# Log in to the WHMCS Admin Area.
# Go to '''Configuration > System Logs'''.
# Use the '''Search/Filter''' tab to search for Affiliate Enabled Disabled.
# Examine the results:
* If there are no results, no further action is required.
* If there are results, check to ensure that the timestamp shows a date occurring after your update to version 8.3.1.

== Commission Delay Change ==

Decreases in the '''Commission Delay''' setting's value after you update may result in fewer restored records. The restorative routine only analyzes a limited invoice and commission history. The setting is required to determine the maximum invoice history to cross reference. The decrease will result in referencing an equally fewer number of days of history.

To determine whether the setting was lowered after updating to version 8.3.1:

# Log in to the WHMCS Admin Area.
# Go to '''Configuration > System Logs'''.
# Use the '''Search/Filter''' tab to search for Affiliate Delay Commission Changed.
# Examine the results:
* If there are no results, no further action is required.
* If there are results, check to ensure that the timestamp shows a date occuring after your update to version 8.3.1.

If you know that the setting changed, review the invoice payment history for affiliate-tracked services. To find the oldest invoice to inspect, count the previous setting's number of days, working backwards from October 26th, 2021. For example, if your delay was 30 and is now 15, inspect paid affiliate invoices from September 26th to October 11th.

<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>You can use a database backup from before your 8.3.1 update to compare the tblaffiliatespending table after the update to version 8.3.2. In most cases, the restorative routine will recreate all of the previous entries. Any entry that it did not recreate will have a correlative entry in the tblaffiliatehistory table clearing the pending amount. If an entry is still missing, check for the above conditions.</div>

WHMCS Technical Support is available to assist with and address any concerns or questions you may have.

NOTOC

@@ Line 1: / Line 1: @@
-An update routine in WHMCS 8.3.1 introduced a bug (CORE-17294) when using the Affiliate system with the commission delay feature.
+An update routine in WHMCS 8.3.1 introduced a bug (CORE-17294) when using the [[Affiliates|Affiliate]] system with the commission delay feature.
-<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>This bug only affects systems that updated directly to version 8.3.1 and that use the Affiliate system with the commission delay feature.</div>
+<div class="docs-alert-info">
-=Overview=
+==Overview==
-The bug removes pending affiliate commission records during the update to version 8.3.1. The error occurs only once and is not persistent. WHMCS 8.3.2 provides a fix that recreates any erroneously-removed records using the invoice and commission payout history.
+The bug removes pending affiliate commission records during the update to WHMCS 8.3.1. The error occurs only once and is not persistent. WHMCS 8.3.2 provides a fix that recreates any erroneously-removed records using the invoice and commission payout history.
-When you update from version 8.3.1 to 8.3.2 or later, the removed data will be restored and, in most cases, no further action will be required. For more information, see '''Further Considerations''' below.
+When you update from WHMCS 8.3.1 to 8.3.2 or later, the removed data will be restored and, in most cases, no further action will be required. For more information, see [[#Further Considerations|Further Considerations]] below.
 If your system restored records as part of the upgrade, a notification banner will display in the Admin Area.
-<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>The notification banner is for informational purposes only. You can dismiss it by clicking the '''X'''.</div>
+<div class="docs-alert-info">
-=Further Considerations=
+==Further Considerations==
-<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>Most users will only need to perform the update from version 8.3.1 to version 8.3.2 or higher.</div>
+<div class="docs-alert-info">
-Some conditions may affect version 8.3.2's ability to recreate records.
+Some conditions may affect WHMCS 8.3.2's ability to recreate records. Manually inspect the restored data if any of these conditions apply to your WHMCS installation:
-Manually inspect the restored data if any of these conditions apply to your WHMCS installation:
+===Previous Manual Deletion of Pending Commissions===
 The update will recreate any pending commission that does not have a corresponding payout history entry for the affected time frame. Because manually-removed pending commissions are not tracked in affiliate accounting records, they will be recreated with any other pending commissions.
@@ Line 27: / Line 31: @@
 If you normally remove pending commissions manually, you must check all of the restored records after you update. Then, manually remove the unwanted records again.
-==Disabled Affiliate Systems==
+===Disabled Affiliate Systems===
 The restorative routine will not run if the affiliate system is disabled. In these cases, no automated discovery or record recreation will be performed.
@@ Line 36: / Line 40: @@
 # Log in to the WHMCS Admin Area.
-# Go to '''Configuration (<i class="fa fa-wrench" aria-hidden="true"></i>) > System Logs'''.
+# Go to '''Configuration (<i class="fa fa-wrench" aria-hidden="true"></i>) > [[System Logs]]'''.
 # Use the '''Search/Filter''' tab to search for <tt>Affiliate Enabled Disabled</tt>.
 # Examine the results:
 #* If there are no results, no further action is required.
-#* If there are results, a entry date after your update to version 8.3.1 indicates that your system was enabled at the time of the update.
+#* If there are results, a entry date after your update to WHMCS 8.3.1 indicates that your system was enabled at the time of the update.
-==Commission Delay Change==
+===Commission Delay Change===
 Decreases in the '''Commission Delay''' setting's value after you update may result in fewer restored records. The restorative routine only analyzes a limited invoice and commission history. The setting is required to determine the maximum invoice history to cross reference. The decrease will result in referencing an equally fewer number of days of history.
-To determine whether the setting was lowered after updating to version 8.3.1:
+To determine whether the setting was lowered after updating to WHMCS 8.3.1:
 # Log in to the WHMCS Admin Area.
-# Go to '''Configuration (<i class="fa fa-wrench" aria-hidden="true"></i>) > System Logs'''.
+# Go to '''Configuration (<i class="fa fa-wrench" aria-hidden="true"></i>) > [[System Logs]]'''.
 # Use the '''Search/Filter''' tab to search for <tt>Affiliate Delay Commission Changed</tt>.
 # Examine the results:
 #* If there are no results, no further action is required.
-#* If there are results, a entry date after your update to version 8.3.1 indicates that your setting was altered after update.
+#* If there are results, a entry date after your update to WHMCS 8.3.1 indicates that your setting was altered after update.
 If you know that the setting changed, review the invoice payment history for affiliate-tracked services. To find the oldest invoice to inspect, count the previous setting's number of days, working backwards from October 26th, 2021. For example, if your delay was 30 and is now 15, inspect paid affiliate invoices from September 26th to October 11th.
-<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>You can use a database backup from before your 8.3.1 update to compare the tblaffiliatespending table after the update to version 8.3.2. In most cases, the restorative routine will recreate all of the previous entries. Any entry that it did not recreate will have a correlative entry in the tblaffiliatehistory table clearing the pending amount. If an entry is still missing, check for the above conditions.</div>
+<div class="docs-alert-info">
 WHMCS Technical Support is available to assist with and address any concerns or questions you may have.

← Older revision		Revision as of 15:58, 29 November 2021
Line 1:		Line 1:
−	An update routine in WHMCS 8.3.1 introduced a ~~severe~~ bug (CORE-17294) when using the Affiliate system with the commission delay feature.	+	An update routine in WHMCS 8.3.1 introduced a bug (CORE-17294) when using the Affiliate system with the commission delay feature.

	<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>This bug only affects systems that updated directly to version 8.3.1 and that use the Affiliate system with the commission delay feature.</div>		<div class="docs-alert-info"><i class="fa fa-info-circle fa-fw"></i>This bug only affects systems that updated directly to version 8.3.1 and that use the Affiliate system with the commission delay feature.</div>

@@ Line 37: / Line 37: @@
 # Log in to the WHMCS Admin Area.
 # Go to '''Configuration > System Logs'''.
-# Use the '''Search/Filter''' tab to search for Affiliate Enabled Disabled.
+# Use the '''Search/Filter''' tab to search for "Affiliate Enabled Disabled".
 # Examine the results:
 * If there are no results, no further action is required.
-* If there are results, check to ensure that the timestamp shows a date occurring after your update to version 8.3.1.
+* If there are results, a entry date after your update to version 8.3.1 indicates that your system was enabled at the time of the update.
 == Commission Delay Change ==