Client error in front end

[SamRudd1152]

One client gets this error. The rest of the clients don't have this problem. 

 

Error: TypeError: WHMCS\Service\Addon::getServiceActual(): Return value must be of type WHMCS\Service\Service, null returned in /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/Service/Addon.php:0 Stack trace: #0 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/Product/AdHocAddon.php(0): WHMCS\Service\Addon->getServiceActual() #1 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/Service/Addon.php(0): WHMCS\Product\AdHocAddon::factory() #2 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/User/Client.php(0): WHMCS\Service\Addon->getServiceProduct() #3 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/illuminate/database/Concerns/BuildsQueries.php(39): WHMCS\User\Client->WHMCS\User\{closure}() #4 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/illuminate/support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->chunk() #5 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/illuminate/database/Eloquent/Relations/Relation.php(385): Illuminate\Database\Eloquent\Relations\Relation->forwardCallTo() #6 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/User/Client.php(0): Illuminate\Database\Eloquent\Relations\Relation->__call() #7 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/ClientArea.php(0): WHMCS\User\Client->hasItemsWithOnDemandRenewalCapability() #8 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/ClientArea.php(0): WHMCS\ClientArea::getConditionalLinks() #9 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/ClientArea.php(0): WHMCS\ClientArea->outputWithoutExit() #10 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/whmcs/whmcs-foundation/lib/Http/Message/AbstractViewableResponse.php(0): WHMCS\ClientArea->getOutputContent() #11 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/laminas/laminas-httphandlerrunner/src/Emitter/SapiEmitter.php(41): WHMCS\Http\Message\AbstractViewableResponse->getBody() #12 /home/devonwebs/domains/my.devonwebs.uk/public_html/vendor/laminas/laminas-httphandlerrunner/src/Emitter/SapiEmitter.php(31): Laminas\HttpHandlerRunner\Emitter\SapiEmitter->emitBody() #13 /home/devonwebs/domains/my.devonwebs.uk/public_html/clientarea.php(0): Laminas\HttpHandlerRunner\Emitter\SapiEmitter->emit() #14 {main}

 

 

[WHMCS John]

Hi @SamRudd1152,

This error is related to a product addon. Does this client have a particular product addon under one of the products/services in their account, that others do not?

[SamRudd1152]

This customer has no addons to any products 

[WHMCS John]

Hi @SamRudd1152,

Please can you run this query and share the result?

SELECT * FROM `tblhostingaddons` WHERE `hostingid` NOT IN (select id from tblhosting);

Take care to remove any PII before sharing the output publicly here.

[SamRudd1152]

I removed 4 entries from the addons stable that wasn't showing in the clients account and it now seems to be resolved. I think the database didn't remove something upon deletion 

[WHMCS John]

Hi @SamRudd1152,

This indicates those ad-hoc addons were orphaned. The service to which the addon belongs must have been deleted without first removing the addon.

These orphaned records can be recovered by associating it with an active service under the client's account:

UPDATE `tblhostingaddons` SET `hostingid` = 'x' WHERE addonid = 'y';

Replace x with the value of a tblhosting.id value of one of the client's active services. Replace y with the tblhostingaddons.addonid value(s) of the orphaned addons.

As always, before making changes to the database, please backup.