Wordpress incorrect location

Created:

2016-11-16 12:55:13 UTC

Modified:

2017-08-08 13:32:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Wordpress incorrect location

Applicable to:

  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Symptoms

WordPress is shown to be installed in '/', but in fact, is installed in '/wordpress'.

Cause

Database inconsistency.

Resolution

  1. Backup psa and apsc databases: # 881
  2. Login to plesk database: # 3472
  3. Find the id of affected domain:

    mysql> select id from domains where name="example.com";
    +----+
    | id |
    +----+
    | 11 |
    +----+
  4. Determine apsResourceId :

    mysql> select * from apsResources where pleskId=11 and pleskType='hosting';
    +----+--------------------------------------+-----------+---------+
    | id | registryId | pleskType | pleskId |
    +----+--------------------------------------+-----------+---------+
    | 13 | 603bf709-15ab-4c55-b11c-33c0bd1a6b5e | hosting | 11 |
    +----+--------------------------------------+-----------+---------+
    1 row in set (0.00 sec)

where pleskId - domain id in domains table

  1. Find the name of directory wordpress is installed to:

    mysql> select * from apsResourcesParameters where apsResourceId=13 and name="urlPrefix";
    +----+---------------+---------------+-------------+
    | id | apsResourceId | name | value |
    +----+---------------+---------------+-------------+
    | 37 | 13 | urlPrefix | wordpress |
    +----+---------------+---------------+-------------+
    1 row in set (0.00 sec)
  2. Change urlPrefix value to '' manually:

    mysql> select * from apsResourcesParameters where apsResourceId=13 and name="urlPrefix";
    +----+---------------+---------------+-------------+
    | id | apsResourceId | name | value |
    +----+---------------+---------------+-------------+
    | 37 | 13 | urlPrefix | |
    +----+---------------+---------------+-------------+
    1 row in set (0.00 sec)
Have more questions? Submit a request
Please sign in to leave a comment.