This article covers how to fix PHP has encountered an Access Violation which occurs in the Windows server with the Plesk control panel.
Do a copy libmysql.dll from C:\Program Files (x86)\SWsoft\Plesk\Additional\PleskPHP5 to C:\WINDOWS\system32
Wait for few minutes and it should fix the issue.
To fix PHP has encountered an Access Violation at XXXXX in Plesk:
1. Connect to the server via SSH.
2. Create a backup of the psa database:
plesk db dump psa > /root/psa_backup.sql
3. Download the attached script:
$ wget https://plesk.zendesk.com/hc/article_attachments/115001860533/script_kb213376309
4. Make the script executable:
$ chmod +x script_kb213376309
5. Launch the script for the affected subscription:
Note: change the "example.com" website in the command below to the correct one.
$ ./script_kb213376309 example.com
6. If an error like below appears:
ERROR 1062 (23000) at line 5: Duplicate entry '123-789' for key 'PRIMARY' exit status 1
find the duplicate record in the database:
Note: change the "123" ipCollectionId in the command below to the correct one based on the error message regarding the duplicate entry.
plesk db "select * from IpAddressesCollections where ipCollectionId=123;"
7. Remove the duplicate record from the database:
Note: change the "123" ipCollectionId in the command below to the correct one based on the error message regarding the duplicate entry
Change the "456" ipAddressId in the command below to the correct one based on the output from the previous step.
$ plesk db "delete from IpAddressesCollections where ipCollectionId=123 and ipAddressId=456;"