• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Plesk unable to check and fix permissions

T

TheProblemxx

Guest
We have tried to inform Swsoft of bugs in Plesk 8.3.0 for win as the bugs has made several upgrade errors on our installations, but unfortunately [email protected] does not respond to our reports, nor offer a solution to the problems for some reason..?

Here´s the description:

On one of the servers the problem is severe as it has left Plesk unable to check and fix permissions.

Here´s the problem output:

Checking xxx.com...
Warning: Can't query SELECT sp.name, sa.install_prefix, sa.htdocs_directory FROM `siteapppackages` sp, `siteapps` sa, `domains` d WHERE sa.dom_type='domain' AND sp.id=sa.app_id AND sa.dom_id=d.id AND d.name='xxx.com': MySQLDatabaseProvider error 1054:Unknown column 'sa.app_id' in 'where clause'
Plesk Reconfigurator has found permissions problems on xxx.com, but was unable to fix the permissions due to the errors shown above.
Checking development.xxx.com...
Warning: Can't query SELECT sp.name, sa.install_prefix, sa.htdocs_directory FROM `siteapppackages` sp, `siteapps` sa, `domains` d, `subdomains` sd WHERE sa.dom_type='subdomain' AND sp.id=sa.app_id AND sa.dom_id=d.id AND sd.dom_id=d.id AND d.name='xxx.com' AND sd.name='development': MySQLDatabaseProvider error 1054:Unknown column 'sa.app_id' in 'where clause'
Plesk Reconfigurator has found permissions problems on development.xxx.com, but was unable to fix the permissions due to the errors shown above.
Total checked: 2.
Without security problems: 0.
With security problems: 2.


Furthermore it shows the following error on BOTH servers when entering 'webapplications' after the 8.3 upgrade:

Notice: Undefined variable: sa_rel in C:\Program Files\SWsoft\Plesk\admin\plib\SiteApps\class.SiteAppPackageManager.php on line 478


As these errors were NOT present BEFORE the 8.3 upgrade the problems are bugs in Plesk 8.3 and since Plesk has caused these problems we will naturally not pay Swsoft to have the problems fixed as we pay You to have a working product - not a product with bugs.

So please fix these problems asap or inform us on how to remove the problems
 
Hello TheProblemxx,

Thank you for the report.

TheProblemxx said:
On one of the servers the problem is severe as it has left Plesk unable to check and fix permissions.

Here´s the problem output:

Checking xxx.com...
Warning: Can't query SELECT sp.name, sa.install_prefix, sa.htdocs_directory FROM `siteapppackages` sp, `siteapps` sa, `domains` d WHERE sa.dom_type='domain' AND sp.id=sa.app_id AND sa.dom_id=d.id AND d.name='xxx.com': MySQLDatabaseProvider error 1054:Unknown column 'sa.app_id' in 'where clause'
Plesk Reconfigurator has found permissions problems on xxx.com, but was unable to fix the permissions due to the errors shown above.
Checking development.xxx.com...
Warning: Can't query SELECT sp.name, sa.install_prefix, sa.htdocs_directory FROM `siteapppackages` sp, `siteapps` sa, `domains` d, `subdomains` sd WHERE sa.dom_type='subdomain' AND sp.id=sa.app_id AND sa.dom_id=d.id AND sd.dom_id=d.id AND d.name='xxx.com' AND sd.name='development': MySQLDatabaseProvider error 1054:Unknown column 'sa.app_id' in 'where clause'
Plesk Reconfigurator has found permissions problems on development.xxx.com, but was unable to fix the permissions due to the errors shown above.
Total checked: 2.
Without security problems: 0.
With security problems: 2.
Click to expand...

We will investigate this scenario as soon as possible.

TheProblemxx said:
Furthermore it shows the following error on BOTH servers when entering 'webapplications' after the 8.3 upgrade:

Notice: Undefined variable: sa_rel in C:\Program Files\SWsoft\Plesk\admin\plib\SiteApps\class.SiteAppPackageManager.php on line 478
Click to expand...

This is known issue.
Please upload updated module class.SiteAppPackageManager.php and copy it to folder %plesk_dir%admin\plib\SiteApps.
Please backup old module before copying.
 
"This is known issue.
Please upload updated module class.SiteAppPackageManager.php and copy it to folder %plesk_dir%admin\plib\SiteApps.
Please backup old module before copying."


This did not solve the problem but made it worse as it now instead of the line with error now says: "error500 internal servererror"

What do we do now?

The problem with the permissions were solved with the suggested solution.
 
It also seems as if the previous license for Sitebuilder 3.2 has been erased and now the license key doesn´t work anymore...
 
You must log in or register to reply here.
Back
Top