Bobcares

WeSupport

Call Us! 1-800-383-5193
Call Us! 1-800-383-5193
Call Us! 1-800-383-5193

Need Help?

Emergency Response Time custom

Our experts have had an average response time of 12.24 minutes in February 2021 to fix urgent issues.

We will keep your servers stable, secure and fast at all times for one fixed price.

Database issues in Plesk Panel – How to troubleshoot

by | Mar 9, 2021

Having a hard time dealing with database issues in the Plesk panel? We can help you with it.

Most of the database issues that we deal with in the Plesk panel mainly occur due to database misconfiguration. These errors may occur due to the updates made in the Plesk panel or due to any new software installation.

Here at Bobcares, we often receive requests relating to database issues as part of our Server Management Services for web hosts and online service providers.

Today, let’s discuss the different database issues in Plesk.

 

Different database issues in Plesk panel

Now let’s take a look at the different database errors that occur in Plesk. Also, let’s see how our Support Engineers resolve them.

Here are some of the common errors seen in the Plesk panel.

1. Database not shown in Plesk panel.
2. Unable to create subdomains due to database error.
3. Unable to delete an account.

 

Database not shown in Plesk panel

This is one of the most common errors that we have seen in the Plesk panel. Sometimes, if we create a database in the backend of the server, then the database will not be added to the Plesk PSA database and will not be displayed.

Here is how we resolve this problem.

* Taking a backup of the PSA database and adding an entry of the missing database in the PSA database. Then restart the SQL service.

* Taking SQL backup of the databases that have to be added in the Plesk front end and remove them from the back end. Then we create a new database from the Plesk Control Panel. After that, we restore it from the backup.

 

Unable to create subdomains due to database error

In some cases, while adding a subdomain, an error shows up saying that the subdomain already exists. However, we can’t find the subdomain in the Plesk panel. Also, it will not resolve the server’s IP address. This error occurs due to the mismatch in the ‘dns_zone_id’ in the Plesk database.

So, we can check this using the below SQL query.

dbclient.exe –direct-sql –sql=”select id,name from dns_zone where name=’main domain’
dbclient.exe –direct-sql –sql=”select id,name from dns_zone where name=’sub domain’

Here, if the ID from the main domain differs from the subdomain, we create this entry manually by copying details from the main domain and recreate the subdomain.

 

Unable to delete the account

Sometimes, we won’t be able to delete the Plesk user account as it will show the below error message.

Error: Unable to remove domains: Problems occurred while removing domains: Delete database user failed: The object with the name “USP_UpdateLeagueMainFeed” already exists.

This error means that there is a stored procedure named USP_UpdateLeagueMainFeed for the user.

In order to resolve this error, we follow the below steps:

1. First, we open SQL Server Management Studio and navigate to Databases >> database name >> Programmability >> Stored Procedures.
2. Next, under the permission of the stored procedure, we right-click and try to remove the user permissions.
3. Then we try to remove the database/user from Plesk.

If this is a domain deletion issue, then we follow the steps given below:

1. First, we open SQL Server Management Studio and navigate to Databases >> database name.
2. Next, we right-click on the database name and remove the database.
3. Then we add a blank database of similar names from SQL Server Management Studio and remove the domain from Plesk.

[Still, not able to fix database problems? – We’d be happy to help you]

 

Conclusion

In short, the main reason for database issues in Plesk is the misconfiguration of the PSA database. Today, we saw how our Support Engineers tackle different Plesk database errors.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

GET UP TO 25% OFF

Plesk Support

Spend time on your business, not on your servers.

Managing a server is time consuming. Whether you are an expert or a newbie, that is time you could use to focus on your product or service. Leave your server management & end-user tech support to us, and use that time to focus on the growth and success of your business.

TALK TO USOr click here to learn more.

GET UP TO 25% OFF

Plesk Support

Spend time on your business, not on your servers.

Managing a server is time consuming. Whether you are an expert or a newbie, that is time you could use to focus on your product or service. Leave your server management & end-user tech support to us, and use that time to focus on the growth and success of your business.

TALK TO USOr click here to learn more.

Categories:

Tags: