One client account shows Service ID Not Found unless product is clicked from Summary view

[hekg]

I have one client's account that is erratic becasue the 'products' tab shows Service ID Not Found. But if I add a new product to his account then all other products do once again show up in the products tab.

 

Then if I remove that test product and go back to the proudcts tab I see Service ID Not Found again.

 

The only way to see this client's services appear in the products tab is by clicking a product in the client's 'Summary' tab.

 

Please help

[hekg]

is there anybody from tech support in these forums?

[hekg]

Support dept helped me fix the problem. Here is the solution:

 

This behaviour typically suggests the service is assigned to a product that no longer exists or the packageid value is 0. Please run the following command against your WHMCS database via the SQL tab of a tool such as phpmyadmin:

 

SELECT * FROM `tblhosting`WHERE `packageid` =0

 

If it outputs any results, then it would seem to suggest my theory and you can run the following command to resolve the issue:

 

UPDATE tblhosting SET packageid = '1' WHERE packageid = '0';

 

This will assign all the affected packages to your first product (assuming productid 1 exists in the tblproducts table) so you can then view the service details and manually assign it to the correct product in the admin area.