Applicable to:
- Plesk 12.5 for Linux
- Plesk 11.x for Windows
- Plesk 12.5 for Windows
Symptoms
Error while accessing Plesk from WHMCS via API
CONFIG_TEXT: Error code: 1013. Error message: Customer with external id 'whmcs_plesk_XX' is not found in panel.
Cause
external_id
entry is missing for Plesk user
abcd
in PSA
clients
table.
Resolution
- Login to Plesk database.
-
Update the following value:
MYSQL_LIN: mysql> update clients set external_id='whmcs_plesk_XX' where login='abcd';
Note: if the issue appears on a WHMCS integrated with Plesk Multi Server, this database update should be done on the management node side.
To see all client accounts without external_id, this query can be used:
MYSQL_LIN: 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';
Comments
5 comments
when i execute this i got ERROR 1046 (3D000): No database selected
what is the name of database?
i solve with this:
http://kb.odin.com/en/123492
@Felipe, you might have not logged in to the Plesk database properly. I have added this step to the article. Thanks for the reporting.
Reproduced same issue on Plesk Onyx 17.5 on Windows Server 2012 R2
External ID-s are lost on every Plesk Onyx Update (happened 2x times withing last month)
@Kotso, Can you please clarify whether the issue is reproduced after forcing Plesk to reinstall microupdates with the command below:
plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
Please, do not forget to make a dump of Plesk database. using this KB article https://support.plesk.com/hc/en-us/articles/213904125-How-to-backup-restore-a-Plesk-database-dump
Please sign in to leave a comment.