joomla "installed at" had changed, administrative access denied

[Vampirion]

Hello,

I make it short.
- Plesk 12.5.30u16 running on Ubuntu 14.04 LTS
- Joomla installation on one domain since several years under "httpdocs"
- would made update to newest joomla version, due to security issues
- entry "Installed at" on Generel page for joomla in plesk panel says "/joomla" (picture)
- also the links for "Administrative Interface" redirect to this subdir and access is not possible

How to get rid of this issue without data loss and complete reinstall of joomla?

 

[Lev]

As far as I understand, the issue is that Plesk considers Joomla being installed at “httpdocs/joomla” directory, however, it is actually installed at “httpdocs”. If it is the case, you need to modify some parameter in Plesk database:


first, you need to check the following parameter in Plesk database:


mysql> select * from apsResourcesParameters where name='urlPrefix' and apsResourceId in (select id from apsResources where pleskId=8);

+----+---------------+-----------+------------------------+

| id | apsResourceId | name | value |

+----+---------------+-----------+------------------------+

| 40 | 13 | urlPrefix | joomla_location_folder |

+----+---------------+-----------+------------------------+

1 row in set (0.00 sec)


In this SQL query, `pleskId` is the id of the corresponding domain. Make sure it is ‘joomla’, then take the backup of Plesk database


# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > psa_db_`date +%F`.sql


Modify this parameter using SQL query. If Joomla is installed under `/var/www/vhosts/example.com/httpdocs/` then you need to set empty value for urlPrefix parameter, e.g.:


mysql> update apsResourcesParameters set value='' where id=40;

Query OK, 1 row affected (0.03 sec)

Rows matched: 1 Changed: 1 Warnings: 0


Then, open this application in Plesk interface and make sure “Installed at” value has changed.
However I would like to recommend you to create a ticket to our support queue to avoid any issues with database inconsistency.

 

[Vampirion]

Thx for the reply, that did the trick, the setting is corrected and the link to the admin interface working. Now the only thing I have to do is to check why the update script for joomla gets a non-zero exit status code. Oh man, sometimes I wanna kill this "webadmin"
Thx again for your help