- Plesk 12.5 for Linux
- Plesk 11.x for Windows
- Plesk 12.5 for Windows
Error while accessing Plesk from WHMCS via API as customer with login johndoe
CONFIG_TEXT: Error code: 1013. Error message: Customer with external id 'whmcs_plesk_XX' is not found in panel.
entry is missing in
psa.clients MySQL table.
Note: To view all orphaned client accounts (which has no or invalid external_id),the following MySQL query can be used:
mysql> select id,cname,pname,login from clients where parent_id = 1 and (external_id = NULL or external_id = '0' or external_id = '') and clients.type <> 'reseller';
Note: if the issue appears on a WHMCS integrated with Plesk Multi Server, this database update should be done on the management node side.
- Access Plesk database from command line:
# plesk db
Update the following value:
MYSQL_LIN: mysql> update clients set external_id='whmcs_plesk_XX' where login='johndoe';
where whmcs_plesk_XX - should be replaced with ID from the error
johndoe - should be replaced with login of the customer affected by the issue.