Plesk unable to check and fix permissions

[TheProblemxx]

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

 

[sergius]

Hello TheProblemxx,

Thank you for the report.

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.

We will investigate this scenario as soon as possible.

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

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.

 

[sergius]

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

Please download updated module psaobsolete.dll
and copy it to folder %plesk_bin%.
Please backup old module before copying.

Any feedback is appreciated.

 

[TheProblemxx]

"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.

 

[TheProblemxx]

It also seems as if the previous license for Sitebuilder 3.2 has been erased and now the license key doesn´t work anymore...