Change Application Instillation Path

[Zigge89]

OS: CentOS 6.5 (Final)
Panel version: 11.0.9 Update #62

Hello,

I'm looking for assistance in changing the application instillation path. I have a client whom installed WordPress through the Plesk Panel using default directory of "http://domain.ltd/wordpress". They have finished the website and I have manually moved the WordPress application into the root directory. The site is working fine, however the Plesk Panel still shows the installed application path as "/wordpress". So all the Panel application quick links are broken. In addition if the subscription is customized, Plesk Panel inserts "/wordpress" into 2 database fields (siteurl & home). Breaking the site.

I believe the fix to be found in the Plesk Panel database. However I can't find a reference to which table and fields that need to be updated.

Any help would be appreciated. Thank you.

_Zigge

 

[UFHH01]

I think you should go to "Start > WordPress-Installations" and click on the desired wordpress installation. You now may "update" the informations for this specific site with a click on "update". The Plesk Panel is now forced to update the location and it's settings and should update any stored information in the database as well.

 

[Zigge89]

I think you should go to "Start > WordPress-Installations" and click on the desired wordpress installation. You now may "update" the informations for this specific site with a click on "update". The Plesk Panel is now forced to update the location and it's settings and should update any stored information in the database as well.

Thank you for the quick reply. Would these instructions be for Plesk Panel for Windows?

The server is running Plesk Panel for Linux. If I open a subscription then go to Applications and click on the WordPress instillation, there is an Edit Settings button. However the instillation path is not one of the fields that can be updated.

Regards,

_Zigge

 

[UFHH01]

No Zigge89,

due to the fact that you are in the subcategory "Plesk Panel for Linux" I wouldn't provide suggestions for Plesk Windows.

You have a "global" / "main" Wordpress - Link, which supposed to be on the navigation on the left side of your Plesk Panel, directly under the menu item "Tools & Settings", when you log in as admin.

 

[Zigge89]

No Zigge89,

due to the fact that you are in the subcategory "Plesk Panel for Linux" I wouldn't provide suggestions for Plesk Windows.

You have a "global" / "main" Wordpress - Link, which supposed to be on the navigation on the left side of your Plesk Panel, directly under the menu item "Tools & Settings", when you log in as admin.

Sorry, this is not visible on the server. I do have Tools & Settings and when clicked a link to Application Vault is a choice. I have looked through this context screen and found no field to update the path.

I went with a hunch that the answer was in the psa database. So I did a search on database psa with all tables, using the domain name as the wildcard word. I found 4 entries inside table apsResourcesParameters. Each entry had a id, appResourceId, name and value. The value fields stuck out has they matched the outdated path "http://domain.ltd/wordpress". I modified the value of the 4 entries, removing "/wordpress". Then restarted httpd and psa services and logged back into the Plesk Panel. Going back to the Subscription and Applications, I saw the installation path was still incorrect and quick links still broken.

Getting closer.

_Zigge

 

[UFHH01]

I only found a picture from a german hoster on my quick search for that... but the picture should only point to the navigation mentioned above:

 

[Zigge89]

I only found a picture from a german hoster on my quick search for that... but the picture should only point to the navigation mentioned above:
View attachment 8961

Yes, the picture illustrates your point. However I am certain the user screenshot and yourself are running version 11.5. Please note the server version starting the thread is running version 11.0.9.

Thanks,

_Zigge

 

[option8]

Since I just finished wrestling with this myself, and this forum came up in my Google searches, I'm sharing my solution.

Note, this is on a Linux server.

As an admin user, at a terminal:

plesk db dump > PSA.sql
​

This creates a SQL dump, essentially a backup of your psa database.

Edit that (or a copy of it) looking for instances of "/wordpress" and "'wordpress'" in the following tables:

• apsResourcesParameters
• WordpressInstanceProperties
• WordpressInstances
  

Remove the relevant parts, for instance:

(145,71,'urlPrefix','wordpress') becomes (145,71,'urlPrefix','')

(14,16,'/httpdocs/wordpress',0,14) becomes (14,16,'/httpdocs',0,14)
​

Pay special attention to string lengths in variables that look like this:

... s:19:\"/httpdocs/wordpress\" ...
​

so that your updated string would be:

... s:9:\"/httpdocs\" ...


​

Once your SQL file is duly scrubbed, import it back into the psa database thus:

plesk db < PSA.sql

​

To be satisfied that your update has worked, show one of the updated tables:

plesk db show apsResourcesParameters
​

The lines with "urlPrefix" should no longer contain "wordpress".


Log into Plesk, and go to Server Management -> Wordpress.

Click on a broken installation, to edit it. Click the "Refresh" button at the top of that page. The page should now show a proper Wordpress installation in the root instead of a sub-folder.

Share and enjoy!